目錄

1.數(shù)據(jù)源的手動(dòng)創(chuàng)建

Spring配置數(shù)據(jù)源

2. Spring注解開發(fā)

1 Spring原始注解

2 Spring新注解

Spring整合Juni

1.數(shù)據(jù)源的手動(dòng)創(chuàng)建

常見的數(shù)據(jù)源(連接池)：DBCP、C3P0、BoneCP、Druid等

開發(fā)步驟

①導(dǎo)入數(shù)據(jù)源的坐標(biāo)和數(shù)據(jù)庫驅(qū)動(dòng)坐標(biāo)

②創(chuàng)建數(shù)據(jù)源對(duì)象

③設(shè)置數(shù)據(jù)源的基本連接數(shù)據(jù)

④使用數(shù)據(jù)源獲取連接資源和歸還連接資源

①導(dǎo)入c3p0和druid的坐標(biāo)

    c3p0
    c3p0
    0.9.1.2



    com.alibaba
    druid
    1.1.10

①導(dǎo)入mysql數(shù)據(jù)庫驅(qū)動(dòng)坐標(biāo)

    mysql
    mysql-connector-java
    5.1.39

②創(chuàng)建C3P0連接池

@Test
public void testC3P0() throws Exception {
	//創(chuàng)建數(shù)據(jù)源
	ComboPooledDataSource dataSource = new ComboPooledDataSource();
	//設(shè)置數(shù)據(jù)庫連接參數(shù)
    dataSource.setDriverClass("com.mysql.jdbc.Driver");    	               	               dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/test");
    dataSource.setUser("root");
    dataSource.setPassword("root");
	//獲得連接對(duì)象
	Connection connection = dataSource.getConnection();
	System.out.println(connection);
}

②創(chuàng)建Druid連接池 ????????

@Test
public void testDruid() throws Exception {
    //創(chuàng)建數(shù)據(jù)源
    DruidDataSource dataSource = new DruidDataSource();
    //設(shè)置數(shù)據(jù)庫連接參數(shù)
    dataSource.setDriverClassName("com.mysql.jdbc.Driver"); 
    dataSource.setUrl("jdbc:mysql://localhost:3306/test");   
    dataSource.setUsername("root");
    dataSource.setPassword("root");
    //獲得連接對(duì)象
    Connection connection = dataSource.getConnection();    
    System.out.println(connection);
}

③提取jdbc.properties配置文件

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=root
jdbc.password=root

④讀取jdbc.properties配置文件創(chuàng)建連接池

@Test
public void testC3P0ByProperties() throws Exception {
    //加載類路徑下的jdbc.properties
    ResourceBundle rb = ResourceBundle.getBundle("jdbc");
    ComboPooledDataSource dataSource = new ComboPooledDataSource(); 
    dataSource.setDriverClass(rb.getString("jdbc.driver"));   
    dataSource.setJdbcUrl(rb.getString("jdbc.url")); 
    dataSource.setUser(rb.getString("jdbc.username")); 
    dataSource.setPassword(rb.getString("jdbc.password"));
    Connection connection = dataSource.getConnection();   
    System.out.println(connection);
}

Spring配置數(shù)據(jù)源

可以將DataSource的創(chuàng)建權(quán)交由Spring容器去完成

DataSource有無參構(gòu)造方法，而Spring默認(rèn)就是通過無參構(gòu)造方法實(shí)例化對(duì)象的

DataSource要想使用需要通過set方法設(shè)置數(shù)據(jù)庫連接信息，而Spring可以通過set方法進(jìn)行字符串注入

?測(cè)試從容器當(dāng)中獲取數(shù)據(jù)源

ApplicationContext applicationContext = new 
           ClassPathXmlApplicationContext("applicationContext.xml");
               DataSource dataSource = (DataSource) 
applicationContext.getBean("dataSource");
Connection connection = dataSource.getConnection();
System.out.println(connection);

抽取jdbc配置文件

首先，需要引入context命名空間和約束路徑：

命名空間：xmlns:context="Index of /schema/context"