配置文件c3p0-config
<?xml version="1.0" encoding="UTF-8" ?>
<c3p0-config>
<default-config>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jdbcUrl">jdbc:mysql://localhost:3306/myemp?characterEncoding=utf8</property>
<property name="user">root</property>
<property name="password">123456</property>
</default-config>
</c3p0-config>
导包 c3p0-0.9.1.2
工具类
public class ConnectionUtils {
private static ComboPooledDataSource cpds=new ComboPooledDataSource();
public static Connection getConnection() throws SQLException {
return cpds.getConnection();
}
public static ComboPooledDataSource getDataSource(){
return cpds;
}
}
还要写个相关的beans 类
public class QueryRunnerTest {
//使用无参数的QueryRunner
public void fun1() throws SQLException {
String sql="select * from worker";
QueryRunner runner=new QueryRunner();//事物手动控制
Connection con= ConnectionUtils.getConnection();
List<Worker> list=runner.query(con,sql,new BeanListHandler<Worker>(Worker.class));
System.out.println(list);
}
//使用有参数的QueryRunner
public void fun2() throws SQLException {
String sql="select * from worker where id=?";
QueryRunner runner=new QueryRunner(ConnectionUtils.getDataSource());//事物自动控制
List<Worker> list=runner.query(sql,new BeanListHandler<Worker>(Worker.class),2);
System.out.println(list);
}
public static void uFun2() throws Exception{
String sql="insert into dept values(10,'ACCOUNTING','ShangHai')";
QueryRunner runner=new QueryRunner(ConntionUtils.getDatesouce());
System.out.println(runner.update(sql));
}
}