栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 软件开发 > 后端开发 > Java

JPA学习2 - 核心注解、注解进行增删改查、List查询结果返回类型、一对多、多对一、多对多

Java 更新时间: 发布时间: IT归档 最新发布 模块sitemap 名妆网 法律咨询 聚返吧 英语巴士网 伯小乐 网商动力

JPA学习2 - 核心注解、注解进行增删改查、List查询结果返回类型、一对多、多对一、多对多

文章目录
  • SpringDataJPA
    • 概述
    • 核心注解
    • 简单使用
      • 配置打印的SQL携带参数
      • 原理 = JDK动态代理
      • 简单代码 = 内置接口
      • 自定义SQL语句
        • 查询
          • 方式1:dao方法名查询形式 - 方法名必须findBy开头
          • 方式2:JPQL查询形式
          • 方式3:SQL查询形式
          • 方式4:代码级别查询,类似MyBatisPlus
          • 三种返回类型 = 根据自己的喜好选择
        • 修改、删除
        • 多表操作
          • 一对多、多对一
            • 查询
            • 插入
          • 多对多
            • 查询

SpringDataJPA 概述

Spring提供的一套对JPA操作更加高级的框架,是在JPA规范下专门用来进行持久化的解决方案

 

核心注解 简单使用 配置打印的SQL携带参数

pom.xml

    
        
            org.springframework.boot
            spring-boot-starter-data-jpa
        


        
        
            org.hibernate
            hibernate-entitymanager
            5.4.30.Final
        


        
            org.springframework.boot
            spring-boot-starter-web
        

        
            org.springframework.boot
            spring-boot-devtools
            runtime
            true
        
        
            mysql
            mysql-connector-java
            runtime
        
        
            org.projectlombok
            lombok
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        

        
            cn.hutool
            hutool-all
            5.6.3
        

        
        
            junit
            junit
            4.13.2
            test
        

        
        
            org.bgee.log4jdbc-log4j2
            log4jdbc-log4j2-jdbc4.1
            1.16
        

    

application.yml == 注意mysql的驱动名以及数据库的连接URL

server:
  port: 8080

spring:
  datasource:
    username: root
    password: root
#    url: jdbc:mysql://localhost:3306/lrc_blog_test2?useSSL=false&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    url: jdbc:log4jdbc:mysql://localhost:3306/lrc_blog_test2?useSSL=false&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
#    driver-class-name: com.mysql.cj.jdbc.Driver
    driver-class-name: net.sf.log4jdbc.sql.jdbcapi.DriverSpy
  jpa:
    show-sql: true
    database-platform: org.hibernate.dialect.MySQL8Dialect
    database: mysql
    hibernate:
#      ddl-auto: create
原理 = JDK动态代理
  1. @Repository定义的dao接口会经过JDK动态代理转成 SimpleJpaRepository对象执行具体的CRUD操作

  2. SimpleJpaRepository通过EntityManager对象执行具体的CRUD操作

  3. 而EntityManager具体的实现由Hibernate进行执行JDBC操作

简单代码 = 内置接口

 
application.yml

server:
  port: 8080

spring:
  datasource:
    username: root
    password: root
    url: jdbc:mysql://localhost:3306/lrc_blog_test?useSSL=false&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
    driver-class-name: com.mysql.cj.jdbc.Driver
  jpa:
    show-sql: true
    database-platform: org.hibernate.dialect.MySQLDialect
    database: mysql
    open-in-view: true

 
Book.java

@Getter
@Setter
@ToString
@Entity
@Table(name = "book")
public class Book implements Serializable {
    private static final long serialVersionUID = 2095940921263481761L;



    
    @Id
    @Column(name = "id")
    private String id;

    @Column(name = "create_time")
    private String createTime;

    @Column(name = "update_time")
    private String updateTime;

    
    @Column(name = "is_del")
    private Integer isDel;

    
    @Column(name = "status")
    private String status;

    
    @Column(name = "name")
    private String name;

    
    @Column(name = "author")
    private String author;

    
    @Column(name = "country")
    private String country;

    
    @Column(name = "download_url")
    private String downloadUrl;

    
    @Column(name = "file_type")
    private String fileType;

    
    @Column(name = "reading_feeling")
    private String readingFeeling;

    
    @Column(name = "sharer")
    private String sharer;

    
    @Column(name = "is_violation")
    private Integer isViolation;




    //书籍状态
    public final  static String STATUS_VIOLATION = "-1";
    public final  static String STATUS_PUBLISH_PUBLIC = "0";
    public final  static String STATUS_PUBLISH_PRIVATE = "1";

}

 
BookDao.java

@Repository
public interface BookDao extends JpaRepository {
}

 
JPATest.java

@SpringBootTest
public class JPATest {

    @Autowired
    BookDao bookDao;

    @Test
    public void test1() {

        List books = bookDao.findAll();
        books.stream().forEach(System.out::println);

    }

}
自定义SQL语句 查询 方式1:dao方法名查询形式 - 方法名必须findBy开头

通过方法名,JPA自动识别JPQL语句

SysUserDao.java

@Repository
public interface SysUserDao extends JpaRepository {

    public SysUser findByIdAndNickName(String id, String nickName);

}

Test.java

    @Test
    public void test8() {
        SysUser sysUser = sysUserDao.findByIdAndNickName("d32478155b6530951cf6b3da56848d5c", "嗯嗯");
        System.out.println(sysUser);
    }

 

方式2:JPQL查询形式
@Repository
public interface BookDao extends JpaRepository, JpaSpecificationExecutor {

    //JPA根据方法名进行生成SQL
    public List findByNameLike(String name);

    //手动写JPQL语句  第一个参数为:?1   第二个参数为:?2  以此类推
    @Query("from Book where name like ?1")
    public List findByNamexxx(String name);

    //手动写JPQL语句  使用 :参数名 用来填充JPQL的参数
    @Query("from Book where name like :name")
    public List findByNamexxx2(String name);

}

 
 
test.java

    @Test
    public void test4() {
        
        
        List books = bookDao.findByNameLike("%大脑%");
        books.stream().forEach(System.out::println);

        System.out.println("n=========n");

        books = bookDao.findByNamexxx("%大脑%");
        books.stream().forEach(System.out::println);

        System.out.println("n=========n");

        books = bookDao.findByNamexxx2("%大脑%");
        books.stream().forEach(System.out::println);


    }

 

方式3:SQL查询形式

BookDao.java

@Repository
public interface BookDao extends JpaRepository, JpaSpecificationExecutor {

    @Query(value = "select * from book where name like :name ", nativeQuery = true)
    public List findByNamexxx2(String name);

    @Query(value = "select * from book where name like ?1 ", nativeQuery = true)
    public List findByNamexxx3(String name);

}

 
 

BookDao.java

    @Test
    public void test5() {
        List books = bookDao.findByNamexxx2("%大脑%");
        books.stream().forEach(System.out::println);
    }
    @Test
    public void test6() {
        List books = bookDao.findByNamexxx3("%大脑%");
        books.stream().forEach(System.out::println);
    }

 

方式4:代码级别查询,类似MyBatisPlus

 
BookDao.java

@Repository
public interface BookDao extends JpaRepository, JpaSpecificationExecutor {

}

 
Test.java

    @Test
    public void test9() {

        List sysUsers = sysUserDao.findAll(new Specification() {
            @Override
            public Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder criteriaBuilder) {
                Path nickName = root.get("nickName");
                Path id = root.get("id");

                Predicate predicate = criteriaBuilder.equal(nickName, "嗯嗯");
                Predicate predicate2 = criteriaBuilder.equal(id, "d32478155b6530951cf6b3da56848d5c");
                
                Predicate and = criteriaBuilder.and(predicate2, predicate);
                
                return and;
            }
        });
        sysUsers.forEach(System.out::println);
    }
 

 
Test.java

    @Test
    public void test10() {
        
        //查询条件
        Specification whereConditions = new Specification() {
            @Override
            public Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder criteriaBuilder) {
                Path nickName = root.get("nickName");
                Path id = root.get("id");
                Predicate predicate = criteriaBuilder.like(nickName.as(String.class), "%嗯%");
                Predicate predicate2 = criteriaBuilder.equal(id, "d32478155b6530951cf6b3da56848d5c");
                return criteriaBuilder.or(predicate, predicate2);
            }
        };
        
        //查询后的记录排序问题
        Sort sort = Sort.by(Sort.Direction.DESC, "createTime", "id", "nickName");

        List sysUsers = sysUserDao.findAll(whereConditions, sort);
        sysUsers.forEach(System.out::println);
    }
 

 
Test.java

    @Test
    public void test11() {

        //查询条件
        Specification whereConditions = new Specification() {
            @Override
            public Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder criteriaBuilder) {
                Path nickName = root.get("nickName");
                Path id = root.get("id");
                Predicate predicate = criteriaBuilder.like(nickName.as(String.class), "%嗯%");
                Predicate predicate2 = criteriaBuilder.like(id.as(String.class), "%5%");
                return criteriaBuilder.or(predicate, predicate2);
            }
        };

        //查询后的记录排序问题
        Sort sort = Sort.by(Sort.Direction.DESC, "createTime");
        //分页信息+排序信息
        Pageable pageable = PageRequest.of(2, 2, sort);

        Page page = sysUserDao.findAll(whereConditions, pageable);
        List sysUsers = page.getContent();

        sysUsers.forEach(System.out::println);
    }
 

 

三种返回类型 = 根据自己的喜好选择

 
BaseDB.java

@Getter
@Setter
@MappedSuperclass
public class BaseDB {

    private static final long serialVersionUID = 3253505422347170166L;
    
    @Id
    private String id;

    @Column(name = "create_time")
    private String createTime;

    @Column(name = "update_time")
    private String updateTime;

    
    @Column(name = "is_del")
    private Integer isDel;

}

 
SysUser.java

@Getter
@Setter
@Entity
@Table(name = "sys_user")
public class SysUser extends BaseDB{

    @Column(name = "nick_name")
    String nickName;


    @Column(name = "login_name")
    String loginName;

    @Override
    public String toString() {
        return "SysUser{" +
                "id='" + getId() + ''' +
                ", nickName='" + nickName + ''' +
                ", loginName='" + loginName + ''' +

                '}';
    }
}

 
SysUserDao.java

@Repository
public interface SysUserDao extends JpaRepository {
    
    
    @Query(value = "select * from sys_user limit 5", nativeQuery = true)
    public List getPage();

    
    @Query(value = "select * from sys_user limit 5", nativeQuery = true)
    public List getPage2();

    
    @Query(value = "select * from sys_user limit 5", nativeQuery = true)
    public List getPage3();


}

 
Test.java

    @Test
    public void test3() {

        System.out.println("n============JavaBean形式-推荐=========n");

        List sysUsers = sysUserDao.getPage();
        sysUsers.forEach(System.out::println);

        System.out.println("n==========Object[]纯列值形式-不推荐===========n");

        List sysUsers2 = sysUserDao.getPage2();
        sysUsers2.stream()
                .map(Arrays::toString)
                .forEach(System.out::println);


        System.out.println("n==========Map形式-推荐===========n");

        List sysUsers3 = sysUserDao.getPage3();
        sysUsers3.stream()
                .map(HashMap::new)
                .forEach(System.out::println);

    }

修改、删除
@Repository
@Transactional  //增删改需要添加事务支持
public interface BookDao extends JpaRepository, JpaSpecificationExecutor {

    @Query("update Book set name = ?2 where id = ?1")
    @Modifying  //update需要添加这个注解
    @Rollback(false)  //执行完不回滚 == 如果你加了前两个注解不能修改数据成功,则添加这个注解上去
    public void udpateBookName(String id, String name);


    @Query("delete from Book where id = :id and name = :name")
    @Modifying
    @Rollback(false)  //执行完不回滚 == 如果你加了前两个注解不能修改数据成功,则添加这个注解上去
    public void deleteByIdName(String id, String name);


}


}

 
 

    @Test
    public void test5() {

        bookDao.udpateBookName("0015ac644213f7db45d63e09c6403395", "测试2");
        
        bookDao.deleteByIdName("0015ac644213f7db45d63e09c6403395", "测试");

        

    }

 

多表操作 一对多、多对一

SysUser.java

@Getter
@Setter
@Entity
@Table(name = "sys_user")
public class SysUser extends BaseDB implements Serializable {

    @Column(name = "nick_name")
    String nickName;


    @Column(name = "login_name")
    String loginName;

    @OneToMany(targetEntity = ArticleComment.class,fetch = FetchType.EAGER)
    @JoinColumn(name = "user_id", referencedColumnName = "id")
    @NotFound(action= NotFoundAction.IGNORE)
    List articleComments;


    @Override
    public String toString() {
        return "SysUser{" +
                "id='" + getId() + ''' +
                ", nickName='" + nickName + ''' +
                ", loginName='" + loginName + ''' +
                ", createTime='" + getCreateTime() + ''' +
                '}';
    }
}

 
ArticleComment.java

@Getter
@Setter
@Entity
@Table(name = "article_comment")
public class ArticleComment extends BaseDB implements Serializable {
    
    private static final long serialVersionUID = -6282048873013965389L;

    @ManyToOne(targetEntity = SysUser.class, fetch = FetchType.EAGER, cascade = CascadeType.ALL)
    @JoinColumn(name ="user_id", referencedColumnName = "id")
    @NotFound(action= NotFoundAction.IGNORE)
    private SysUser sysUser;

    
    @Column(name = "article_id")
    private String articleId;

    
    @Column(name = "parent_comment_id")
    private String parentCommentId;

    
    //@Column(name = "user_id")
    //private String userId;


    
    @Column(name = "replier_id")
    private String replierId;


    
    @Column(name = "comment_content")
    private String commentContent;

    
    @Column(name = "like_num")
    private Integer likeNum;
    
    @Column(name = "not_like_num")
    private Integer notLikeNum;

    @Override
    public String toString() {
        return "ArticleComment{" +
                "id='" + getId() + ''' +
                ", articleId='" + articleId + ''' +
                ", parentCommentId='" + parentCommentId + ''' +
                ", replierId='" + replierId + ''' +
                ", commentContent='" + commentContent + ''' +
                ", likeNum=" + likeNum +
                ", notLikeNum=" + notLikeNum +
                '}';
    }
}

 
SysUserDao.java

@Repository
public interface SysUserDao extends JpaRepository, JpaSpecificationExecutor {


    @Query(value = "select * from sys_user limit 5", nativeQuery = true)
    public List getPage();

    
    @Query(value = "select * from sys_user limit 5", nativeQuery = true)
    public List getPage2();

    
    @Query(value = "select * from sys_user limit 5", nativeQuery = true)
    public List getPage3();

    public SysUser findByIdAndNickName(String id, String nickName);

}

 
ArticleCommentDao.java

@Repository
public interface ArticleCommentDao extends JpaRepository, JpaSpecificationExecutor {

}
查询
@Test
@Transactional  //懒加载的话,找不到代理的异常,如果立即加载则可以不加
public void test13() {
    List sysUsers = sysUserDao.getPage();
    sysUsers.forEach(sysUser -> {
        List articleComments = sysUser.getArticleComments();
        System.out.println(articleComments.size() + ":" + articleComments);
    });
}

 

@Test
@Rollback(value = false)
@Transactional
public void test16() {
    ArticleComment articleComment = articleCommentDao.getOne("1346e1060e95de36d8d8a7bbc8925dfb");
    SysUser sysUser = articleComment.getSysUser();
    System.out.println(sysUser);
}

插入

 

主表已含有外键记录

Test.java

    @Test
    public void test12() {

        SysUser sysUser = sysUserDao.findById("c08d391e02bc11eb9416b42e99ea3e69").get();

        ArticleComment articleComment = new ArticleComment();
        articleComment.setId(UUID.fastUUID().toString(true));
        articleComment.setCommentContent("test==articleComment");
        articleComment.setSysUser(sysUser);

        articleCommentDao.save(articleComment);
    }

 

主表未含有外键记录

    @Test
    @Rollback(value = false)
    @Transactional
    public void test15() {
        SysUser sysUser = new SysUser();
        sysUser.setId(UUID.fastUUID().toString(true));
        sysUser.setNickName(String.valueOf("爱你test"));

        ArticleComment articleComment = new ArticleComment();
        articleComment.setId(UUID.fastUUID().toString(true));
        

        articleComment.setSysUser(sysUser);
        articleComment.setCommentContent(String.valueOf("test==articleComment"));

        sysUserDao.save(sysUser);
        articleCommentDao.save(articleComment);

    }

 

多对多 查询

Role.java

@Getter
@Setter
@Entity
@Table(name = "role")
public class Role {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    Long id2;

    @Column(name = "role_name")
    String roleName;

    @ManyToMany(targetEntity = User.class, fetch = FetchType.EAGER)
    @JoinTable(name = "user_role_rel",
            //当前表与中间表的关系
            joinColumns = {@JoinColumn(name = "role_id", referencedColumnName = "id2")},
            //另一个表与中间表的关系
            inverseJoinColumns = {@JoinColumn(name = "user_id", referencedColumnName = "id1")})
    List roles;

}

 
User.java

@Getter
@Setter
@Entity
@Table(name = "user")
public class User {


    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    Long id1;

    @Column(name = "user_name")
    String userName;

    @ManyToMany(targetEntity = Role.class, fetch = FetchType.EAGER)
    @JoinTable(name = "user_role_rel",
            //当前表与中间表的关系
            joinColumns = {@JoinColumn(name = "user_id", referencedColumnName = "id1")},
            //另一个表与中间表的关系
            inverseJoinColumns = {@JoinColumn(name = "role_id", referencedColumnName = "id2")})
    List roles;
}

 
Test.java

@Test
@Rollback(value = false)
@Transactional
public void test17() {
    User user = new User();
    user.setUserName("lrc2");

    Role role = new Role();
    role.setRoleName("游客2");

    //中间表关系维护 == 如果不加中间表的数据为空
    role.setRoles(Arrays.asList(user));

    userDao.save(user);
    roleDao.save(role);

}

转载请注明:文章转载自 www.mshxw.com
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号