Druid连接池使用
package jdbc;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import javax.sql.DataSource;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
public class Druid {
private static DataSource source;
static {
try {
Properties pros = new Properties();
InputStream is = Druid.class.getClassLoader().getResourceAsStream("druid.properties");
pros.load(is);
source = DruidDataSourceFactory.createDataSource(pros);
}catch (Exception e){
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection connection = null;
try {
connection = source.getConnection();
} catch (SQLException throwables) {
throwables.printStackTrace();
}
return connection;
}
}
druid.properties
url=jdbc:mysql://localhost:3306/book?rewriteBatchedStatements=true&useServerPrepStmts=false&useUnicode=true&characterEncoding=utf8
username=root
password=123456
driverClassName=com.mysql.cj.jdbc.Driver
initialSize=10
maxActive=20
maxWait=1000
filters=wall