方式一:
_ 使用C3P0数据库连接池技术 _
private static ComboPooledDataSource cpds = new ComboPooledDataSource("hellc3p0");
Connection conn = cpds.getConnection();
c3p0-config.xml中:<
named-config name="hellc3p0">
方式二:
_ 使用DBCP数据库连接池技术 _
Properties pros = new Properties();
FileInputStream is = new FileInputStream(new File("resources/dbcp.properties"));
pros.load(is);
DataSource source = BasicDataSourceFactory.createDataSource(pros);
Connection conn = source.getConnection();
方式三:
_ 使用Druid数据库连接池技术 _
Properties pros = new Properties();
InputStream is = ClassLoader.getSystemClassLoader().getResourceAsStream("druid.properties");
pros.load(is);
DataSource source1 = DruidDataSourceFactory.createDataSource(pros);
Connection conn = source1.getConnection();
方式四:
_ 使用MyBatis _
// 虽然操作步骤如下,但实际情况是先写第三步 > 第二步 > 第一步 > 4、5
@Test
public void testGet() throws Exception {
//1:从resources中加载MyBatis全局配置文件:mybatis-config.xml
InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml");
//2:创建SqlSessionFactory对象,好比是DataSource
SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
//3:创建SqlSession对象,好比是Connection
SqlSession sqlSession = sqlSessionFactory.openSession();
//4:具体的操作(增删改查)
User user = sqlSession.selectOne("cn1/mybatis/hello/UserMapper.get", 1L);
//5:关闭SqlSession
sqlSession.close();
}