jpa中sql常见语句使用
- nativeQuery = true语法 表示使用原生sql
@Query(value = "select * from CheckDayInfo info where info.date = ?1 ORDER by checked ASC, checkedTime ASC", nativeQuery = true)
NEXTjpa 多表查询，返回到VO
@Query(value = "select * from CheckDayInfo info where info.date = ?1 ORDER by checked ASC, checkedTime ASC", nativeQuery = true)