引入 <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.2.9</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.3.21</version> </dependency>
创建工具类
public class JDBCTemplateUtil { private static JdbcTemplate template; public static JdbcTemplate getTemplate(){ try { Properties properties = new Properties(); InputStream stream = JDBCTemplateUtil.class.getClassLoader().getResourceAsStream("druid.properties"); properties.load(stream); DataSource dataSource = DruidDataSourceFactory.createDataSource(properties); template = new JdbcTemplate(dataSource); } catch (Exception e) { e.printStackTrace(); } return template; } }
C3P0跟这个差不多
为什么使用连接池?
因为Java程序操作数据库,必须获得一个连接Connection,而连接和关闭比较耗时.所以用连接池可以解决这些问题.