Dao层使用JpaRepositoryorg.springframework.boot spring-boot-starter-parent2.4.1 org.springframework.boot spring-boot-starterorg.springframework.boot spring-boot-starter-data-jpa
1.实体类
@Data
@Entity()
@Table(name = "person")
public class Person {
// wu 2022/1/21
// 吴 2022/1/21
// @TableId(value = "id",type = IdType.AUTO)
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private int id;
@Column(name = "name")
private String name;
@Column(name = "age")
private int age;
@Column(name = "account")
private String account;
@Column(name = "password")
// @TableField(typeHandler = Base64TypeHandler.class)
@Convert(converter = EncryptConverter.class)
private String password;
@Override
public String toString() {
return "Person{" +
"id=" + id +
", name='" + name + ''' +
", age=" + age +
", account='" + account + ''' +
", password='" + password + ''' +
'}';
}
}
2.dao层
@Repository public interface PersonDao extends JpaRepository, JpaSpecificationExecutor { }
3.直接使用findAll()方法
List使用JpaRepositoryall= personDao.findAll(); System.out.println("all= " + all);
1.自定义方法规则
例:一定要使用 JPA 规定的形式 findBy+参数名+Like(参数)
findByName(String name) ——> select * from person where name ="name";
findByNameLike(String name) ——> select * from person where name like "name";
like语句 调用时传参需要在参数上加上%,例如:personDao.findByName("%" +"zhangsan"+"%");
2.使用
List使用JpaRepositorypersons= personDao.findByNameLike("Li"+"%"); // Person person = personDao.findById(1); System.out.println("persons= " + persons);
在service层实现拼接查询
public Page findAll(String name, Long start, Long end, Integer page, Integer size) {
// Specification specification =
Page all = personDao.findAll((Specification) (root, criteriaQuery, criteriaBuilder) -> {
List predicates = new ArrayList<>();
predicates.add(criteriaBuilder.equal(root.get("age"), 19));
predicates.add(criteriaBuilder.like(root.get("name"),"Li"+"%"));
return criteriaBuilder.and(predicates.toArray(new Predicate[predicates.size()]));
}, PageRequest.of(page,size));
return all;
}
public void testFindAllWithArgs(){
Page page = personService.findAll("adf",1L,2L,0,4);
List content = page.getContent();
content.iterator().forEachRemaining(person -> System.out.println("person = " + person));
}



