{"id":157,"date":"2020-07-28T21:01:47","date_gmt":"2020-07-28T13:01:47","guid":{"rendered":"http:\/\/121.89.208.222\/?p=157"},"modified":"2020-12-10T14:24:25","modified_gmt":"2020-12-10T06:24:25","slug":"157","status":"publish","type":"post","link":"http:\/\/moyisuiying.com\/index.php\/mybatis\/157.html","title":{"rendered":"\u57fa\u4e8e\u6ce8\u89e3\u914d\u7f6e\u7684Mybatis\u7684\u589e\u5220\u67e5\u6539"},"content":{"rendered":"\n

1.\u5728\u4e0a\u7bc7\u535a\u5ba2\u4e2d\u4ecb\u7ecd\u4e86\u57fa\u4e8eXML\u914d\u7f6e\u7684Mybatis\u7684\u589e\u5220\u67e5\u6539<\/a>\u7684\u5177\u4f53\u5b9e\u73b0\uff0c\u6b64\u6b21\u4fbf\u5b9e\u73b0\u57fa\u4e8e\u6ce8\u89e3\u5b9e\u73b0mybatis\u7684\u589e\u5220\u67e5\u6539\u529f\u80fd\u3002\u5728\u4e0a\u7bc7\u535a\u5ba2\u57fa\u4e8eXML\u914d\u7f6e\u7684Mybatis\u7684\u589e\u5220\u67e5\u6539<\/a>\u7684\u6e90\u7801\u4ee5\u53ca\u914d\u7f6e\u4e4b\u4e0b\u7ee7\u7eed\u6dfb\u52a0\u6ce8\u89e3\u7684\u5b9e\u73b0\u3002
2.\u9996\u5148\u4fee\u6539mybatis-config.xml\u914d\u7f6e\u6587\u4ef6\uff0c\u5c06UserDao\u7684\u6620\u5c04\u914d\u7f6e\u4fe1\u606f\u6539\u4e3a\u5982\u4e0b\u5185\u5bb9\uff1a<\/p>\n\n\n\n

  <mappers>\n        <!--  \u6307\u5b9aUserdao\u7684\u4f4d\u7f6e-->\n<!--        \u4f7f\u7528\u6ce8\u89e3\uff0c\u6307\u5b9aUserDao\u7684\u5168\u9650\u5b9a\u7c7b\u540d -->\n        <mapper class=\"dao.UserDao\"><\/mapper>\n    <\/mappers><\/code><\/pre>\n\n\n\n
2.\u5728UserDao.java\u4e2d\u6bcf\u4e2a\u65b9\u6cd5\u5bf9\u5e94\u6dfb\u52a0mybatis\u7684\u6ce8\u89e3\u3002<\/p>\n\n\n\n
package <\/strong>dao;\n\nimport <\/strong>entity.User;\nimport <\/strong>org.apache.ibatis.annotations.Delete;\nimport <\/strong>org.apache.ibatis.annotations.Insert;\nimport <\/strong>org.apache.ibatis.annotations.Select;\nimport <\/strong>org.apache.ibatis.annotations.Update;\n\nimport <\/strong>java.util.List;\n\n\/**\n * Classname:mybatisdemo\n * <\/em>@description:User\u7684dao\u63a5\u53e3\n <\/em><\/strong>* <\/em>@author: <\/em><\/strong>\u964c\u610f\u968f\u5f71\n * <\/em>@Date: <\/em><\/strong>2020-07-24 10:35\n *\/\n<\/em>public interface <\/strong>UserDao {\n <\/em><\/strong>\/**\n * <\/em>@date: <\/em><\/strong>2020\/7\/24 0024 10:41\n * <\/em>@description:\u83b7\u53d6\u6240\u6709\u7684\u7528\u6237\u4fe1\u606f\n <\/em><\/strong>* <\/em>@return: <\/em><\/strong>\u8fd4\u56de\u5305\u542b\u6240\u6709\u7684\u7528\u6237\u7684list\n *\/\n <\/em>@Select(<\/em>\"select* from user\")\n <\/em>public <\/strong>List<<\/em><\/strong>User> <\/em><\/strong>getAll()<\/em><\/strong>;\n\/**\n * <\/em>@Description <\/em><\/strong>:\u5411\u6570\u636e\u5e93\u4e2d\u63d2\u5165\u65b0\u7684\u7528\u6237\u4fdd\u5b58\n * <\/em>@Date <\/em><\/strong>12:34 2020\/7\/28 0028\n * <\/em>@Param <\/em><\/strong>* @param user \uff1a\u9700\u8981\u5904\u5165\u7684\u7528\u6237\n * <\/em>@return <\/em><\/strong>void\n **\/\n <\/em>@Insert(<\/em>\"insert into user(name,password,age,createTime) values(#{name},#{password},#{age},#{createTime});\")\n <\/em>public void <\/strong>saveUser(<\/em><\/strong>User user)<\/em><\/strong>;\n\/**\n * <\/em>@Description <\/em><\/strong>:\u6839\u636e\u4e3b\u952eid\u4ece\u6570\u636e\u5e93\u4e2d\u5220\u9664\u7528\u6237\n * <\/em>@Date <\/em><\/strong>12:58 2020\/7\/28 0028\n * <\/em>@Param <\/em><\/strong>* @param id \uff1aUser\u7684\u4e3b\u952eid\n * <\/em>@return <\/em><\/strong>void\n **\/\n <\/em>@Delete(<\/em>\"delete from user where id=#{id}\")\n <\/em>public void <\/strong>deleteUser(<\/em>int <\/strong>id)<\/em><\/strong>;\n\/**\n * <\/em>@Description <\/em><\/strong>:\u66f4\u65b0\u7528\u6237\u4fe1\u606f\n * <\/em>@Date <\/em><\/strong>13:08 2020\/7\/28 0028\n * <\/em>@Param <\/em><\/strong>* @param user \uff1a\u65b0\u7684\u7528\u6237\n * <\/em>@return <\/em><\/strong>void\n **\/\n <\/em>@Update(<\/em>\" update user set name=#{name},password=#{password},age=#{age},createTime=#{createTime} where id=#{id}\")\n <\/em>public void updateUser(<\/em><\/strong>User user)<\/em><\/strong>;\n\/**\n * @Description <\/strong>:\u901a\u8fc7\u4e3b\u952eid\u67e5\u627e\u7528\u6237\n * @Date <\/strong>13:17 2020\/7\/28 0028\n * @Param <\/strong>* @param id \uff1a\n * @return <\/strong>entity.User\n **\/\n @Select(<\/em>\"select * from User where id=#{id}\")\n <\/em>public <\/strong>User findUser(<\/em>int <\/strong>id)<\/em><\/strong>;\n\n}<\/em><\/strong><\/pre>\n\n\n\n
3.\u6d4b\u8bd5\u622a\u56fe
3.1\u6d4b\u8bd5testSaveUser\u65b9\u6cd5
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
3.2\u6d4b\u8bd5testDeleteUser\u65b9\u6cd5\u622a\u56fe
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
3.3\u6d4b\u8bd5testFindUser\u65b9\u6cd5\u622a\u56fe
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
3.4\u6d4b\u8bd5testUpdateUser\u622a\u56fe
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
4.\u6d4b\u8bd5\u7684\u76ee\u5f55\u7ed3\u6784
\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"
\u672c\u6b21\u6d4b\u8bd5\u9879\u76ee\u7684\u6e90\u7801\u5df2\u7ecf\u4e0a\u4f20\u5230\u6211\u7684\u4e2a\u4eba\u535a\u5ba2\uff0c\u9700\u8981\u7684\u81ea\u884c\u4e0b\u8f7d\uff08\u4e0b\u8f7d\u89e3\u538b\u540e\u5bfc\u5165idea\u5373\u53ef\uff09<\/strong>\uff1ahttp:\/\/moyisuiying.com\/wp-content\/uploads\/2020\/07\/mybatisdemo3.rar<\/a><\/p >\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4f7f\u7528\u6ce8\u89e3\u5b9e\u73b0mybatis\u7684\u589e\u5220\u67e5\u6539\u529f\u80fd<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[11,13,24,25],"_links":{"self":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/157"}],"collection":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/comments?post=157"}],"version-history":[{"count":2,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/157\/revisions"}],"predecessor-version":[{"id":215,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/posts\/157\/revisions\/215"}],"wp:attachment":[{"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/media?parent=157"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/categories?post=157"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/moyisuiying.com\/index.php\/wp-json\/wp\/v2\/tags?post=157"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}