DBCP

public class JDBCUtils { private static BasicDataSource datasource = new BasicDataSource(); /* * BasicDataSource类，实现了datasource接口 */ static {// 静态代码块,对象BasicDataSource对象中的配置,自定义 InputStream in = JDBCUtils.class.getClassLoader().getResourceAsStream("DBCP.properties"); Properties pro = new Properties(); try { pro.load(in); } catch (IOException e) { e.printStackTrace(); } // 数据库基本的连接信息，必须要设置（必须项） datasource.setDriverClassName(pro.getProperty("driver")); datasource.setUrl(pro.getProperty("url")); datasource.setUsername(pro.getProperty("username")); datasource.setPassword(pro.getProperty("password")); // 对象连接池中的连接数量配置,可以不设置（基本项） datasource.setInitialSize(100);// 初始化的连接数 datasource.setMaxActive(90);// 最大连接数量 datasource.setMaxIdle(10);// 最大空闲数 datasource.setMinIdle(5);// 最小空闲 } // 返回BasicDataSource类的对象 public static BasicDataSource getDataSource() { return datasource; } }

<span style="color: #000000;">import java.sql.SQLException;
import java.util.List;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayListHandler;
</span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">class</span><span style="color: #000000;"> Test {
    </span><span style="color: #0000ff;">public</span> <span style="color: #0000ff;">static</span> <span style="color: #0000ff;">void</span><span style="color: #000000;"> main(String[] args) {
        QueryRunner qr </span>= <span style="color: #0000ff;">new</span> QueryRunner(JDBCUtils.getDataSource());<span style="color: #008000;">//</span><span style="color: #008000;">参数为数据源</span>
        <span style="color: #0000ff;">try</span><span style="color: #000000;"> {
            String sql </span>= <span style="color: #800000;">"</span><span style="color: #800000;">select * from Student</span><span style="color: #800000;">"</span><span style="color: #000000;">;
            List</span><Object[]> list = qr.query(sql, <span style="color: #0000ff;">new</span><span style="color: #000000;"> ArrayListHandler());
            </span><span style="color: #0000ff;">for</span> (Object[] objs : list) {<span style="color: #008000;">//</span><span style="color: #008000;">list集合</span>
                <span style="color: #0000ff;">for</span><span style="color: #000000;"> (Object obj : objs) {
                    System.</span><span style="color: #0000ff;">out</span>.print(obj + <span style="color: #800000;">"</span><span style="color: #800000;">\t</span><span style="color: #800000;">"</span><span style="color: #000000;">);
                }
                System.</span><span style="color: #0000ff;">out</span><span style="color: #000000;">.println();
            }
        } </span><span style="color: #0000ff;">catch</span><span style="color: #000000;"> (SQLException ex) {
            System.</span><span style="color: #0000ff;">out</span><span style="color: #000000;">.println(ex);
            </span><span style="color: #0000ff;">throw</span> <span style="color: #0000ff;">new</span> RuntimeException(<span style="color: #800000;">"</span><span style="color: #800000;">数据查询失败</span><span style="color: #800000;">"</span><span style="color: #000000;">);
        }
    }
}</span>

 

DBCP

标签：ima   als   sql   color   最大连接数   ret   数据库连接   ade   rgs