Druid简单使用

一、添加maven依赖

    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.34</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.alibaba/druid -->
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.9</version>
    </dependency>

 

二、添加连接池配置（durid.properties）

driverClassName=com.mysql.jdbc.Driver
url=jdbc\:mysql\://10.102.16.64\:3306/wind_wfcmisc_db?useUnicode\=true&characterEncoding\=utf-8
username=sa
password=abcd1234
filters=stat
initialSize=2
maxActive=300
maxWait=60000
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000
validationQuery=SELECT 1
testWhileIdle=true
testOnBorrow=false
testOnReturn=false
poolPreparedStatements=false
maxPoolPreparedStatementPerConnectionSize=200

 

三、简单使用

public class DruidTest {
    public static void main(String[] args) throws Exception {
        // 读取连接池配置
        Properties properties = new Properties();
        properties.load(new FileInputStream("D:\\eclipse_workspace\\maven-test4\\src\\main\\resources\\durid.properties"));
        
        // 获取数据源
        DataSource dataSource = DruidDataSourceFactory.createDataSource(properties);
        
        // 获取连接
        Connection conn = dataSource.getConnection();
        
        // 执行sql语句
        PreparedStatement ps = conn.prepareStatement("select * from tb_customermanage_risk_type");
        ResultSet rs = ps.executeQuery();
        while(rs.next()) {
            System.out.println(rs.getString(2));
        }
    }
}