spring data jpa

jpa:java persistence api java持久化api

orm思想

  • 操作实体类相当于操作数据库表,不在重点关注sql语句
  • 两个映射:1-实体类和表 2-属性和字段
  • 实现orm思想的框架如:mybatis、hibernate

jpa规范

  • jdbc规范:封装好具体操作数据库接口、方法,只需修改对应驱动
  • 内部由接口和抽象类组成
  • jpa规范不干活,依托实现方式(如:hibernate)来操作。

jpa使用操作

  • 1-jar依赖
<properties>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    <project.hibernate.version>5.0.7.Final</project.hibernate.version>
</properties>

<dependencies>
    <!-- junit -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.12</version>
        <scope>test</scope>
    </dependency>

    <!-- hibernate对jpa的支持包 -->
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-entitymanager</artifactId>
        <version>${project.hibernate.version}</version>
    </dependency>

    <!-- c3p0 -->
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-c3p0</artifactId>
        <version>${project.hibernate.version}</version>
    </dependency>

    <!-- log日志 -->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>1.2.17</version>
    </dependency>

    <!-- Mysql and MariaDB -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.6</version>
    </dependency>

</dependencies>
  • 2-配置文件 需在class目录下的META-INF目录及名称为persistence.xml
<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" version="2.0">

    <!--需配置persistence-unit节点
        持久化单元:
            name:持久化单元名称
            transaction-type:事务管理方式   JTA=分布式事务管理   RESOURCE_LOCAL=本地事务管理
    -->
    <persistence-unit name="myJpa" transaction-type="RESOURCE_LOCAL">
        <!--jpa实现方式-->
        <provider>org.hibernate.jpa.HibernatePersistenceProvider</provider>

        <properties>
            <!--数据库信息:
                用户名 javax.persistence.jdbc.user
                密码 javax.persistence.jdbc.password
                驱动 javax.persistence.jdbc.driver
                地址 javax.persistence.jdbc.url
            -->
            <property name="javax.persistence.jdbc.user" value="root"></property>
            <property name="javax.persistence.jdbc.password" value="root"></property>
            <property name="javax.persistence.jdbc.driver" value="com.mysql.jdbc.Driver"></property>
            <property name="javax.persistence.jdbc.url" value="jdbc:mysql:///mydb"></property>

            <!--可选配置:配置jpa实现方式的配置信息
                显示sql    true=显示  false=不显示
                自动创建数据库表 :
                    create=程序运行时创建数据库表,有表先删再创建
                    update=程序运行时创建数据库表  有表不会创建
                    none=不会创建数据库表
             -->
            <property name="hibernate.show_sql" value="true"></property>
            <property name="hibernate.hbm2ddl.auto" value="update"></property>
        </properties>
    </persistence-unit>

</persistence>
  • 3-实体类与表映射
package com.xiaoai.domain;

import javax.persistence.*;

/**
 * 客户实体类   需要配置映射关系
 *      1-实体类和表映射
 *      2-属性和字段映射
 *
 *  主键生成策略
 *      IDENTITY=自增   底层必须支持自增      mysql
 *      SEQUENCE=序列   底层必须支持序列      oracle
 *      TABLE=jpa提供的一种机制,通过一张数据库表的形式帮助我们完成主键自增
 *      AUTO=由程序自动帮助我们选择主键生成策略
 */
@Entity   //1-1声明此类为实体类
@Table(name = "mjfs14_customer")   //1-2配置实体类和表映射
public class Customer {

    //2-1配置属性字段映射
    @Id  //声明主键
    @GeneratedValue(strategy = GenerationType.IDENTITY)  //配置主键生成策略  IDENTITY=自增 (要求:底层数据库必须支持自动增长)
    @Column(name = "cust_id")  //对应数据库字段名称
    private Long custId; //客户主键
    @Column(name = "cust_name")
    private String custName;//客户名称
    @Column(name = "cust_source")
    private String custSource;//客户来源
    @Column(name = "cust_level")
    private String custLevel;//客户级别
    @Column(name = "cust_industry")
    private String custIndustry;//客户所属行业
    @Column(name = "cust_phone")
    private String custPhone;//客户联系方式
    @Column(name = "cust_address")
    private String custAddress;//客户地址

    ......对应属性get和set方法以及toString方法

  • 4-具体CRUD操作
    EntityManager相关方法
  • presist(对象) 保存
  • merge(对象) 更新 先查询得到对象,修改对象然后执行修改
  • remove(对象) 删除 先查询得到对象,传入对象进行删除
  • find(待封装对象class,id)/getRefrence(待封装对象class,id) 根据id查询 find立即加载,getRefrence延时加载(懒加载)
package com.xiaoai.test;


import com.sun.xml.internal.txw2.TXW;
import com.xiaoai.domain.Customer;
import com.xiaoai.utils.JpaUtils;
import org.junit.Test;

import javax.persistence.*;

/**
 * jpa相应操作
 *
 * jpa操作步骤:
 *      1-加载配置文件创建工厂(实体管理器工厂)对象
 *          EntityManagerFactory创建过程比较浪费资源
 *          特点:线程安全对象:多个线程访问同一个EntityManagerFactory不会有线程安全问题
 *          ---解决EntityManagerFactory创建过程浪费资源(耗时)问题?
 *          思路:创建公共EntityManagerFactory对象   解决:java中可以使用静态代码块形式创建EntityManagerFactory
 *      2-通过实体管理类工厂获取实体管理器
 *          方法:createEntityManager
 *          内部维护很多内容:数据库信息、缓存信息、所有实体类管理器对象等
 *
 *          createEntityManager对象:实体类管理器   方法:
 *              beginTransaction=创建事务对象
 *              presist=保存
 *              merge=更新
 *              remove=删除
 *              find/getRefrence=根据id查询
 *      3-获取事务对象,开启事务
 *          EntityTransaction 事务对象
 *              begin=开启事务
 *              commit=提交事务
 *              rellback=回滚
 *      4-完成相关增删改查操作
 *      5-提交事务(回滚事务)
 *      6-释放资源
 */
public class JpaTest {

    /**
     *  -----测试jpa的增加 presist
     */
    @Test
    public  void testSave(){
        //1-加载配置文件创建工厂(实体管理器工厂)  根据持久化单元名称创建实体类工厂
        EntityManagerFactory factory = Persistence.createEntityManagerFactory("myJpa");
        //2-获取实体类管理器
        EntityManager em = factory.createEntityManager();
        //3-获取事务管理    打开事务
        EntityTransaction tx = em.getTransaction();
        tx.begin();
        //4-执行操作  增加 presist
        Customer customer = new Customer();
        customer.setCustName("xiaoai");
        customer.setCustIndustry("it");
        em.persist(customer);
        //5-提交事务
        tx.commit();
        //6-释放资源
        em.close();
        factory.close();
    }

    /**
     * -----根据id查询  使用find方法
     *  1-查询对象就是当前待查询对象本身
     *  2-调用find方法时,就会发送sql语句查询数据库
     *
     *  立即加载:得到的即对象本身,调用方法就完成加载
     */
    @Test
    public void testFind(){
        //获取管理器
        EntityManager entityManager = JpaUtils.getEntityManager();  //通过JpaUtils封装生成同一EntityManagerFactory对象,减少资源耗费及耗时
        //获取事务 打开事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作
        Customer customer = entityManager.find(Customer.class, 1l);
        System.out.println(customer);
        //提交事务
        tx.commit();
        //关闭  由于使用同一个EntityManagerFactory对象,所以其暂时不能关闭
        entityManager.close();
    }

    /**
     * -----根据id查询  使用getReference方法
     *  1-查询对象是一个动态代理对象
     *  2-不会即时发送sql语句查询数据库,当调用查询结果对象的时候,才会发送查询的sql语句(即什么时候用什么时候发送)
     *  延时加载(懒加载):得到的是一个动态代理对象  什么时候用什么时候加载
     *
     *  一般使用延时加载,
     */
    @Test
    public void testGetReference(){
        //获取管理器
        EntityManager entityManager = JpaUtils.getEntityManager();
        //获取事务 打开事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作
        Customer customer = entityManager.getReference(Customer.class, 1l);//getReference
        System.out.println(customer);
        //提交事务
        tx.commit();
        //关闭  由于使用同一个EntityManagerFactory对象,所以其暂时不能关闭
        entityManager.close();
    }

    //-----删除   remove
    @Test
    public void testRemove(){
        //获取管理器
        EntityManager entityManager = JpaUtils.getEntityManager();
        //获取事务 打开事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作  删除 先查后删
        //--1-根据id查询客户
        Customer customer = entityManager.find(Customer.class, 1l);//getReference
        //--2-传入所查询结果删除
        entityManager.remove(customer);
        //提交事务
        tx.commit();
        //关闭  由于使用同一个EntityManagerFactory对象,所以其暂时不能关闭
        entityManager.close();
    }

    //-----更新   merge
    @Test
    public void testUpdate(){
        //获取管理器
        EntityManager entityManager = JpaUtils.getEntityManager();
        //获取事务 打开事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作  更新  先查询获取对象,修改对象后更新对象
        //--1-根据id查询客户
        Customer customer = entityManager.find(Customer.class, 2l);//getReference
        //--2-修改对象信息
        customer.setCustIndustry("net");
        //--2-传入所查询结果删除
        entityManager.merge(customer);
        //提交事务
        tx.commit();
        //关闭  由于使用同一个EntityManagerFactory对象,所以其暂时不能关闭
        entityManager.close();
    }
}

EntityManagerFactory封装

package com.xiaoai.utils;

import javax.persistence.EntityManager;
import javax.persistence.EntityManagerFactory;
import javax.persistence.Persistence;

/**
 * 解决实体管理器工厂的浪费资源和耗时问题
 *  通过静态代码块的形式,当程序第一次访问此工具类是,创建一个公共的实体管理器工厂对象
 *
 *  1-第一次访问getEntityManager方法,经静态代码块创建factory对象,再调用方法创建一个EntityManager对象
 *  2-第二次访问getEntityManager方法,直接通过一个已经创建好的factory对象创建EntityManager对象
 */
public class JpaUtils {
    private static EntityManagerFactory factory;

    static {
        //加载配置文件,创建EntityManagerFactory
        factory  = Persistence.createEntityManagerFactory("myJpa");
    }

    /**
     * 用来获取EntityManager对象
     */
    public static EntityManager getEntityManager(){
        return factory.createEntityManager();
    }
}

jpql查询 java persistence query language jpa提供的一种查询语句 和sql差不多

sql:查询的是表和表中的字段
jpql:查询的是实体类和类中属性

步骤:

  • 1-EntityManagerFactory 工厂
  • 2-EntityManager 实体类管理器
  • 3-EntityTransaction 打开事务
  • 4-Query:jpql具体查询语句获取query对象,query对象执行查询 (jpa直接通过EntityManager对象进行操作)
  • 5-提交事务
  • 6-释放资源
package com.xiaoai.test;

import com.xiaoai.utils.JpaUtils;
import org.junit.Test;

import javax.persistence.EntityManager;
import javax.persistence.EntityTransaction;
import javax.persistence.Query;
import java.util.List;

/**
 * jpql查询
 */
public class JpqlTest {

    /**
     * -----查询全部
     *      sql:select * from mjfs14_customer
     *      jqpl:from com.xiaoai.domain.Customer(可以使用全限定类名也可以简写: from Customer)
     */
    @Test
    public void testFindAll(){
        //获取entityManager对象
        EntityManager entityManager = JpaUtils.getEntityManager();
        //开启事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作
            //--1获取query对象
            String jpql = "from com.xiaoai.domain.Customer";
            Query query = entityManager.createQuery(jpql);
            //--2具体操作,封装结果集
            List list = query.getResultList();
            for (Object obj:list ) {
                System.out.println(obj);
            }
        //提交事务
        tx.commit();
        //释放资源
        entityManager.close();

        /*结果如下:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_
        Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=3, custName='xiaoai3', custSource='null', custIndustry='无业游民', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=4, custName='小艾', custSource='null', custIndustry='教育', custLevel='null', custAddress='null', custPhone='null'}
        */
    }

    /**
     * -----倒叙查询
     *      sql: select * from mjfs14_customer order by cust_id DESC
     *      jpql: from Customer order by custId desc
     */
    @Test
    public void testOrders(){
        //获取entityManager对象
        EntityManager entityManager = JpaUtils.getEntityManager();
        //开启事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作
            //--1获取query对象
            String jpql = "from Customer order by custId desc";
            Query query = entityManager.createQuery(jpql);
            //--2具体操作,封装结果集
            List list = query.getResultList();
            for (Object obj:list ) {
                System.out.println(obj);
            }
        //提交事务
        tx.commit();
        //释放资源
        entityManager.close();

        /*结果如下:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ order by customer0_.cust_id desc
        Customer{custId=4, custName='小艾', custSource='null', custIndustry='教育', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=3, custName='xiaoai3', custSource='null', custIndustry='无业游民', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
        */
    }

    /**
     * -----统计查询
     *      sql: select count(cust_id) from mjfs14_customer
     *      jpql: select count(custId) from Customer
     */
    @Test
    public void testCount(){
        //获取entityManager对象
        EntityManager entityManager = JpaUtils.getEntityManager();
        //开启事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作
            //--1获取query对象
            String jpql = "select count(custId) from Customer";
            Query query = entityManager.createQuery(jpql);
            //--2具体操作,封装结果集
            Object result = query.getSingleResult();//得到唯一的结果集
        System.out.println(result);
        //提交事务
        tx.commit();
        //释放资源
        entityManager.close();

        /*结果如下:
        Hibernate: select count(customer0_.cust_id) as col_0_0_ from mjfs14_customer customer0_
        4
        */
    }

    /**
     * -----分页查询
     *      sql: select * from mjfs14_customer limit ?,?
     *      jpql: from Customer
     */
    @Test
    public void testPaged(){
        //获取entityManager对象
        EntityManager entityManager = JpaUtils.getEntityManager();
        //开启事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作
            //--1获取query对象
            String jpql = "from Customer";
            Query query = entityManager.createQuery(jpql);
            //--2具体操作,封装结果集
            //----设置参数(分页参数)
            query.setFirstResult(0);//从下标0开始查
            query.setMaxResults(2);//每次查询两条
            List list = query.getResultList();
            for (Object obj:list ) {
                System.out.println(obj);
            }
        //提交事务
        tx.commit();
        //释放资源
        entityManager.close();

        /*结果如下:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ limit ?
        Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        */
    }

    /**
     * -----条件查询
     *      sql: select * from mjfs14_customer where cust_name like ?
     *      jpql: from Customer where custName like ?
     */
    @Test
    public void testCondition(){
        //获取entityManager对象
        EntityManager entityManager = JpaUtils.getEntityManager();
        //开启事务
        EntityTransaction tx = entityManager.getTransaction();
        tx.begin();
        //操作
            //--1获取query对象
            String jpql = "from Customer where custName like ?";
            Query query = entityManager.createQuery(jpql);
            //--2具体操作,封装结果集
            //----设置参数(占位符参数)
            query.setParameter(1,"xiaoai%");//参数:1=第几个占位符  2=代替值
            List list = query.getResultList();
            for (Object obj:list ) {
                System.out.println(obj);
            }
        //提交事务
        tx.commit();
        //释放资源
        entityManager.close();

        /*结果如下:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ where customer0_.cust_name like ?
        Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=3, custName='xiaoai3', custSource='null', custIndustry='无业游民', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
}

spring data jpa

相互关系:我们写的java代码——》spring data jpa——》jpa规范——》hibernate(封装jdbc)——》数据库

基础使用

  • 导入jar
<properties>
    <spring.version>4.2.4.RELEASE</spring.version>
    <hibernate.version>5.0.7.Final</hibernate.version>
    <slf4j.version>1.6.6</slf4j.version>
    <log4j.version>1.2.12</log4j.version>
    <c3p0.version>0.9.1.2</c3p0.version>
    <mysql.version>5.1.6</mysql.version>
</properties>

<dependencies>
    <!-- junit单元测试 -->
    <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>4.9</version>
        <scope>test</scope>
    </dependency>

    <!-- spring beg -->
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.6.8</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-aop</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-context-support</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-beans</artifactId>
        <version>${spring.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-core</artifactId>
        <version>${spring.version}</version>
    </dependency>
    <!-- spring end -->

    <!-- hibernate beg -->
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>${hibernate.version}</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-entitymanager</artifactId>
        <version>${hibernate.version}</version>
    </dependency>
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-validator</artifactId>
        <version>5.2.1.Final</version>
    </dependency>
    <!-- hibernate end -->

    <!-- c3p0 beg -->
    <dependency>
        <groupId>c3p0</groupId>
        <artifactId>c3p0</artifactId>
        <version>${c3p0.version}</version>
    </dependency>
    <!-- c3p0 end -->

    <!-- log end -->
    <dependency>
        <groupId>log4j</groupId>
        <artifactId>log4j</artifactId>
        <version>${log4j.version}</version>
    </dependency>

    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-api</artifactId>
        <version>${slf4j.version}</version>
    </dependency>

    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>slf4j-log4j12</artifactId>
        <version>${slf4j.version}</version>
    </dependency>
    <!-- log end -->


    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>${mysql.version}</version>
    </dependency>

    <dependency>
        <groupId>org.springframework.data</groupId>
        <artifactId>spring-data-jpa</artifactId>
        <version>1.9.0.RELEASE</version>
    </dependency>

    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-test</artifactId>
        <version>4.2.4.RELEASE</version>
    </dependency>

    <!-- el beg 使用spring data jpa 必须引入 -->
    <dependency>
        <groupId>javax.el</groupId>
        <artifactId>javax.el-api</artifactId>
        <version>2.2.4</version>
    </dependency>

    <dependency>
        <groupId>org.glassfish.web</groupId>
        <artifactId>javax.el</artifactId>
        <version>2.2.4</version>
    </dependency>
    <!-- el end -->
</dependencies>
  • 配置spring配置文件(配置spring data jpa整合)
<?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对象-->
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource"></property><!--数据源-->
        <property name="packagesToScan" value="com.xiaoai.domain"></property><!--扫描实体类所在包-->
        <property name="persistenceProvider">
            <bean class="org.hibernate.jpa.HibernatePersistenceProvider"></bean><!--配置jpa的实现厂家-->
        </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" /><!--数据库方言:数据库支持的特有语法-->
                <property name="showSql" value="true" /><!--是否显示sql语句:即是否打印到控制台-->
            </bean>
        </property>
        <!--jpa方言,高级特性-->
        <property name="jpaDialect">
            <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect"></bean>
        </property>
    </bean>
    <!--2=创建数据库连接池-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="user" value="root"></property>
        <property name="password" value="root"></property>
        <property name="jdbcUrl" value="jdbc:mysql:///mydb?useUnicode=true&amp;characterEncoding=UTF-8"></property>
        <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
    </bean>
    <!--3=整合spring dataJpa-->
    <jpa:repositories base-package="com.xiaoai.dao"
                      transaction-manager-ref="transactionManager"
                        entity-manager-factory-ref="entityManagerFactory">
    </jpa:repositories>

    <!--4=配置事务管理器-->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory"></property>
    </bean>

    <!--5=spring声明式事务-->
    <!--6=配置包扫描-->
    <context:component-scan base-package="com.xiaoai"></context:component-scan>
</beans>
  • 编写实体类及映射 同jpa一致
  • 编写dao层
    • 只要编写dao接口,不需编写实现类
    • 接口需继承两接口:JpaRepository, JpaSpecificationExecutor 接口需提供响应泛型
      • JpaRepository<操作的实体类类型,实体类类型主键属性的类型> 封装了基本curd操作
      • JpaSpecificationExecutor<操作的实体类类型> 封装了复杂查询(分页等)
package com.xiaoai.dao;

import com.xiaoai.domain.Customer;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;

public interface CustomerDao extends JpaRepository<Customer,Long>,JpaSpecificationExecutor<Customer> {

}
  • 注入接口对象,直接使用

接口相关方法

  • findOne(id) 根据id查询
  • save(对象) 对象标识主键 不存在=新增 存在=修改(修改需要先查询然后修改,不要直接创建相同id的对象然后直接执行修改)
  • delete(id) 根据id删除
  • findAll() 查询所有
  • count() 统计总数量
  • exists(id) 查询id为xx的数据是否存在
    • 思路1:查询id为xx数据,判断值是否为空
    • 思路2:判断id为xx的数据数量,数量为0即不存在 JPA即是该种思路
  • getOne(id) 根据id查询 测试方法上需要 @Transactional支持
    • 与findOne区别:findOne底层调用entityManager的find()方法即立即加载,GetOne底层调用entityManager的getRefrence()方法即延时加载。为了延时加载正常执行需要加上事务支持
package com.xiaoai.test;

import com.xiaoai.dao.CustomerDao;
import com.xiaoai.domain.Customer;
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 org.springframework.transaction.annotation.Transactional;

import java.util.List;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class CustomerDaoTest {

    @Autowired
    CustomerDao customerDao;

    /**
     * -----根据id查询
     */
    @Test
    public void testFindOne(){
        Customer one = customerDao.findOne(3l);
        System.out.println(one);

        /*结果
        Hibernate: select customer0_.cust_id as cust_id1_0_0_, customer0_.cust_address as cust_add2_0_0_, customer0_.cust_industry as cust_ind3_0_0_, customer0_.cust_level as cust_lev4_0_0_, customer0_.cust_name as cust_nam5_0_0_, customer0_.cust_phone as cust_pho6_0_0_, customer0_.cust_source as cust_sou7_0_0_ from mjfs14_customer customer0_ where customer0_.cust_id=?
        Customer{custId=3, custName='xiaoai3', custSource='null', custIndustry='无业游民', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
    /**
     * -----save:保存或者更新,根据传入的对象主键id是否存在判断新增或更新
     */
    @Test
    public void testSave(){
        //新增
        Customer customer = new Customer();
        customer.setCustName("程序员");
        customer.setCustLevel("3");
        customer.setCustIndustry("it");
        customerDao.save(customer);
    }
    /**
     * -----save:保存或者更新,根据传入的对象主键id是否存在判断新增或更新
     */
    @Test
    public void testUpdate(){
//        Customer customer = new Customer();
//        customer.setCustId(5l); //id为5的数据已经存在,
//        customer.setCustName("程序员");
//        customerDao.save(customer);
        //如果像上面那样修改,则id为5的数据名称改为了程序员,但其他属性将变为空。
        // 因为修改是查询然后修改,这里直接定义了新对象设置了名称其他属性都为空,即用其替换了原来的5号数据
        //应该先查询获得对象,然后修改对象再执行修改。
        Customer customer = customerDao.findOne(5l);
        customer.setCustName("程序员");//修改编号5数据的名称为程序员
        customerDao.save(customer);
    }
     /**
     * -----删除
     */
    @Test
    public void testDelete(){
        customerDao.delete(6l);
    }
    /**
     * -----查询所有
     */
    @Test
    public void testFindAll(){
        List<Customer> all = customerDao.findAll();
        for (Customer c : all) {
            System.out.println(c);
        }
        /* 测试结果:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_
        Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=3, custName='xiaoai3', custSource='null', custIndustry='无业游民', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=4, custName='小艾', custSource='null', custIndustry='教育', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=5, custName='程序员', custSource='null', custIndustry='it', custLevel='3', custAddress='null', custPhone='null'}
        */

    }
    /**
     *-----统计查询
     */
    @Test
    public void testCount(){
        long count = customerDao.count();
        System.out.println(count);
        /*测试结果:
        Hibernate: select count(*) as col_0_0_ from mjfs14_customer customer0_
        5
        */
    }
    /**
     * -----判断数据是否存在
     */
    @Test
    public void testExists(){
        boolean exists = customerDao.exists(4l);
        System.out.println("是否存在:"+exists);
        /*测试结果:
        Hibernate: select count(*) as col_0_0_ from mjfs14_customer customer0_ where customer0_.cust_id=? and 1=1
        是否存在:true
        */
    }
    /**
     * -----根据id查询
     */
    @Test
    @Transactional  //保证getOne正常运行
    public void testGetOne(){
        Customer one = customerDao.getOne(4l);
        System.out.println(one);
        /*测试结果:
        Hibernate: select customer0_.cust_id as cust_id1_0_0_, customer0_.cust_address as cust_add2_0_0_, customer0_.cust_industry as cust_ind3_0_0_, customer0_.cust_level as cust_lev4_0_0_, customer0_.cust_name as cust_nam5_0_0_, customer0_.cust_phone as cust_pho6_0_0_, customer0_.cust_source as cust_sou7_0_0_ from mjfs14_customer customer0_ where customer0_.cust_id=?
        Customer{custId=4, custName='小艾', custSource='null', custIndustry='教育', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
}

定义jpql/sql语句查询

  • 特有查询:需要在dao接口上配置方法
  • 新添加的方法上使用注解形式配置jpql语句
  • 注解:@query
    • 注解属性value=jpql语句或sql语句
    • 注解属性nativeQuery=false(使用jqpl查询)或true(使用本地查询:即sql查询)
  • jpql更深层封装:只需要按照springDataJpa提供的方法名称规则定义方法,不需要去配置jpql语句,也可以完成查询
    • findBy+属性名称() = 查询 如:findByCustName 根据方法名称(findBy)解析要查询 from 实体类 where 属性名称(如custName) = 参数
    • findBy+属性名称+查询方式(like、isnull) 如:findByCustNameLike
    • findBy+属性名+查询方式+多条件连接符(and、or)+属性名+查询方式(精准匹配可以省略查询方式) 如:findByCustNameLikeAndCustIndustry
      接口定义的方法
package com.xiaoai.dao;

import com.xiaoai.domain.Customer;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * 定义符合springdataJpa的dao层接口规范
 *      JpaRepository<操作的实体类类型,实体类类型主键属性的类型>
 *          封装了基本curd操作
 *     JpaSpecificationExecutor<操作的实体类类型>
 *         封装了复杂查询(分页)
 */
public interface CustomerDao extends JpaRepository<Customer,Long>,JpaSpecificationExecutor<Customer> {

    //===============================================================自定义jpql执行方法
    //使用注解@Query

    //-----根据客户名称查询客户
    @Query(value = "from Customer where custName=?")
    public Customer jpqlFindByName(String custName);

    //-----根据客户名称id查询客户
    // 需要注意多占位符的匹配关系问题
    // 默认情况下,占位符位置需要和方法参数中位置保持一致
    // 但也可以指定占位符参数位置:通过【?索引】的方式指定此占位符的取值来源 如?1 表示该占位符取方法第一个参数
    @Query(value = "from Customer where custName=?1 and custId=?2")
    public Customer jpqlFindByNameAndId(String name,Long id);

    //-----根据id更新客户名称
    @Query(value = "update Customer set custName=?2 where custId=?1")
    @Modifying //声明此方法是用来进行更新操作
    public void jpqlUpdateNameById(Long custId,String custName);

    //===============================================================自定义sql语句执行方法
    // @Query  属性:value=jpql语句或sql语句   nativeQuery=false(使用jqpl查询)或true(使用本地查询:即使用sql查询)

    //-----查询所有
    @Query(value = "select * from mjfs14_customer",nativeQuery = true)
    public List<Object[]> findSql();

    //-----根据名称模糊查询
    @Query(value = "select * from mjfs14_customer where cust_name like ?1",nativeQuery = true)
    public List<Object[]> findSqlByName(String name);

    //===============================================================jpql的深层封装:根据springDataJpa提供的命名方法
    // findByXxx = 查询  Xxx即对象属性即查询条件  如:findByCustName   根据方法名称(findBy)解析要查询 from 实体类 where xxx(属性名称如custName) = 参数

    //-----根据名称查询
    public Customer findByCustName(String custName);

    //-----根据名称模糊查询
    public List<Customer> findByCustNameLike(String custName);

    //-----查询客户名模糊匹配和客户所属行业精准匹配
    public List<Customer> findByCustNameLikeAndCustIndustry(String custName,String custIndustry);

}

测试

package com.xiaoai.test;

import com.xiaoai.dao.CustomerDao;
import com.xiaoai.domain.Customer;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.annotation.Rollback;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.transaction.annotation.Transactional;

import javax.management.Query;
import java.util.Arrays;
import java.util.List;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = "classpath:applicationContext.xml")
public class JpqlTest {

    @Autowired
    CustomerDao customerDao;

    //-----自定义jpql:根据名称查询
    @Test
    public void testJpqlFindByName(){
        Customer customer = customerDao.jpqlFindByName("xiaoai");
        System.out.println(customer);
        /* 执行结果:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ where customer0_.cust_name=?
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
    //-----自定义jpql:根据名称和id查询
    @Test
    public void testJpqlFindByNameAndId(){
        Customer customer = customerDao.jpqlFindByNameAndId("xiaoai",2l);
        System.out.println(customer);
        /* 执行结果:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ where customer0_.cust_name=? and customer0_.cust_id=?
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
    //-----自定义jpql:根据id更新客户名称
    @Test
    @Transactional //spring data jpa 使用jpql完成更新、删除操作需要手动添加事务支持 执行结束后其会自动回滚事务
    @Rollback(value = false) //设置不自动回滚
    public void testJpqlUpdateNameById(){
       customerDao.jpqlUpdateNameById(3l,"程序员小艾");
        Customer customer = customerDao.findOne(3l);
        System.out.println(customer);
        /* 执行结果:
        Hibernate: update mjfs14_customer set cust_name=? where cust_id=?
        Hibernate: select customer0_.cust_id as cust_id1_0_0_, customer0_.cust_address as cust_add2_0_0_, customer0_.cust_industry as cust_ind3_0_0_, customer0_.cust_level as cust_lev4_0_0_, customer0_.cust_name as cust_nam5_0_0_, customer0_.cust_phone as cust_pho6_0_0_, customer0_.cust_source as cust_sou7_0_0_ from mjfs14_customer customer0_ where customer0_.cust_id=?
        Customer{custId=3, custName='程序员小艾', custSource='null', custIndustry='无业游民', custLevel='null', custAddress='null', custPhone='null'}
        */
    }

    //-----自定义sql:查询所有
    @Test
    public void testFindSql(){
        List<Object[]> list = customerDao.findSql();
        for (Object[] obj : list) {
            System.out.println(Arrays.toString(obj));
        }
        /* 执行结果:
        Hibernate: select * from mjfs14_customer
        [1, xiaoai2, null, it, null, null, null]
        [2, xiaoai, null, net, null, null, null]
        [3, 程序员小艾, null, 无业游民, null, null, null]
        [4, 小艾, null, 教育, null, null, null]
        [5, 程序员, null, it, 3, null, null]
        */
    }
     //-----自定义sql:根据名称模糊查询
    @Test
    public void testFindSqlByName(){
        List<Object[]> list = customerDao.findSqlByName("xiaoai%");
        for (Object[] obj : list) {
            System.out.println(Arrays.toString(obj));
        }
        /* 执行结果:
        Hibernate: select * from mjfs14_customer where cust_name like ?
        [1, xiaoai2, null, it, null, null, null]
        [2, xiaoai, null, net, null, null, null]
        */
    }

    //-----jpql进一步封装:根据名称查询
    @Test
    public void testFindByName(){
        Customer customer = customerDao.findByCustName("小艾");
        System.out.println(customer);
        /* 执行结果:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ where customer0_.cust_name=?
        Customer{custId=4, custName='小艾', custSource='null', custIndustry='教育', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
    //-----jpql进一步封装:根据名称模糊查询
    @Test
    public void testFindByNameLike(){
        List<Customer> customers = customerDao.findByCustNameLike("xiaoai%");
        for (Customer c : customers) {
            System.out.println(c);
        }
        /* 执行结果:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ where customer0_.cust_name like ?
        Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
        Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
    //-----jpql进一步封装:客户名模糊匹配和客户所属行业精准匹配
    @Test
    public void testFindByNAndI(){
        List<Customer> customers = customerDao.findByCustNameLikeAndCustIndustry("xiaoai%","it");
        for (Customer c : customers) {
            System.out.println(c);
        }
        /* 执行结果:
        Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ where (customer0_.cust_name like ?) and customer0_.cust_industry=?
        Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
        */
    }
}

specifications动态查询

Specification即查询条件
即接口继承的JpaSpecificationExecutor类所提供的方法列表:

  • T findOne(Specification var1); 单个查询
  • List findAll(Specification var1); 查询列表
  • Page findAll(Specification var1, Pageable var2); 分页查询 pageable=分页参数
  • List findAll(Specification var1, Sort var2); 查询列表 sort=排序参数
  • long count(Specification var1); 统计查询

**使用**

  • 创建Specification对象,通过匿名内部类构建查询条件,再把对象传入JpaSpecificationExecutor提供的方法中完成查询
    • 匿名内部类方法参数:Root 获取查询的对象属性 get()=获取属性
    • 匿名内部类方法参数:CriteriaBuilder 用于构建条件 .equal()=精准查询 .like()=模糊查询 .and()=连接属性
  • equal:直接得到path对象,然后进行比较
  • gt,lt,ge,le,like:得到path对象,根据path指定比较的参数类型,再去进行比较 指定参数类型格式:path对象.as(类型字节码对象) 如: Predicate like = criteriaBuilder.like(custName.as(String.class), "xiaoai%");
  • 排序:创建排序对象做参数传入对应方法 Sort sort = new Sort(Sort.Direction.DESC,"custId");//倒序
  • 分页:创建分页对象做参数传入对应方法
@Test
public void testSpec5(){
    //添加分页
    Pageable pageable = new PageRequest(0,3); //创建分页对象 参数:1=当前查询的页数(从0开始) 2=每页查询数量
    Page<Customer> pageCustomer = customerDao.findAll(null, pageable);//Specification传入空,表示查询全部
    System.out.println("总条数:"+pageCustomer.getTotalElements());
    System.out.println("总页数:"+pageCustomer.getTotalPages());
    List<Customer> content = pageCustomer.getContent();//获取当前页数据列表
    for (Customer c : content) {
        System.out.println(c);
    }

    /*执行结果:
    Hibernate: select count(customer0_.cust_id) as col_0_0_ from mjfs14_customer customer0_
    Hibernate: select customer0_.cust_id as cust_id1_0_, customer0_.cust_address as cust_add2_0_, customer0_.cust_industry as cust_ind3_0_, customer0_.cust_level as cust_lev4_0_, customer0_.cust_name as cust_nam5_0_, customer0_.cust_phone as cust_pho6_0_, customer0_.cust_source as cust_sou7_0_ from mjfs14_customer customer0_ limit ?
    总条数:5
    总页数:2
    Customer{custId=1, custName='xiaoai2', custSource='null', custIndustry='it', custLevel='null', custAddress='null', custPhone='null'}
    Customer{custId=2, custName='xiaoai', custSource='null', custIndustry='net', custLevel='null', custAddress='null', custPhone='null'}
    Customer{custId=3, custName='程序员小艾', custSource='null', custIndustry='无业游民', custLevel='null', custAddress='null', custPhone='null'}
    */
}

多表操作

一对多

  • 主要是配置实体类映射时和其他实体类的关系
    • 一对一
    • 一对多、多对一 注:在一的一方维护外键即可,不需要一和多都维护外键
    • 多对多
  • 可以添加实体类属性并配置其关系映射可完成多表操作
    • 配置相互关系可用实体类间的包含关系,即在实体类中添加另一个实体类作为属性。并需要配置其关系:1-声明表关系 2-配置外键
多的一方:
@OneToMany(targetEntity = LinkMan.class)  //配置一对多关系  需对方字节码对象
@JoinColumn(name = "lkm_cust_id",referencedColumnName = "cust_id")  //name=从表的外键字段,referencedColumnName=主表的主键字段
private Set<LinkMan> linkmans = new HashSet<>();

一的一方:
//配置联系人到客户多对一关系   1-声明表关系  2-配置外键
@ManyToOne(targetEntity = Customer.class)
@JoinColumn(name = "lkm_cust_id",referencedColumnName = "cust_id") //name=从表的外键字段,referencedColumnName=本表的主键字段
private Customer customer;

多的一方放弃维护外键:mappedBy="对方配置关系的属性名" 
@OneToMany(mappedBy="customer")
private Set<LinkMan> linkmans = new HashSet<>();  //放弃外键维护权,表关系交给一的一方维护

  • 一对多删除:删除【一一方】需要考虑,因为有可能【多一方】引入了【一一方】 在【一一方】删除时则需要使用级联删除
    • 级联:操作一个对象的同时操作他的关联对象
    • 级联删除:删除【一一方】的同时删除关联其的【多一方】的所有数据。想级联删除需要在操作的主体即【一一方】的实体类上添加级联属性(配置级联:cascade)
配置级联:
@OneToMany(mappedBy="customer",cascade = CascadeType.ALL) //CascadeType.ALL=所有操作(insert、delete等)都可级联
private Set<LinkMan> linkmans = new HashSet<>();

多对多

  • 创建实体类配置映射,通过包含关系加入另一实体类做属性,配置实体类间多对多关系
//建立关联   1-声明表关系   2-配置中间表(包含两个外键)
@ManyToMany(targetEntity = Role.class)
@JoinTable(name = "mjfs14_user_role", //中间表名称     @JoinColumn和@inverseJoinColumns参数:name=对应外键字段  referencedColumnName=对应主键字段
        joinColumns = {@JoinColumn(name = "center_user_id",referencedColumnName = "user_id")}, // 当前对象在中间表中对应外键配置
        inverseJoinColumns = {@JoinColumn(name = "center_role_id",referencedColumnName = "role_id")} //对方对象在中间表中对应外键配置
)
private Set<Role> roles = new HashSet<>();
  • 放弃外键维护权:两方都是多,随便一方都可以放弃外键维护权 但是一般被选择一方放弃 放弃维护权和【一对多】一致
  • 级联操作:删除对象以及对象关联的对象以及中间表中关联的数据 操作和一对多一致

对象导航查询

  • 查询一个对象时,通过此对象查询其关联对象 操作即:直接通过对象.getxxx()方法即之前创建关联的对象属性时的get方法获取即可 内部自动查询好了
  • 一方查询多方:默认使用延迟加载(因为在一方查询多方,有可能多方有太多数据,立即加载后不用则极大浪费内存) 多方查询一方:默认使用立即加载(多方查询一方时由于只多一条数据,影响不大,所以立即查询了)
  • 延迟加载: 默认即使用延迟加载的形式查询的 可以修改延迟加载为立即加载 即在实体类映射中通过@OneToMany属性fetch配置 EAGER=立即加载 LAZY=延迟加载
配置立即加载:
//使用注解形式配置多表关系  1-声明关系  2-配置外键
@OneToMany(mappedBy="customer",cascade = CascadeType.ALL,fetch = FetchType.EAGER ) //CascadeType.ALL=所有操作(insert、delete等)都可级联  FetchType.EAGER
private Set<LinkMan> linkmans = new HashSet<>();
posted @ 2020-11-29 23:43  小艾影  阅读(114)  评论(0编辑  收藏  举报