java dbcp配置_【跟我学apache-commons（三）】DBCP2.2---JavaSE配置DBCP连接池

package com.laifucard.test.test_dbcp2;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.util.Properties;

import org.apache.commons.dbcp2.BasicDataSource;

import org.apache.commons.dbcp2.BasicDataSourceFactory;

/**

* @ClassName: Test

* @Description:

* @author chenjazz@foxmail.com

* @date 2015年6月11日 下午2:16:32

*/

public class Test {

public static void main(String[] args) throws Exception {

// 1.获取数据源BasicDataSource(两种方式1-直接set 2-从外部文件 两种方式如下)

// BasicDataSource bs = new BasicDataSource();

// bs.setDriverClassName("com.mysql.jdbc.Driver");

// bs.setUsername("root");

// bs.setPassword("123456");

// bs.setUrl("jdbc:mysql://localhost:3306/person?useUnicode=true&characterEncoding=utf-8");

Properties pro = new Properties();

pro.load(Test.class.getClassLoader().getResourceAsStream("DB.properties"));

BasicDataSource bs = BasicDataSourceFactory.createDataSource(pro);

// 2.获取连接Connection

Connection conn = bs.getConnection();

// 3.获取PreparedStatement

PreparedStatement ps = conn.prepareStatement("select * from meet_user LIMIT 0,6");

// 4.获取结果集ResultSet

ResultSet rs = ps.executeQuery();

while (rs.next()) {

for (int i = 1; i <= 3; i++) {

System.out.print(rs.getString(i) + " ");

}

System.out.println();

}

// 5.关闭结果集、预处理、连接、数据源

rs.close();

ps.close();

conn.close();

bs.close();

}

}

数据库配置文件为