C3P0快速搭建oracle数据库查询demo

1.c3p0-config.xml 配置

<?xml version="1.0" encoding="UTF-8"?>
<c3p0-config>
	<default-config>
		<property name="driverClass">oracle.jdbc.driver.OracleDriver</property>
		<property name="jdbcUrl"> jdbc:oracle:thin:@localhost:1521:LOCALHOST
		</property>
		<property name="user">admin</property>
		<property name="password">admin</property>
		<property name="initialPoolSize">10</property>
		<property name="maxIdleTime">30</property>
		<property name="maxPoolSize">50</property>
		<property name="minPoolSize">10</property>
		<property name="maxStatements">200</property>
	</default-config>
</c3p0-config>

2.ConnectionFactory 数据库连接池

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.mchange.v2.c3p0.ComboPooledDataSource;

public class ConnectionFactory2 {
	private static DataSource dataSources = new ComboPooledDataSource();

	public static DataSource getDataSources() {
		return dataSources;
	}

	public static Connection getConnenection() {
		try {
			return dataSources.getConnection();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return null;
	}

	// 关闭资源
	public static void close(Connection conn,
			PreparedStatement preparedStatement, ResultSet rs) {
		try {
			if (rs != null)
				rs.close();
			if (preparedStatement != null)
				preparedStatement.close();
			if (conn != null)
				conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}

3.Dao调用

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

import org.wdl.com.util.ConectionFactory;

public class BaseDaoImp {
	public void execSql(String sql) {
		Connection connenection = null;
		PreparedStatement prepareStatement = null;
		ResultSet executeQuery = null;
		try {
			connenection = ConnectionFactory2.getConnenection();
			prepareStatement = connenection.prepareStatement(sql);
			executeQuery = prepareStatement.executeQuery(sql);
			while (executeQuery.next()) {
				System.out.println(executeQuery.getObject(2));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			ConectionFactory
					.close(connenection, prepareStatement, executeQuery);
		}
	}

	public static void main(String[] args) {
		String sql = "select * from HADOOP_TEST where id =1";
		new BaseDaoImp().execSql(sql);
	}
}