Mybatis中生成动态SQL的标签有四类,分别是: if choose (when, otherwise) trim (where, set) foreach 1.if 当需要动态生成where条件时,可以使用if标签: <select id="findActiveBlogWithTitleLike" resultType="Blog"> SELECT * FROM BLOG WHERE state = ‘ACTIVE’ <if test=&qu
mybatis-plus常用功能总结-以User表为例 1.数据库 id name age email create_time update_time version deleted 1 mary 20 mary@qq.com 2021-05-06 08:13:31 2021-05-06 08:13:31 1 1 2 jack 20 jack@qq.com 2021-05-06 08:33:55 2021-05-06 08:33:55 1 0 3 rose 20 rose@qq.com 2021