微信小程序--后端管理平台业务4--Mybatis模糊查询相关

最新推荐文章于 2024-02-18 15:36:45 发布

你能不能别说话

最新推荐文章于 2024-02-18 15:36:45 发布

阅读量683

点赞数

CC 4.0 BY-SA版权

分类专栏： JavaWEB

本文链接：https://blog.csdn.net/sinat_24048051/article/details/77822209

本文介绍了在微信小程序后端管理平台中，如何使用Mybatis进行模糊查询，重点讲解了通过CONCAT拼接实现的方法，避免直接使用%#{name}%的方式。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 @Select("SELECT * FROM course WHERE course_name LIKE CONCAT(CONCAT('%',#{courseName}),'%')")
    @Results({
            @Result(property = "id",column = "course_id"),
            @Result(property = "times",column = "course_times"),
            @Result(property = "depName",column = "dep_name"),
            @Result(property = "depMajor",column = "dep_major"),
            @Result(property = "courseName",column = "course_name"),
            @Result(property = "priority",column = "course_priority"),
            @Result(property = "teacher",column = "course_teacher"),
            @Result(property = "student",column = "course_student"),
            @Result(property = "start",column = "course_start"),
            @Result(property = "end",column = "course_end"),
            @Result(property = "status",column = "course_status"),
            @Result(property = "place",column = "course_place"),
            @Result(property = "time",column = "userb_time"),
    } )