c3p0数据源连接
@Test public void test1() throws Exception { ComboPooledDataSource dataSource=new ComboPooledDataSource(); dataSource.setDriverClass("com.mysql.cj.jdbc.Driver"); dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/Java"); dataSource.setUser("java"); dataSource.setPassword("123456"); Connection connection = dataSource.getConnection(); System.out.println(connection); connection.close(); }
druid数据源连接
@Test public void test2() throws Exception { //druid数据源测试 DruidDataSource druidDataSource = new DruidDataSource(); druidDataSource.setDriverClassName("com.mysql.cj.jdbc.Driver"); druidDataSource.setUrl("jdbc:mysql://localhost:3306/Java"); druidDataSource.setUsername("java"); druidDataSource.setPassword("123456"); DruidPooledConnection connection = druidDataSource.getConnection(); System.out.println(connection); connection.close(); }
jdbc.properties配置(以druid为例)
jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/Java jdbc.username=java jdbc.password=123456
@Test public void test3() throws Exception { ResourceBundle jdbc = ResourceBundle.getBundle("jdbc"); String driver=jdbc.getString("jdbc.driver"); String username=jdbc.getString("jdbc.username"); String url=jdbc.getString("jdbc.url"); String password=jdbc.getString("jdbc.password"); ComboPooledDataSource dataSource = new ComboPooledDataSource(); dataSource.setDriverClass(driver); dataSource.setPassword(password); dataSource.setUser(username); dataSource.setJdbcUrl(url); Connection connection = dataSource.getConnection(); System.out.println(connection); connection.close(); }
Spring容器产生数据源对象(以druid为例)
- 配置Bean
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="com.mysql.cj.jdbc.Driver"></property> <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/Java"></property> <property name="user" value="java"></property> <property name="password" value="123456"></property> </bean>
- 测试
@Test public void test4() throws Exception { ClassPathXmlApplicationContext app = new ClassPathXmlApplicationContext("applicationContext.xml"); DataSource dataSource = app.getBean(DataSource.class); Connection connection = dataSource.getConnection(); System.out.println(connection); connection.close(); }