{"id":3103,"date":"2023-01-02T16:27:30","date_gmt":"2023-01-02T08:27:30","guid":{"rendered":"https:\/\/qaqaq.top\/?p=3103"},"modified":"2023-01-02T16:27:31","modified_gmt":"2023-01-02T08:27:31","slug":"%e7%89%b9%e6%ae%8asql%e7%9a%84%e6%89%a7%e8%a1%8c","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=3103","title":{"rendered":"\u7279\u6b8aSQL\u7684\u6267\u884c"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">1\u3001\u6a21\u7cca\u67e5\u8be2<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>    \/**\r\n     * \u6d4b\u8bd5\u6a21\u7cca\u67e5\u8be2\r\n     * @param mohu\r\n     * @return\r\n     *\/\r\n    List&lt;User> testMohu(@Param(\"mohu\") String mohu);<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--List&lt;User> testMohu(@Param(\"mohu\") String mohu);-->\r\n    &lt;select id=\"testMohu\" resultType=\"User\">\r\n        &lt;!--select * from t_user where username like '%${mohu}%'-->\r\n        &lt;!--select * from t_user where username like concat('%',#{mohu},'%')-->\r\n        select * from t_user where username like \"%\"#{mohu}\"%\"\r\n    &lt;\/select><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">2\u3001\u6279\u91cf\u5220\u9664<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>    \/**\r\n     * \u6279\u91cf\u5220\u9664\r\n     * @param ids\r\n     * @return\r\n     *\/\r\n    int deleteMore(@Param(\"ids\") String ids);<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--int deleteMore(@Param(\"ids\") String ids);-->\r\n    &lt;delete id=\"deleteMore\">\r\n        delete from t_user where id in (${ids})\r\n    &lt;\/delete><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">3\u3001\u52a8\u6001\u8bbe\u7f6e\u8868\u540d<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>    \/**\r\n     * \u52a8\u6001\u8bbe\u7f6e\u8868\u540d\uff0c\u67e5\u8be2\u6240\u6709\u7684\u7528\u6237\u4fe1\u606f\r\n     * @param tableName\r\n     * @return\r\n     *\/\r\n    List&lt;User> getAllUser(@Param(\"tableName\") String tableName);<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--List&lt;User> getAllUser(@Param(\"tableName\") String tableName);-->\r\n    &lt;select id=\"getAllUser\" resultType=\"User\">\r\n        select * from ${tableName}\r\n    &lt;\/select><\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">4\u3001\u6dfb\u52a0\u529f\u80fd\u83b7\u53d6\u81ea\u589e\u7684\u4e3b\u952e<\/h2>\n\n\n\n<p>t_clazz(clazz_id,clazz_name)<\/p>\n\n\n\n<p>t_student(student_id,student_name,clazz_id)<\/p>\n\n\n\n<p>1\u3001\u6dfb\u52a0\u73ed\u7ea7\u4fe1\u606f<\/p>\n\n\n\n<p>2\u3001\u83b7\u53d6\u65b0\u6dfb\u52a0\u7684\u73ed\u7ea7\u7684id<\/p>\n\n\n\n<p>3\u3001\u4e3a\u73ed\u7ea7\u5206\u914d\u5b66\u751f\uff0c\u5373\u5c06\u67d0\u5b66\u7684\u73ed\u7ea7id\u4fee\u6539\u4e3a\u65b0\u6dfb\u52a0\u7684\u73ed\u7ea7\u7684id<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    \/**\r\n     * \u6dfb\u52a0\u7528\u6237\u4fe1\u606f\r\n     * @param user\r\n     * @return\r\n     * useGeneratedKeys\uff1a\u8bbe\u7f6e\u4f7f\u7528\u81ea\u589e\u7684\u4e3b\u952e\r\n     * keyProperty\uff1a\u56e0\u4e3a\u589e\u5220\u6539\u6709\u7edf\u4e00\u7684\u8fd4\u56de\u503c\u662f\u53d7\u5f71\u54cd\u7684\u884c\u6570\uff0c\u56e0\u6b64\u53ea\u80fd\u5c06\u83b7\u53d6\u7684\u81ea\u589e\u7684\u4e3b\u952e\u653e\u5728\u4f20\u8f93\u7684\u53c2\u6570user\u5bf9\u8c61\u7684\u67d0\u4e2a\u5c5e\u6027\u4e2d\r\n     *\/\r\n    int insertUser(User user);<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--int insertUser(User user);-->\r\n    &lt;insert id=\"insertUser\" useGeneratedKeys=\"true\" keyProperty=\"id\">\r\n        insert into t_user values(null,#{username},#{password},#{age},#{sex})\r\n    &lt;\/insert><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u6a21\u7cca\u67e5\u8be2 2\u3001\u6279\u91cf\u5220\u9664 3\u3001\u52a8\u6001\u8bbe\u7f6e\u8868\u540d 4\u3001\u6dfb\u52a0\u529f\u80fd\u83b7\u53d6\u81ea\u589e\u7684\u4e3b\u952e t_clazz(clazz_id,c [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[108],"tags":[111],"class_list":["post-3103","post","type-post","status-publish","format-standard","hentry","category-mybatis-code","tag-mybatis"],"_links":{"self":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3103"}],"collection":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3103"}],"version-history":[{"count":1,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3103\/revisions"}],"predecessor-version":[{"id":3104,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3103\/revisions\/3104"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}