- +在此添加单个AI新笔记
JDBC - 连接池 - Druid - 阿里、快、稳定常用
测试
package com.atguigu4.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.DruidDataSource;import com.alibaba.druid.pool.DruidDataSourceFactory;public class DruidTest {@Testpublic 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);}}
配置文件
src/druid.properties
url=jdbc:mysql:///testusername=rootpassword=abc123driverClassName=com.mysql.jdbc.DriverinitialSize=10maxActive=10
使用
放在JDBCutil.java
不会关掉连接池
/*** 使用Druid数据库连接池技术*/private static DataSource source1;static{try {Properties pros = new Properties();InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");pros.load(is);source1 = DruidDataSourceFactory.createDataSource(pros);} catch (Exception e) {e.printStackTrace();}}public static Connection getConnection3() throws SQLException{Connection conn = source1.getConnection();return conn;}