jpa实现增删改查及分页操作

@Data
@Entity
@Builder
@Table(name = "student")
@AllArgsConstructor
@NoArgsConstructor
public class Student {
    @Id
    @Column(name = "id")
    private Integer id;
    @Column(name = "name")
    private String name;
    @Column(name = "sex")
    private String sex;
}

@Data
@Builder
@Entity
@AllArgsConstructor
@NoArgsConstructor
@Table(name = "lesson")
public class Lesson {
    @Id
    @Column(name = "id")
    private Integer id;
    @Column(name = "name")
    private String name;
}

@Data
@Entity
@Builder
@AllArgsConstructor
@NoArgsConstructor
@Table(name = "score")
public class Score {
    @Id
    @Column(name = "score_id")
    private Integer scoreId;
    @Column(name = "student_id")
    private Integer studentId;
    @Column(name = "lesson_id")
    private Integer lessonId;
    @Column(name = "score")
    private Integer score;
}

@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
public class EveryScoreDto {
    private String studentName;
    private String lessonName;
    private Integer score;
}

@Query(value = "select name from lesson",nativeQuery = true)
List<String> getLessonName();

@Query(value = "select student.name as studentName, lesson.name as lessonName, score.score as score from Score as score,Student as student,Lesson as lesson where score.studentId = student.id and score.lessonId = lesson.id and student.name= :name",nativeQuery = false)
Page<Map<String,Object>> getByName(String name, Pageable pageable);

Specification<Score> specification = new Specification<Score>() {
    @Override
    public Predicate toPredicate(Root root, CriteriaQuery query, CriteriaBuilder criteriaBuilder) {
        return query.orderBy(criteriaBuilder.asc(root.get("lessonId"))).where(criteriaBuilder.greaterThanOrEqualTo(root.get("score").as(Integer.class),60)).getRestriction();
    }
};