项目结构:
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:aop="http://www.springframework.org/schema/aop"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:jdbc="http://www.springframework.org/schema/jdbc" xmlns:tx="http://www.springframework.org/schema/tx"
xmlns:jpa="http://www.springframework.org/schema/data/jpa" xmlns:task="http://www.springframework.org/schema/task"
xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd
http://www.springframework.org/schema/data/jpa
http://www.springframework.org/schema/data/jpa/spring-jpa.xsd">
<!--spring 和 spring data jpa的配置-->
<!--1.创建EntityManagerFactory对象交给spring管理-->
<bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
<!--配置数据库信息-->
<property name="dataSource" ref="dataSource"/>
<!--配置扫描的实体类的包-->
<property name="packagesToScan" value="domain"/>
<!--jpa的实现工厂-->
<property name="persistenceProvider">
<bean class="org.hibernate.jpa.HibernatePersistenceProvider"/>
</property>
<!--jpa的供应商适配器-->
<property name="jpaVendorAdapter">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
<!--是否自动创建数据库表-->
<property name="generateDdl" value="false" />
<!--指定数据库类型-->
<property name="database" value="MYSQL" />
<property name="databasePlatform" value="org.hibernate.dialect.MySQLDialect" />
<!--是否显示sql语句-->
<property name="showSql" value="true" />
</bean>
</property>
<!--jpa的方言:高级特性-->
<property name="jpaDialect">
<bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect"/>
</property>
</bean>
<!--2.数据库连接池-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="user" value="root"/>
<property name="password" value="totoro"/>
<property name="jdbcUrl" value="jdbc:mysql://localhost:3306/test2?useSSL=false&serverTimezone=UTC"/>
<property name="driverClass" value="com.mysql.cj.jdbc.Driver"/>
</bean>
<!--3.整合springdatajpa-->
<!--
base-package是dao所在的包
transaction-manager-ref是引用事务
springdatajpa底层也是jpa,所以这个时候我们要配置上jpa
-->
<jpa:repositories base-package="dao" transaction-manager-ref="transactionManager" entity-manager-factory-ref="entityManagerFactory"/>
<!--4.配置事务管理器-->
<bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
<property name="entityManagerFactory" ref="entityManagerFactory"/>
</bean>
<!--5.配置扫描的包-->
<context:component-scan base-package="java"/>
<!---->
</beans>
实体类的使用:
package domain;
import javax.persistence.*;
@Entity
@Table(name = "address")
public class Address {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
@Column(name = "id")
private Integer id;
@Column(name = "description")
private String des;
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
public String getDes() {
return des;
}
public void setDes(String des) {
this.des = des;
}
@Override
public String toString() {
return "Address{" +
"id=" + id +
", des='" + des + '\'' +
'}';
}
}
持久层代码示例:
package dao;
import domain.Address;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
/**
* 只需要编写dao接口层,不需要编写dao层接口的实体类
* dao层接口规范
* 1.需要继承两个接口JpaRepository和JpaSpecificationExecutor
* 2.需要提供相应的泛型
* JpaRepository<操作的实体类类型,实体类中主键属性的类型>
* 封装了基本的增删改查操作
* JpaSpecificationExecutor<操作的实体类类型>
* 封装了复杂查询
* 3.继承这两个接口以后,就可以实现数据的增删改查
*/
public interface AddressDao extends JpaRepository<Address,Integer>, JpaSpecificationExecutor<Address> {
}
测试类:
import dao.AddressDao;
import domain.Address;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import java.util.List;
@RunWith(SpringJUnit4ClassRunner.class)//声明spring提供的单元测试环境
@ContextConfiguration(locations = "classpath:applicationContext.xml")//指定spring容器的配置信息
public class DaoTest {
@Autowired
AddressDao addressDao;
@Test
public void findById(){
System.out.println(addressDao.findOne(1).toString());
}
@Test
public void AddA(){
Address address = new Address();
address.setDes("啦啦啦");
addressDao.save(address);
}
@Test
public void FindAll(){
List<Address> list = addressDao.findAll();
for (Address a:list){
System.out.println(a.toString());
}
}
}