C3P0简单配置

最新推荐文章于 2019-03-09 22:04:58 发布

openBlog

最新推荐文章于 2019-03-09 22:04:58 发布

阅读量593

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/openblogs/article/details/20646847

版权

数据库专栏收录该内容

21 篇文章 1 订阅

订阅专栏

C3P0简单配置：

public class C3p0Test {
	
	@Test
	public void test1(){
		
		ComboPooledDataSource cpds = new ComboPooledDataSource("robbin");
		
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		
		try {
		
			conn= cpds.getConnection();
			stmt = conn.prepareStatement("select * from user");
			rs = stmt.executeQuery();
			
			while(rs.next()){
				String name = rs.getString("name");
				String money = rs.getString("money");
				System.out.println( " name : " + name +", money : " + money);
			}
		} catch (Exception e) {
			
			e.printStackTrace();
		}finally{
			JdbcUtils.release(rs, stmt, conn);
		}
		
	}
	
	@Test
	public void test2(){
		
		ComboPooledDataSource cpds = new ComboPooledDataSource();
		
		Connection conn = null;
		PreparedStatement stmt = null;
		ResultSet rs = null;
		
		try {
			
			
			// 设置 连接数据库的 基本信息 
			cpds.setDriverClass("com.mysql.jdbc.Driver");
			cpds.setJdbcUrl("jdbc:mysql://localhost:3309/bank");
			cpds.setUser("root");
			cpds.setPassword("root");
			
			conn= cpds.getConnection();
			
			stmt = conn.prepareStatement("select * from account");
			rs = stmt.executeQuery();
			
			while(rs.next()){
				String name = rs.getString("name");
				String money = rs.getString("money");
				System.out.println( " name : " + name +", money : " + money);
			}
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			JdbcUtils.release(rs, stmt, conn);
		}
		
	}
}

XML配置c3p0-config.xml

<c3p0-config>
	<default-config>
		<property name="driverClass">com.mysql.jdbc.Driver</property>
		<property name="jdbcUrl">jdbc:mysql://localhost:3309/bank</property>
		<property name="user">root</property>
		<property name="password">root</property>
	</default-config> 
	
	
</c3p0-config>