Java操作数据库Spring（2）

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
  xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">  
  <modelVersion>4.0.0</modelVersion>  
  <groupId>TestDataBaseGroup2</groupId>  
  <artifactId>TestDataBaseArt2</artifactId>  
  <packaging>war</packaging>  
  <version>1.0-SNAPSHOT</version>  
  <name>TestDataBaseArt Maven Webapp</name>  
  <url>http://maven.apache.org</url>  
  <dependencies>  
    <dependency>  
      <groupId>junit</groupId>  
      <artifactId>junit</artifactId>  
      <version>4.12</version>  
      <scope>test</scope>  
    </dependency>  
    <!-- oracle -->  
    <dependency>  
      <groupId>com.oracle</groupId>  
      <artifactId>ojdbc6</artifactId>  
      <version>11.2.0</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->  
    <dependency>  
      <groupId>mysql</groupId>  
      <artifactId>mysql-connector-java</artifactId>  
      <version>6.0.5</version>  
    </dependency>  
    <!-- spring -->  
    <dependency>  
      <groupId>org.springframework</groupId>  
      <artifactId>spring-webmvc</artifactId>  
      <version>4.3.4.RELEASE</version>  
    </dependency>  
    <dependency>  
      <groupId>org.springframework</groupId>  
      <artifactId>spring-orm</artifactId>  
      <version>4.3.4.RELEASE</version>  
    </dependency>  
    <dependency>  
      <groupId>org.springframework</groupId>  
      <artifactId>spring-aspects</artifactId>  
      <version>4.3.4.RELEASE</version>  
    </dependency>  
    <dependency>  
      <groupId>org.springframework</groupId>  
      <artifactId>spring-test</artifactId>  
      <version>4.3.4.RELEASE</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/org.springframework/spring-context -->  
    <dependency>  
      <groupId>org.springframework</groupId>  
      <artifactId>spring-context</artifactId>  
      <version>4.3.4.RELEASE</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/org.springframework.data/spring-data-jpa -->  
    <dependency>  
      <groupId>org.springframework.data</groupId>  
      <artifactId>spring-data-jpa</artifactId>  
      <version>1.10.6.RELEASE</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/org.springframework.session/spring-session -->  
    <dependency>  
      <groupId>org.springframework.session</groupId>  
      <artifactId>spring-session</artifactId>  
      <version>1.2.2.RELEASE</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/org.springframework.data/spring-data-elasticsearch -->  
    <dependency>  
      <groupId>org.springframework.data</groupId>  
      <artifactId>spring-data-elasticsearch</artifactId>  
      <version>2.0.5.RELEASE</version>  
    </dependency>  
    <!-- hibernate -->  
    <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-core -->  
    <dependency>  
      <groupId>org.hibernate</groupId>  
      <artifactId>hibernate-core</artifactId>  
      <version>5.2.5.Final</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/org.hibernate/hibernate-c3p0 -->  
    <dependency>  
      <groupId>org.hibernate</groupId>  
      <artifactId>hibernate-c3p0</artifactId>  
      <version>5.2.5.Final</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/ch.qos.logback/logback-classic -->  
    <dependency>  
      <groupId>ch.qos.logback</groupId>  
      <artifactId>logback-classic</artifactId>  
      <version>1.1.8</version>  
    </dependency>  
    <!-- servlet -->  
    <dependency>  
      <groupId>javax.servlet</groupId>  
      <artifactId>servlet-api</artifactId>  
      <version>2.5</version>  
    </dependency>  
    <dependency>  
      <groupId>javax.servlet</groupId>  
      <artifactId>jstl</artifactId>  
      <version>1.2</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/javax.inject/javax.inject -->  
    <dependency>  
      <groupId>javax.inject</groupId>  
      <artifactId>javax.inject</artifactId>  
      <version>1</version>  
    </dependency>  
    <!-- https://mvnrepository.com/artifact/com.h2database/h2 -->  
    <dependency>  
      <groupId>com.h2database</groupId>  
      <artifactId>h2</artifactId>  
      <version>1.4.193</version>  
    </dependency>  
    <!-- json -->  
    <dependency>  
      <groupId>net.sf.json-lib</groupId>  
      <artifactId>json-lib</artifactId>  
      <version>2.3</version>  
      <classifier>jdk15</classifier>  
    </dependency>  
  </dependencies>  
  <build>  
    <finalName>OnlyMyTest</finalName>  
  </build>  
</project>  

<?xml version="1.0" encoding="UTF-8"?>  
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"  
        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
        xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd"  
        version="3.1">  
  <display-name>Archetype Created Web Application</display-name>  
  <listener>  
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>  
  </listener>  
  <context-param>  
    <param-name>contextConfigLocation</param-name>  
    <param-value>classpath:applicationContext.xml,classpath:daoContext.xml</param-value>  
  </context-param>  
  <servlet>  
    <servlet-name>mvc-dispatcher</servlet-name>  
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>  
    <init-param>  
      <param-name>contextConfigLocation</param-name>  
      <param-value>classpath:mvc-dispatcher-servlet.xml</param-value>  
    </init-param>  
    <load-on-startup>1</load-on-startup>  
  </servlet>  
  <servlet-mapping>  
    <servlet-name>mvc-dispatcher</servlet-name>  
    <url-pattern>/</url-pattern>  
  </servlet-mapping>  
</web-app>  

<?xml version="1.0" encoding="UTF-8"?>  
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
       xmlns="http://www.springframework.org/schema/beans"  
       xmlns:p="http://www.springframework.org/schema/p"  
       xmlns:c="http://www.springframework.org/schema/c"  
       xmlns:tx="http://www.springframework.org/schema/tx"  
       xmlns:task="http://www.springframework.org/schema/task"  
       xmlns:aop="http://www.springframework.org/schema/aop"  
       xmlns:context="http://www.springframework.org/schema/context"  
       xsi:schemaLocation="http://www.springframework.org/schema/beans  
       http://www.springframework.org/schema/beans/spring-beans-4.0.xsd  
       http://www.springframework.org/schema/tx  
       http://www.springframework.org/schema/tx/spring-tx-4.0.xsd  
       http://www.springframework.org/schema/aop  
       http://www.springframework.org/schema/aop/spring-aop-4.0.xsd  
       http://www.springframework.org/schema/task  
       http://www.springframework.org/schema/task/spring-task-3.1.xsd   
       http://www.springframework.org/schema/context   
       http://www.springframework.org/schema/context/spring-context.xsd">  
    <!-- 定义Service组件，并将DAO组件注入Service组件 -->  
    <bean id="myService" class="service.MyService"  
    />  
    <context:annotation-config />  
</beans>