{"id":679,"date":"2019-10-19T11:32:08","date_gmt":"2019-10-19T03:32:08","guid":{"rendered":"http:\/\/prayerlaputa.com\/?p=679"},"modified":"2019-10-19T11:33:23","modified_gmt":"2019-10-19T03:33:23","slug":"679","status":"publish","type":"post","link":"http:\/\/prayerlaputa.com\/?p=679","title":{"rendered":"mybatis xml\u5e38\u7528\u5199\u6cd5-\u4f7f\u7528like\u5173\u952e\u5b57\u3010\u6574\u7406+\u8f6c\u8f7d\u3011"},"content":{"rendered":"

\u9700\u6c42\uff1axml\u4e2d\u9700\u8981\u5728where\u4e2d\u62fc\u63a5like\u8bed\u53e5<\/h1>\n
\n

\u65b9\u6cd51\uff1aconcat<\/h2>\n
<where>\r\n    <trim  suffixOverrides=\",\" >\r\n        <if test=\"id != null and id != ''\" >\r\n            and id =  #{id}\r\n        <\/if>\r\n        <if test=\"name != null and name != ''\" >\r\n            and name like concat('%',#{name},'%')\r\n        <\/if>\r\n    <\/trim>\r\n<\/where>\r\n<\/code><\/pre>\n
<\/p>\n
\u65b9\u6cd52\uff1a${}<\/h2>\n
<if test=\"examTypeName!=null and examTypeName!=''\">\r\n    and exam_type_name like '%${examTypeName}%'\r\n<\/if>\r\n<\/code><\/pre>\n
\u65b9\u6cd53\uff1a#{}<\/h2>\n
<if test=\"examTypeName!=null and examTypeName!=''\">\r\n    and exam_type_name like \"%\"#{examTypeName}\"%\"\r\n<\/if>\r\n<\/code><\/pre>\n
\u53c2\u8003\u6587\u7ae0<\/h1>\n