AI专业者开发社区 1 号成员
  •  0 回帖  •  0 浏览  •  4 个月前
 

Druid数据库连接池的使用

Druid  阿里提供的数据库连接池，集以上连接池优点于一身，开发使用此连接池

使用配置文件方式获取 Druid 数据库连接池

TestDruid

package com.aff.connection;

import java.io.InputStream;
import java.sql.Connection;
import java.util.Properties;
import javax.sql.DataSource;
import org.junit.Test;
import com.alibaba.druid.pool.DruidDataSourceFactory;


//使用配置文件方式获取 Druid 数据库连接池
public class TestDruid {
@Test
public void getConnection() throws Exception {
Properties pros = new Properties();
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
pros.load(is);
DataSource source = DruidDataSourceFactory.createDataSource(pros);
Connection conn = source.getConnection();
System.out.println(conn);
}
}

 

使用 Druid 数据连接池获取连接

JDBCUtilsDruid

package com.aff.util;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
import javax.sql.DataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;

//使用 Druid 数据连接池获取连接
public class JDBCUtilsDruid {
private static DataSource source;
static {
try {
Properties pros = new Properties();
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
pros.load(is);
source = DruidDataSourceFactory.createDataSource(pros);
} catch (Exception e) {
e.printStackTrace();
}
}


</span><span style="color: rgba(0, 0, 255, 1)">public</span> <span style="color: rgba(0, 0, 255, 1)">static</span> Connection getConnection() <span style="color: rgba(0, 0, 255, 1)">throws</span><span style="color: rgba(0, 0, 0, 1)"> SQLException {
    Connection conn </span>=<span style="color: rgba(0, 0, 0, 1)"> source.getConnection();
    </span><span style="color: rgba(0, 0, 255, 1)">return</span><span style="color: rgba(0, 0, 0, 1)"> conn;
}



}

 

测试 Druid 数据库连接池获取的连接的使用

    @Test
    public void testGetCount() {
        Connection conn = null;
        try {
            conn = JDBCUtilsDruid.getConnection();
            Long count = dao.getCount(conn);
            System.out.println(count);
            System.out.println("获取成功");} catch (Exception e) {e.printStackTrace();
        } finally {
            JDBCUtils.closeResource(conn, null);}
    }

目录结构