测试

　　

/**
 * 模糊查询
 * @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);