相关联的属性名 “orderby“ 必须后跟 ‘ = ‘ 字符。Mybatisplus使用ORDER BY报错

最新推荐文章于 2024-04-24 11:08:29 发布

Kermit2024

最新推荐文章于 2024-04-24 11:08:29 发布

阅读量630

点赞数

分类专栏： java 文章标签： mybatis java 开发语言

本文链接：https://blog.csdn.net/Obscurede/article/details/130299243

版权

java 专栏收录该内容

43 篇文章 0 订阅

订阅专栏

就这个sql写在Mybatis的xml里就会报错
相关联的属性名 "orderby" 必须后跟 ' = ' 字符。

    <select id="getTeacherCheckMission"
            resultType="com.xut.yiban.user.entity.vo.dormitory.teacher.getTeacherCheckMissionVO">
        SELECT check_time_start startTime,check_time_end endTime,campus_id campusId,check_building building,check_dorms dormNums
        FROM dormitory_techer_mission techer_mission,dormitory_check_info check_info
        WHERE techer_mission.check_id = check_info.check_id
        AND teacher_id=#{teacherId}
        AND #{formattedDateTime}>check_time_start
        AND #{formattedDateTime}<check_time_end
        ORDER BY check_info.check_id DESC
        LIMIT 1

    </select>

没有找到更好的解决办法
于是只能把这个sql放到注解上面写

@Select("        SELECT check_time_start startTime,check_time_end endTime,campus_id campusId,check_building building,check_dorms dormNums\n" +
            "        FROM yiban.dormitory_techer_mission techer_mission,yiban.dormitory_check_info check_info\n" +
            "        WHERE techer_mission.check_id = check_info.check_id\n" +
            "        AND teacher_id=#{teacherId}\n" +
            "        AND #{formattedDateTime}>check_time_start\n" +
            "        AND #{formattedDateTime}<check_time_end\n" +
            "        ORDER BY check_info.check_id DESC\n" +
            "        LIMIT 1")
    @ResultType(getTeacherCheckMissionVO.class)
    getTeacherCheckMissionVO getTeacherCheckMission(int teacherId,String formattedDateTime);