@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);
}
@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);
}
@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
@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
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
修改、删除
@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", "测试");
}
@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
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 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);
}