package com.imooc.jdbc.demo1;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import org.junit.Test;

import com.imooc.jdbc.utils.JDBCUtils;

import com.imooc.jdbc.utils.JDBCUtils2;

import com.mchange.v2.c3p0.ComboPooledDataSource;

/**

 * 连接池测试类

 * 

 * @author dong

 *

 */

public class DataSourceDemo1 {

@Test

/**

* 手动设置连接池

*/

public void demo() {

// 获得链接

Connection conn = null;

PreparedStatement pstmt = null;

ResultSet rs = null;

try {

// 创建连接池

ComboPooledDataSource dataSource = new ComboPooledDataSource();

// 设置连接池参数

dataSource.setDriverClass("com.mysql.jdbc.Driver");

dataSource.setJdbcUrl("jdbc:mysql:///jdbctest");

dataSource.setUser("root");

dataSource.setPassword("xxx");

//最大连接数

dataSource.setMaxPoolSize(20);

//初始化时连接池内有多少个连接

dataSource.setInitialPoolSize(3);

// 获得连接

conn = dataSource.getConnection();

// 编写SQL

String sql = "select * from course";

// 预编译SQL

pstmt = conn.prepareStatement(sql);

// 设置参数，执行SQl

rs = pstmt.executeQuery();

while (rs.next()) {

System.out.println(rs.getInt("id") + "  " + rs.getString("name") + "  " + rs.getString("category")

+ "  " + rs.getString("desp"));

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

} finally {

JDBCUtils.release(rs, pstmt, conn);

}

}

@Test

/**

* 使用配置文件的方式

* 

*/

public void demo1() {

Connection conn = null;

PreparedStatement pstmt =null;

ResultSet rs = null;

try {

//获得连接

//ComboPooledDataSource dataSource = new ComboPooledDataSource();

//conn = dataSource.getConnection();

conn = JDBCUtils2.getConnection();

// 编写SQL

String sql = "select * from course";

// 预编译SQL

pstmt = conn.prepareStatement(sql);

// 设置参数，执行SQl

rs = pstmt.executeQuery();

while (rs.next()) {

System.out.println(rs.getInt("id") + "  " + rs.getString("name") + "  " + rs.getString("category")

+ "  " + rs.getString("desp"));

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}finally {

JDBCUtils2.release(rs, pstmt, conn);

}

}

}