本文共 2991 字,大约阅读时间需要 9 分钟。
1.拷贝jar文件
2.直接在代码里面进行配置:package com.DBCP;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.SQLException;import org.apache.commons.dbcp.BasicDataSource;import org.junit.Test;import com.util.JDBCUtil;public class DBCPDemo { @Test public void testDBCP01() { Connection conn = null; PreparedStatement ps = null; try { //1.获取数据源 BasicDataSource dataSource = new BasicDataSource(); //表明 数据库类型 以及用户的信息 dataSource.setDriverClassName("com.mysql.cj.jdbc.Driver"); dataSource.setUrl("jdbc:mysql://localhost/bank"); dataSource.setUsername("root"); dataSource.setPassword("admin"); //2.获取连接对象 conn= dataSource.getConnection(); String sql = "insert into account values(null,?,?)"; ps = conn.prepareStatement(sql); ps.setString(1, "zhaoliu"); ps.setInt(2, 2000); ps.executeUpdate(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); }finally { JDBCUtil.release(conn, ps); } }}
3.使用配置文件进行配置
文件名:dbcpconfig.properties#连接设置driverClassName=com.mysql.jdbc.Driverurl=jdbc:mysql://localhost:3306/bankusername=rootpassword=admin# initialSize=10#最大连接数量maxActive=50# maxIdle=20# minIdle=5# maxWait=60000#JDBC驱动建立连接时附带的连接属性属性的格式必须为这样:[属性名=property;] #注意:"user" 与 "password" 两个属性会被明确地传递,因此这里不需要包含他们。connectionProperties=useUnicode=true;characterEncoding=gbk#指定由连接池所创建的连接的自动提交(auto-commit)状态。defaultAutoCommit=true#driver default 指定由连接池所创建的连接的事务级别(TransactionIsolation)。#可用值为下列之一:(详情可见javadoc。)NONE,READ_UNCOMMITTED, READ_COMMITTED, REPEATABLE_READ, SERIALIZABLEdefaultTransactionIsolation=READ_UNCOMMITTED
代码块
package com.DBCP;import java.io.FileInputStream;import java.io.InputStream;import java.sql.Connection;import java.sql.PreparedStatement;import java.util.Properties;import javax.sql.DataSource;import org.apache.commons.dbcp.BasicDataSource;import org.apache.commons.dbcp.BasicDataSourceFactory;import org.junit.Test;import com.util.JDBCUtil;public class DBCPDemo02 { @Test public void testDBCP02(){ /*BasicDataSource dataSource = new BasicDataSource(); //不知道这行能不能实现。 dataSource.setConnectionProperties("dbcpconfig.properties");*/ //ResourceBundle bundler = ResourceBundle.getBundle(baseName); Connection conn = null; PreparedStatement ps = null; try { //获取dbcp连接池即获取数据源 BasicDataSourceFactory factory = new BasicDataSourceFactory(); Properties properties = new Properties(); // InputStream is = new FileInputStream("src//dbcpconfig.properties"); //导入配置文件 InputStream is = getClass().getClassLoader().getResourceAsStream("dbcpconfig.properties"); properties.load(is); DataSource dataSource = factory.createDataSource(properties); //2. 得到连接对象 conn = dataSource.getConnection(); String sql = "insert into account values(null , ? , ?)"; ps = conn.prepareStatement(sql); ps.setString(1, "zhoaliu"); ps.setInt(2, 200); ps.executeUpdate(); } catch (Exception e) { e.printStackTrace(); }finally { JDBCUtil.release(conn, ps); } } }``
转载地址:http://ldgwi.baihongyu.com/