先导入jar包(commons-dbcp.jar,commons-pool.jar)
方法一: 不使用配置文件
BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName("com.mysql.jdbc.Driver");
dataSource.setUrl("jdbc:mysql://localhost/users");
dataSource.setUsername("root");
dataSource.setPassword("root");
conn = dataSource.getConnection();
String sql = "select * from user";
ps = conn.prepareStatement(sql);
......后面的省略
方法二: 使用配置文件
1 将dbcp.properties这个配置文件放在src根目录下
2 修改dbcp.properties中:
#连接设置
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/jdbc
username=root
password=root
3 class文件(.java):
Properties properties = new Properties();
properties.load(new FileInputStream("src/dbcp.properties"));
DataSource dataSource = BasicDataSourceFactory.createDataSource(properties);
conn = dataSource.getConnection();
String sql = "select * from user";
pstmt = conn.prepareStatement(sql);
...