\n\t\u7b2c\u4e8c\u6b65\uff0c\u5728 pom.xml \u6587\u4ef6\u4e2d\u914d\u7f6e Mybatis\uff0cMysql \u7b49\u7b2c\u4e09\u65b9 jar \u5305\u7684\u4f9d\u8d56\u3002\n<\/p>\n
\r\n<dependency>\r\n\t<groupId>org.mybatis.spring.boot<\/groupId>\r\n\t<artifactId>mybatis-spring-boot-starter<\/artifactId>\r\n\t<version>1.3.1<\/version>\r\n<\/dependency>\r\n<!-- \u4e1a\u4f59\u8349\uff1awww.xttblog.com -->\r\n<dependency>\r\n\t<groupId>mysql<\/groupId>\r\n\t<artifactId>mysql-connector-java<\/artifactId>\r\n\t<scope>runtime<\/scope>\r\n<\/dependency><\/pre>\n\n\t\u6709\u5174\u8da3\u7684\u670b\u53cb\uff0c\u53ef\u4ee5\u5728\u914d\u7f6e\u963f\u91cc\u7684 Druid \u6570\u636e\u5e93\u8fde\u63a5\u6c60\u3002\n<\/p>\n
\n\t\u7b2c\u4e09\u6b65\uff0c\u5728 application.yml \u6587\u4ef6\u4e2d\u914d\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\u3002\u5982\u4e0b\u6240\u793a\uff1a\n<\/p>\n
\r\nspring:\r\n datasource:\r\n url: jdbc:mysql:\/\/127.0.0.1:3306\/xttblog\r\n username: root\r\n password: root\r\n driver-class-name: com.mysql.jdbc.Driver<\/pre>\n\n\t\u7b2c\u56db\u6b65\uff0c\u521b\u5efa\u6570\u636e\u5e93\u548c\u6570\u636e\u8868\u3002\n<\/p>\n
\r\nCREATE DATABASE xttblog;\r\n\r\nUSE xttblog;\r\n\r\nCREATE TABLE t_user(\r\n id BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT,\r\n name VARCHAR(255) NOT NULL ,\r\n password VARCHAR(255) NOT NULL ,\r\n phone VARCHAR(255) NOT NULL\r\n) ENGINE=INNODB AUTO_INCREMENT=1000 DEFAULT CHARSET=utf8;<\/pre>\n\n\t\u7b2c\u4e94\u6b65\uff0c\u521b\u5efa t_user \u8868\u6240\u5bf9\u5e94\u7684\u5b9e\u4f53\u7c7b\u3002\n<\/p>\n
\r\npackage com.xttblog.domain;\r\n\r\n\/**\r\n * User\u5b9e\u4f53\u6620\u5c04\u7c7b\r\n * Created by www.xttblog.com on 2018\/06\/30.\r\n *\/\r\n\r\npublic class User {\r\n\r\n private Integer id;\r\n private String name;\r\n private String password;\r\n private String phone;\r\n\r\n \/\/\u7701\u7565 get \u548c set ...\r\n}<\/pre>\n\n\t\u7b2c\u516d\u6b65\uff0c\u521b\u5efa User \u6620\u5c04\u7684\u64cd\u4f5c UserMapper\uff0c\u4e3a\u4e86\u540e\u7eed\u5355\u5143\u6d4b\u8bd5\u9a8c\u8bc1\uff0c\u5b9e\u73b0\u63d2\u5165\u548c\u67e5\u8be2\u64cd\u4f5c\u3002\n<\/p>\n
\r\npackage com.xttblog.mapper;\r\n\r\nimport com.xttblog.domain.User;\r\nimport org.apache.ibatis.annotations.Insert;\r\nimport org.apache.ibatis.annotations.Mapper;\r\nimport org.apache.ibatis.annotations.Param;\r\nimport org.apache.ibatis.annotations.Select;\r\n\r\n\/**\r\n * User\u6620\u5c04\u7c7b\r\n * Created by www.xttblog.com on 2018\/06\/30.\r\n *\/\r\n@Mapper\r\npublic interface UserMapper {\r\n\r\n @Select("SELECT * FROM T_USER WHERE PHONE = #{phone}")\r\n User findUserByPhone(@Param("phone") String phone);\r\n\r\n @Insert("INSERT INTO T_USER(NAME, PASSWORD, PHONE) VALUES(#{name}, #{password}, #{phone})")\r\n int insert(@Param("name") String name, @Param("password") String password, @Param("phone") String phone);\r\n\r\n}<\/pre>\n\n\tspring boot \u7684\u542f\u52a8\u7c7b\uff0c\u5728\u521b\u5efa\u9879\u76ee\u7684\u65f6\u5019\u5c31\u8ddf\u7740\u521b\u5efa\u4e86\uff0c\u5c31\u4e0d\u5728\u63d0\u793a\u4e86\u3002\u4ee3\u7801\u5982\u4e0b\uff1a\n<\/p>\n
\r\npackage com.xttblog;\r\n\r\nimport org.springframework.boot.SpringApplication;\r\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\r\n\r\n@SpringBootApplication\r\npublic class SpringbootMybatisDemo2Application {\r\n\r\n public static void main(String[] args) {\r\n SpringApplication.run(SpringbootMybatisDemo2Application.class, args);\r\n }\r\n}<\/pre>\n\n\t\u6700\u540e\u4e00\u6b65\uff0c\u4e5f\u5c31\u662f\u7b2c7\u6b65\uff0c\u4f7f\u7528 @SpringBootTest \u6765\u6d4b\u8bd5\u6211\u4eec\u7684 Spring boot Mybatis \u6846\u67b6\u6574\u5408\u7684\u662f\u5426\u6709\u95ee\u9898\u3002\u4ee3\u7801\u5982\u4e0b\uff1a\n<\/p>\n
\r\npackage com.xttblog;\r\n\r\nimport com.xttblog.domain.User;\r\nimport com.xttblog.mapper.UserMapper;\r\nimport org.junit.Assert;\r\nimport org.junit.Test;\r\nimport org.junit.runner.RunWith;\r\nimport org.springframework.beans.factory.annotation.Autowired;\r\nimport org.springframework.boot.test.context.SpringBootTest;\r\nimport org.springframework.test.context.junit4.SpringRunner;\r\n\r\n@RunWith(SpringRunner.class)\r\n@SpringBootTest\r\npublic class SpringbootMybatisDemo2ApplicationTests {\r\n\r\n @Autowired\r\n private UserMapper userMapper;\r\n\r\n @Test\r\n public void test(){\r\n\r\n userMapper.insert("xttblog", "123456", "12345678910");\r\n User u = userMapper.findUserByPhone("12345678910");\r\n Assert.assertEquals("xttblog", u.getName());\r\n }\r\n\r\n}<\/pre>\n\n\t\u5982\u679c\u4f60\u8ba4\u771f\u6309\u7167\u6211\u7684\u6b65\u9aa4\u6765\uff0c\u6700\u7ec8\u7684\u7ed3\u679c\u662f\u5355\u5143\u6d4b\u8bd5\u8fd0\u884c\u6210\u529f\uff0c\u7eff\u8272\u901a\u8fc7\u3002\n<\/p>\n
\n\t\u57fa\u4e8e\u4ee5\u4e0a\u7684\u4ee3\u7801\uff0c\u4f60\u662f\u4e0d\u662f\u611f\u89c9 Spring boot \u7528\u8d77\u6765\u975e\u5e38\u7684\u723d\uff01\u8d76\u5feb\u5173\u6ce8\u6211\u7684\u535a\u5ba2\u5427\uff0c\u4e00\u8d77\u6765\u5b66\u4e60 Spring boot\u3002<\/p>\n
<\/p>
\u6700\u540e\uff0c\u6b22\u8fce\u5173\u6ce8\u6211\u7684\u4e2a\u4eba\u5fae\u4fe1\u516c\u4f17\u53f7\uff1a\u4e1a\u4f59\u8349\uff08yyucao\uff09\uff01\u53ef\u52a0\u4f5c\u8005\u5fae\u4fe1\u53f7\uff1axttblog2<\/font>\u3002\u5907\u6ce8\uff1a\u201c1\u201d\uff0c\u6dfb\u52a0\u535a\u4e3b\u5fae\u4fe1\u62c9\u4f60\u8fdb\u5fae\u4fe1\u7fa4\u3002\u5907\u6ce8\u9519\u8bef\u4e0d\u4f1a\u540c\u610f\u597d\u53cb\u7533\u8bf7\u3002<\/b>\u518d\u6b21\u611f\u8c22\u60a8\u7684\u5173\u6ce8\uff01\u540e\u7eed\u6709\u7cbe\u5f69\u5185\u5bb9\u4f1a\u7b2c\u4e00\u65f6\u95f4\u53d1\u7ed9\u60a8\uff01\u539f\u521b\u6587\u7ae0\u6295\u7a3f\u8bf7\u53d1\u9001\u81f3532009913@qq.com\u90ae\u7bb1\u3002\u5546\u52a1\u5408\u4f5c\u4e5f\u53ef\u6dfb\u52a0\u4f5c\u8005\u5fae\u4fe1\u8fdb\u884c\u8054\u7cfb\uff01<\/p>
\u672c\u6587\u539f\u6587\u51fa\u5904\uff1a\u4e1a\u4f59\u8349<\/a>\uff1a » spring boot mybatis \u6574\u5408\u6559\u7a0b<\/a><\/p>","protected":false},"excerpt":{"rendered":"
Struts2 \u5df2\u88ab\u5b8c\u5168\u6dd8\u6c70\uff0c\u8fde Apache \u81ea\u5df1\u90fd\u4e0d\u5728\u4f7f\u7528\u4e86\u3002\u968f\u7740\u5fae\u670d\u52a1\u7684\u6d41\u884c\uff0cSpring MVC \u7684\u9879 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[69,1037,1653,587,588],"class_list":["post-2912","post","type-post","status-publish","format-standard","hentry","category-java","tag-java","tag-mybatis","tag-mybatisplus","tag-spring-boot","tag-spring-cloud"],"_links":{"self":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2912","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2912"}],"version-history":[{"count":1,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2912\/revisions"}],"predecessor-version":[{"id":2913,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=\/wp\/v2\/posts\/2912\/revisions\/2913"}],"wp:attachment":[{"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2912"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2912"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xttblog.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2912"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}