{"id":3075,"date":"2023-01-01T19:01:24","date_gmt":"2023-01-01T11:01:24","guid":{"rendered":"https:\/\/qaqaq.top\/?p=3075"},"modified":"2023-01-05T18:04:29","modified_gmt":"2023-01-05T10:04:29","slug":"mybatis%e7%9a%84%e5%a2%9e%e5%88%a0%e6%94%b9%e6%9f%a5","status":"publish","type":"post","link":"https:\/\/qaqaq.top\/?p=3075","title":{"rendered":"MyBatis\u7684\u589e\u5220\u6539\u67e5"},"content":{"rendered":"\n<p>1\u3001\u6dfb\u52a0<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--int insertUser();--&gt;\n    &lt;insert id=\"insertUser\"&gt;\n        insert into t_user values(null,'admin','123456',23,'\u7537')\n    &lt;\/insert&gt;<\/code><\/pre>\n\n\n\n<p>2\u3001\u5220\u9664<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--int deleteUser();--&gt;\n    &lt;delete id=\"deleteUser\"&gt;\n        delete from t_user where id = 7\n    &lt;\/delete&gt;<\/code><\/pre>\n\n\n\n<p>3\u3001\u4fee\u6539<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--int updateUser();--&gt;\n    &lt;update id=\"updateUser\"&gt;\n        update t_user set username='ybc',password='123' where id = 6\n    &lt;\/update&gt;<\/code><\/pre>\n\n\n\n<p>4\u3001\u67e5\u8be2\u4e00\u4e2a\u5b9e\u4f53\u7c7b\u5bf9\u8c61<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--User getUserById();-->\n    &lt;select id=\"getUserById\" resultType=\"top.qaqaq.mybatis.bean.User\">\n        select * from t_user where id = 2\n    &lt;\/select><\/code><\/pre>\n\n\n\n<p>5\u3001\u67e5\u8be2\u96c6\u5408<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>    &lt;!--List&lt;User> getUserList();-->\n    &lt;select id=\"getUserList\" resultType=\"top.qaqaq.mybatis.bean.User\">\n        select * from t_user\n    &lt;\/select><\/code><\/pre>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p>\u6ce8\u610f\uff1a<\/p>\n\n\n\n<p>1\u3001\u67e5\u8be2\u7684\u6807\u7b7eselect\u5fc5\u987b\u8bbe\u7f6e\u5c5e\u6027resultType\u6216resultMap\uff0c\u7528\u4e8e\u8bbe\u7f6e\u5b9e\u4f53\u7c7b\u548c\u6570\u636e\u5e93\u8868\u7684\u6620\u5c04\u5173\u7cfb<\/p>\n\n\n\n<p>resultType\uff1a\u81ea\u52a8\u6620\u5c04\uff0c\u7528\u4e8e\u5c5e\u6027\u540d\u548c\u8868\u4e2d\u5b57\u6bb5\u540d\u4e00\u81f4\u7684\u60c5\u51b5<\/p>\n\n\n\n<p>resultMap\uff1a\u81ea\u5b9a\u4e49\u6620\u5c04\uff0c\u7528\u4e8e\u4e00\u5bf9\u591a\u6216\u591a\u5bf9\u4e00\u6216\u5b57\u6bb5\u540d\u548c\u5c5e\u6027\u540d\u4e0d\u4e00\u81f4\u7684\u60c5\u51b5<\/p>\n\n\n\n<p>2\u3001\u5f53\u67e5\u8be2\u7684\u6570\u636e\u4e3a\u591a\u6761\u65f6\uff0c\u4e0d\u80fd\u4f7f\u7528\u5b9e\u4f53\u7c7b\u4f5c\u4e3a\u8fd4\u56de\u503c\uff0c\u53ea\u80fd\u4f7f\u7528\u96c6\u5408\uff0c\u5426\u5219\u4f1a\u629b\u51fa\u5f02\u5e38<\/p>\n\n\n\n<p>TooManyResultsException\uff1b\u4f46\u662f\u82e5\u67e5\u8be2\u7684\u6570\u636e\u53ea\u6709\u4e00\u6761\uff0c\u53ef\u4ee5\u4f7f\u7528\u5b9e\u4f53\u7c7b\u6216\u96c6\u5408\u4f5c\u4e3a\u8fd4\u56de\u503c<\/p>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>1\u3001\u6dfb\u52a0 2\u3001\u5220\u9664 3\u3001\u4fee\u6539 4\u3001\u67e5\u8be2\u4e00\u4e2a\u5b9e\u4f53\u7c7b\u5bf9\u8c61 5\u3001\u67e5\u8be2\u96c6\u5408 \u6ce8\u610f\uff1a 1\u3001\u67e5\u8be2\u7684\u6807\u7b7eselect\u5fc5\u987b\u8bbe\u7f6e [&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-3075","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\/3075"}],"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=3075"}],"version-history":[{"count":2,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3075\/revisions"}],"predecessor-version":[{"id":3244,"href":"https:\/\/qaqaq.top\/index.php?rest_route=\/wp\/v2\/posts\/3075\/revisions\/3244"}],"wp:attachment":[{"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3075"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3075"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/qaqaq.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3075"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}