Spring mvc中使用Spring Data Jpa 连接Mysql数据库

首先说明以下，Spring Data Jpa的jar包已经不提供直接下载了，要用maven配置依赖项进行下载，可以在gitHub上下载一个名字叫es的项目里面配置了一个完整的Spring环境

，

项目需要若干jar

主要的有

aopalliance-1.0.jar

spring-data-commons-1.6.1.RELEASE.jar

spring-data-jpa-1.4.1.RELEASE.jar

jandex-1.1.0.Final.jar

jboss-logging-3.1.3.GA.jar

jboss-logging-annotations-1.2.0.Beta1.jar

jboss-transaction-api_1.2_spec-1.0.0.Final.jar

首先applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>  
<beans xmlns="http://www.springframework.org/schema/beans"  
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
    xmlns:context="http://www.springframework.org/schema/context"  
    xmlns:aop="http://www.springframework.org/schema/aop"  
    xmlns:tx="http://www.springframework.org/schema/tx"  
    xmlns:p="http://www.springframework.org/schema/p"  
    xmlns:cache="http://www.springframework.org/schema/cache"  
    xmlns:jpa="http://www.springframework.org/schema/data/jpa"
    
    xsi:schemaLocation="http://www.springframework.org/schema/beans   
          http://www.springframework.org/schema/beans/spring-beans-3.1.xsd   
          http://www.springframework.org/schema/context   
          http://www.springframework.org/schema/context/spring-context.xsd   
          http://www.springframework.org/schema/aop   
          http://www.springframework.org/schema/aop/spring-aop.xsd   
          http://www.springframework.org/schema/tx    
          http://www.springframework.org/schema/tx/spring-tx.xsd
          http://www.springframework.org/schema/cache
          http://www.springframework.org/schema/cache/spring-cache.xsd
          http://www.springframework.org/schema/data/jpa
          http://www.springframework.org/schema/data/jpa/spring-jpa.xsd">  
    
        
        <context:annotation-config />  
        
    <context:component-scan base-package="htm">
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
        
       <!-- 定义实体管理器工厂（value就是） -->
        <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">  
             <property name="persistenceUnitName" value="asd"/>
        </bean>
         
         <!-- 配置事务管理器 -->  
           <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">  
            <property name="entityManagerFactory" ref="entityManagerFactory" />  
           </bean>
       
          <!-- 启用 annotation事务-->
           <tx:annotation-driven transaction-manager="transactionManager"/>
           
           <!-- 配置Spring Data JPA扫描目录(根据自己的目录情况定义，就是 extends CrudRepository<HtmEntity,Integer>那个类所在的包，切记)-->
           <jpa:repositories base-package="htm"/>
   

</beans>

之后，在源包目录src下建目录META-INF，在里面建持久化配置文件persistence.xml,内容如下

<?xml version="1.0" encoding="UTF-8"?>
<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
  <persistence-unit name="asd" transaction-type="RESOURCE_LOCAL">
    <provider>org.hibernate.ejb.HibernatePersistence</provider>
    <exclude-unlisted-classes>false</exclude-unlisted-classes>
    <properties>
      <property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>
      <property name="javax.persistence.jdbc.url" value="jdbc:mysql://localhost:3306/mysql?zeroDateTimeBehavior=convertToNull"/>
      <property name="javax.persistence.jdbc.password" value="root"/>
      <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"/>
      <property name="javax.persistence.jdbc.user" value="root"/>
      <property name="javax.persistence.schema-generation.database.action" value="drop-and-create"/>
    </properties>
  </persistence-unit>
</persistence>
新建接口UserRepository
import org.springframework.data.repository.CrudRepository;

/**
 *
 * @author root
 */
public interface UserRepository   extends CrudRepository<HtmEntity,Integer>{
    
}

注意，不需要任何实现，数据库操作已经被封装其中，这个接口所在的包必须是applicationContextg.xml中的

           <!-- 配置Spring Data JPA扫描目录(根据自己的目录情况定义，就是 extends CrudRepository<HtmEntity,Integer>那个类所在的包，切记)-->
           <jpa:repositories base-package="htm"/>

UserRepository这个接口封装了表的一般操作，增删改查都可以，基本就这么多了。