Java 使用 DBCP mysql 连接池 做数据库操作

需要的jar包有 commons-dbutils , commons-dbcp , commons-pool , mysql-connector-java 

本地database.propertties 配置为

driverClass=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost/mydatabase?useUnicode=true&characterEncoding=GBK
username=root
password=***

该文件创建在src根目录下

 

首先做一个DBCP工具类

package JDBCDemo;

import java.io.IOException;
import java.io.InputStream;
import java.util.Properties;

import javax.activation.DataSource;

import org.apache.commons.dbcp.BasicDataSource;

public class DBCPUtils {
    private DBCPUtils() {};
    private static BasicDataSource dbs = new BasicDataSource();
    private static String className="";
    private static String sqlUrl="";
    private static String sqlUser="";
    private static String sqlPassword="";
    static {
        initConfig();
        //设置基本信息
        dbs.setDriverClassName(className);
        dbs.setUrl(sqlUrl);
        dbs.setUsername(sqlUser);
        dbs.setPassword(sqlPassword);
        //对连接池控制数--可不配
        dbs.setInitialSize(10); //连接池初始化连接数
        dbs.setMaxActive(8); //最大链接数量
        dbs.setMaxIdle(5); //最大空闲数
        dbs.setMinIdle(5); //最小空闲数
    }
    public static BasicDataSource getDataSource() {
        return dbs;
    }
    private static void initConfig() {
        InputStream inf = JDBCUtils.class.getClassLoader().getResourceAsStream("database.propertties");
        Properties properties = new Properties();
        try {
            properties.load(inf);
            className = properties.getProperty("driverClass");
            sqlUrl = properties.getProperty("url");
            sqlUser = properties.getProperty("username");
            sqlPassword = properties.getProperty("password");
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

应用该工具类 结合 DBUtils 写的demo

package JDBCDemo;

import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import javax.management.RuntimeErrorException;
import org.apache.commons.dbcp.BasicDataSource;
import org.apache.commons.dbutils.QueryRunner;


public class DBCPDemo {
    private static QueryRunner qr = new QueryRunner(DBCPUtils.getDataSource());
    public static void main(String[] args) {
        try {
            insert();
        } catch (Exception e) {
            e.printStackTrance();
        }
    }    
    public static void insert() throws SQLException {
        String sql = "insert into zhangwu (name,money) values (?,?)";
        Object[] obj = {"麻将支出",100};
        int res = qr.update(sql,obj);
        if (res>0) {
            System.out.println("插入数据成功");
        }else {
            System.out.println("插入数据失败");
        }
    }
}