druid数据库连接池
-
加入maven
<dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.2.9</version> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.29</version> </dependency>
配置druid.properties文件
driverClassBane=com.mysql.jdbc.Driver url=jdbc:mysql://localhost:3306/db1?useSSL=false&ServerPrepStmts=true username=root password=1234 ##初始化连接数量 initialSize=5 #最大连接数 maxActive=10 #最大等待时间 maxWait=3000
获取连接池
//加载配置文件 Properties pp = new Properties(); pp.load(new FileInputStream("src/main/resources/druid.properties")); //获取连接池对象 DataSource ds = DruidDataSourceFactory.createDataSource(pp); //获取数据库连接 Connection conn = ds.getConnection(); String sql="select * from tb_user where id=?"; //获取数据库操作对象 PreparedStatement psp = conn.prepareStatement(sql); psp.setInt(1, 1); ResultSet rs = psp.executeQuery(); while (rs.next()) { System.out.println(rs.getString("name")); System.out.println(rs.getInt("id")); } rs.close(); psp.close(); conn.close();