/**
* 模糊查询
* @return
*/
@Query("from StudentInformation as s where (" +
"s.name like %?1% or ?1 =null) and " +
"(s.stuNo =?2 or ?2 = null) and " +
"(s.endDate >= ?9 or ?9=null) and " +
"(s.endDate <= ?10 or ?10=null) and " +
"(s.tutorName =?11 or ?11 = null) and " +
"(s.status =?12 or ?12 = null) and " +
"(s.eduDegree =?13 or ?13 = null)")
List<StudentInformation> queryStuInfo(
String name,
String stuNo,
LocalDate endDateMin ,
LocalDate endDateMax ,
String tutorName,
String status,
String eduDegree);
Spring Boot 模糊查询
最新推荐文章于 2024-03-05 20:27:52 发布