{"id":2768,"date":"2020-12-19T09:18:08","date_gmt":"2020-12-19T01:18:08","guid":{"rendered":"http:\/\/127.0.0.2\/?p=2768"},"modified":"2020-12-19T09:18:08","modified_gmt":"2020-12-19T01:18:08","slug":"2020java%e6%a1%86%e6%9e%b6%e6%95%99%e7%a8%8b%e4%b9%8bmybatis%e6%a8%a1%e7%b3%8a%e6%9f%a5%e8%af%a2%e5%92%8c%e6%8e%92%e5%ba%8f","status":"publish","type":"post","link":"https:\/\/www.9713job.com\/?p=2768","title":{"rendered":"2020java\u6846\u67b6\u6559\u7a0b\u4e4bmybatis\u6a21\u7cca\u67e5\u8be2\u548c\u6392\u5e8f"},"content":{"rendered":"

2020java\u6846\u67b6\u6559\u7a0b\u4e4bmybatis\u6a21\u7cca\u67e5\u8be2\u548c\u6392\u5e8f<\/h3>\n

1.\u6a21\u7cca\u67e5\u8be2<\/strong><\/p>\n

\u9700\u6c42\uff1a\u6839\u636e\u5bf9\u65b9\u7684\u7528\u6237\u540d\u67e5\u8be2\u4fe1\u606f(\u6a21\u7cca\u67e5\u8be2)<\/p>\n

\u65b9\u5f0f1\uff1a\u4f7f\u7528 #\u4f20\u53c2<\/p>\n

<select id=\"selectUsersName\" parameterType=\"string\" resultMap=\"usersResultMap\">\r\n    select *from users where username like #{username}<\/strong>\r\n<\/select><\/pre>\n
\u65b9\u5f0f2\uff1a\u4f7f\u7528 $ \u4f20\u53c2<\/p>\n
<select id=\"selectUsersName2\" parameterType=\"string\" resultMap=\"usersResultMap\">\r\n    select *from users where username like '%${value}%'<\/strong><\/span>\r\n<\/select><\/pre>\n
\u6ce8\u610f\uff1a\u5f53\u4f7f\u7528$\u4f20\u53c2\u65f6\uff0c\u5982\u679c\u53c2\u6570\u662f\u5355\u503c\u5c5e\u6027\uff0c\u5e76\u4e14\u53ea\u6709\u4e00\u4e2a\u53c2\u6570\uff0c\u90a3\u4e48\u53c2\u6570\u5fc5\u987b\u4f7f\u7528 value<\/strong> \u5360\u4f4d<\/span><\/p>\n
<\/p>\n
\u6bd4\u8f83#\u548c$\u7684\u533a\u522b\uff1a<\/strong><\/p>\n
#{ }\u662f\u9884\u7f16\u8bd1\u5904\u7406\uff0cMyBatis\u5728\u5904\u7406#{ }\u65f6\uff0c\u5b83\u4f1a\u5c06sql\u4e2d\u7684#{ }\u66ff\u6362\u4e3a\uff1f\uff0c\u7136\u540e\u8c03\u7528PreparedStatement\u7684set\u65b9\u6cd5\u6765\u8d4b\u503c\uff0c\u4f20\u5165\u5b57\u7b26\u4e32\u540e\uff0c\u4f1a\u5728\u503c\u4e24\u8fb9\u52a0\u4e0a\u5355\u5f15\u53f7\uff0c\u4f7f\u7528\u5360\u4f4d\u7b26\u7684\u65b9\u5f0f\u63d0\u9ad8\u6548\u7387\uff0c\u53ef\u4ee5\u9632\u6b62sql\u6ce8\u5165\u3002<\/p>\n
${}:\u8868\u793a\u62fc\u63a5sql\u5b57\u7b26\u4e32\uff0c\u5c06\u63a5\u6536\u5230\u53c2\u6570\u7684\u5185\u5bb9\u4e0d\u52a0\u4efb\u4f55\u4fee\u9970\u62fc\u63a5\u5728sql\u4e2d\uff0c\u53ef\u80fd\u5f15\u53d1sql\u6ce8\u5165\u3002<\/p>\n
#\u662f\u5360\u4f4d\u7b26?\uff0c$\u662f\u5b57\u7b26\u4e32\u62fc\u63a5\u3002
\n\u56e0\u6b64\u4f7f\u7528$\u7684\u65f6\u5019\uff0c\u5982\u679c\u53c2\u6570\u662f\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u90a3\u4e48\u8981\u4f7f\u7528\u5f15\u53f7\u3002
\n\u5c3d\u91cf\u4f7f\u7528#\u800c\u4e0d\u662f$\uff0c\u5f53\u53c2\u6570\u8868\u793a\u8868\u540d\u6216\u5217\u540d\u7684\u65f6\u5019\uff0c\u53ea\u80fd\u4f7f\u7528$<\/p>\n
\u4e0d\u533a\u5206\u5927\u5c0f\u5199<\/strong><\/p>\n
select*from users where lower(username) like lower('%${value}%')<\/pre>\n
<\/h3>\n
\u89e3\u51b3\u5b57\u7b26\u4e32\u62fc\u63a5\u4ea7\u751fsql\u6ce8\u5165<\/h3>\n
select*from users where username like concat('%','${value}','%')<\/pre>\n
2.\u6392\u5e8f<\/strong><\/p>\n
\u7528\u6237\u540d\u6392\u5e8f<\/p>\n
select*from users order by convert(${value} using gbk)<\/pre>\n","protected":false},"excerpt":{"rendered":"
2020java\u6846\u67b6\u6559\u7a0b\u4e4bmybatis\u6a21\u7cca\u67e5\u8be2\u548c\u6392\u5e8f 1.\u6a21\u7cca\u67e5\u8be2 \u9700\u6c42\uff1a\u6839\u636e\u5bf9\u65b9\u7684\u7528\u6237\u540d\u67e5\u8be2\u4fe1\u606f(\u6a21\u7cca\u67e5\u8be2 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-2768","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/posts\/2768","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.9713job.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2768"}],"version-history":[{"count":4,"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/posts\/2768\/revisions"}],"predecessor-version":[{"id":2775,"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/posts\/2768\/revisions\/2775"}],"wp:attachment":[{"href":"https:\/\/www.9713job.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2768"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.9713job.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2768"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.9713job.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2768"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}