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);
}
}