{"id":2780,"date":"2020-12-19T10:47:47","date_gmt":"2020-12-19T02:47:47","guid":{"rendered":"http:\/\/127.0.0.2\/?p=2780"},"modified":"2020-12-19T10:47:47","modified_gmt":"2020-12-19T02:47:47","slug":"2020java%e6%a1%86%e6%9e%b6%e6%95%99%e7%a8%8b%e4%b9%8bmybatis%e8%8e%b7%e5%8f%96%e5%88%9a%e5%88%9a%e6%8f%92%e5%85%a5%e7%9a%84id%e8%87%aa%e5%a2%9e","status":"publish","type":"post","link":"https:\/\/www.9713job.com\/?p=2780","title":{"rendered":"2020java\u6846\u67b6\u6559\u7a0b\u4e4bmybatis\u83b7\u53d6\u521a\u521a\u63d2\u5165\u7684id(\u81ea\u589e)"},"content":{"rendered":"<h3>2020java\u6846\u67b6\u6559\u7a0b\u4e4bmybatis\u83b7\u53d6\u521a\u521a\u63d2\u5165\u7684id(\u81ea\u589e)<\/h3>\n<p>\u4e00\uff1a\u63d2\u5165\u8bb0\u5f55<\/p>\n<p>\u9700\u6c42\uff1a\u65b0\u589e\u4e00\u4e2a\u7528\u6237<\/p>\n<p>DDL\u64cd\u4f5c<\/p>\n<p>\u4e8c\uff1a\u83b7\u53d6\u81ea\u589eid<\/p>\n<pre>&lt;insert id=\"insertUsers\" parameterType=\"Users\" <span style=\"color: #0000ff;\"><strong>useGeneratedKeys=\"true\" keyProperty=\"id\"<\/strong><\/span>&gt;\r\n    insert into users(username,password,rolename,identity,mobile)\r\n    values(#{username},#{password},#{rolename},#{identity},#{mobile})\r\n&lt;\/insert&gt;<\/pre>\n<p><!--more--><\/p>\n<pre>@Test\r\npublic void test10(){\r\n    SqlSession sqlSession = MybatisUtils.getSqlSession();\r\n    UsersDao mapper = sqlSession.getMapper(UsersDao.class);\r\n    Users users=new Users(\"\u53efadmin444\",\"admin444\",\"\u53efadmin444\",\"7\",\"144\");\r\n    int i = mapper.insertUsers(users);\r\n    if(i&gt;0) System.out.println(\"\u65b0\u589e\u6210\u529f\");\r\n    else System.out.println(\"\u65b0\u589e\u5931\u8d25\");\r\n    <span style=\"color: #0000ff;\"><strong>sqlSession.commit();\/\/\u4e8b\u52a1\u63d0\u4ea4<\/strong><\/span>\r\n    sqlSession.close();\r\n    System.out.println(users);\r\n}<\/pre>\n<p>\u4e5f\u53ef\u4ee5\u5728mybatis-config.xml\u914d\u7f6e<\/p>\n<pre>&lt;settings&gt;\r\n    &lt;setting name=\"<strong><span style=\"color: #0000ff;\">useGeneratedKeys<\/span><\/strong>\" value=\"true\"\/&gt;\r\n&lt;\/settings&gt;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>2020java\u6846\u67b6\u6559\u7a0b\u4e4bmybatis\u83b7\u53d6\u521a\u521a\u63d2\u5165\u7684id(\u81ea\u589e) \u4e00\uff1a\u63d2\u5165\u8bb0\u5f55 \u9700\u6c42\uff1a\u65b0\u589e\u4e00\u4e2a\u7528\u6237 DDL\u64cd [&hellip;]<\/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-2780","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/posts\/2780","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=2780"}],"version-history":[{"count":2,"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/posts\/2780\/revisions"}],"predecessor-version":[{"id":2782,"href":"https:\/\/www.9713job.com\/index.php?rest_route=\/wp\/v2\/posts\/2780\/revisions\/2782"}],"wp:attachment":[{"href":"https:\/\/www.9713job.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2780"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.9713job.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2780"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.9713job.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2780"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}