Druid测试案例

maven依赖：

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.2.8</version>
</dependency>
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.49</version>
</dependency>

准备的配置文件db_server.properties：

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/test
username=root
password=
initialSize=20
maxActive=300
maxWait=60000
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000

测试案例代码：

package com.example.druidtest;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.alibaba.druid.pool.DruidPooledConnection;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

public class TestHello {
    private static Properties pro = new Properties();
    private static DruidDataSource dds = null;

    static{
        try {
            pro.load(Thread.currentThread().getContextClassLoader().getResourceAsStream("db_server.properties"));
            dds = (DruidDataSource) DruidDataSourceFactory.createDataSource(pro);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        DruidPooledConnection conn = null;
        PreparedStatement prestate = null;
        ResultSet resultSet = null;
        try {
            conn = dds.getConnection();
            String sql = "select id,name,age from student where age>25";
            prestate = conn.prepareStatement(sql);
            resultSet = prestate.executeQuery();
            while (resultSet.next()){
                System.out.println("id:" + resultSet.getString(1));
                System.out.println("name:" + resultSet.getString(2));
                System.out.println("age:" + resultSet.getInt(3));
            }

        } catch (Exception e) {
            e.printStackTrace();
        }finally {
            if(resultSet != null){
                try {
                    resultSet.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(prestate != null){
                try {
                    prestate.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
            if(conn != null){
                try {
                    conn.close();
                } catch (SQLException e) {
                    e.printStackTrace();
                }
            }
        }

    }
}