springdatajpa返回自定义实体时的操作以及注意事项

最新推荐文章于 2024-03-03 18:33:19 发布

愿时间能学会宽恕

最新推荐文章于 2024-03-03 18:33:19 发布

阅读量471

点赞数

分类专栏： JavaWeb 文章标签： spring boot java web

尊重版权，转载需指明

本文链接：https://blog.csdn.net/getture/article/details/124123470

版权

JavaWeb 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

自定义了一个TeacherInfo自定义类


@Data
@AllArgsConstructor
@NoArgsConstructor
public class TeacherInfo {
    Long uid;
    int Identity;
    String birthday;
    String college;
    String date_time;
    String idNumber;
    String mobile;
    String name;
    String password;
    String sex;
    int state;

}

内容要与实体类相当对应

@Repository
public interface TeacherDao extends JpaRepository<Teacher,Long>, JpaSpecificationExecutor<Teacher> {
    @Query("SELECT new com.zzy.face.dto.TeacherInfo(a.uid,a.Identity,a.birthday,a.college,a.date_time,a.idNumber,a.mobile,a.name,a.password,a.sex,a.state) from Account as a left join Teacher as t on a.uid = t.uid where t.uid is not null ")
    List<TeacherInfo> findTeachersInfo();
}