{"id":3774,"date":"2018-09-16T18:25:36","date_gmt":"2018-09-16T10:25:36","guid":{"rendered":"http:\/\/www.menglanglang.cn\/?p=3774"},"modified":"2020-02-17T18:28:06","modified_gmt":"2020-02-17T10:28:06","slug":"spring-boot-%e5%88%9d%e7%ba%a7%e5%85%a5%e9%97%a8%e6%95%99%e7%a8%8b%ef%bc%88%e5%8d%81%e4%ba%94%ef%bc%89-%e9%9b%86%e6%88%90-mybatis","status":"publish","type":"post","link":"http:\/\/www.menglanglang.cn\/?p=3774","title":{"rendered":"Spring Boot \u521d\u7ea7\u5165\u95e8\u6559\u7a0b\uff08\u5341\u4e94\uff09 \u2014\u2014 \u96c6\u6210 MyBatis"},"content":{"rendered":"\n

\u57fa\u4e8e\u4e0a\u7bc7\u6587\u7ae0\uff0c\u8fd9\u7bc7\u4e3b\u8981\u8bf4\u4e0b\u5982\u4f55\u96c6\u6210 MyBatis\uff0c\u8fd9\u6837\u6d4b\u8bd5\u65f6\u4e5f\u4e0d\u7528\u5728\u50cf JdbcTemplate \u90a3\u6837\u5728 java \u4ee3\u7801\u4e2d\u5199 sql \u8bed\u53e5\u4e86\u3002<\/p>\n\n\n\n

\u4e00\u3001\u6dfb\u52a0 MyBatis \u4f9d\u8d56\u5305<\/h3>\n\n\n\n

\u5728 pom \u6587\u4ef6\u4e2d\uff0c\u6dfb\u52a0\u652f\u6301 MyBatis \u7684\u4f9d\u8d56\u5305\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n

\t\t<!-- mybatis\u63d2\u4ef6 -->\n\t\t<dependency>\n\t\t\t<groupId>org.mybatis.spring.boot<\/groupId>\n\t\t\t<artifactId>mybatis-spring-boot-starter<\/artifactId>\n\t\t\t<version>1.3.2<\/version>\n\t\t<\/dependency><\/code><\/pre>\n\n\n\n
\u4e8c\u3001\u65b0\u5efa\u5b58\u653e xml \u7684\u76ee\u5f55<\/h3>\n\n\n\n
\u5728 resources \u76ee\u5f55\u4e0b\uff0c\u521b\u5efa mapper > mysql \u76ee\u5f55\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u4e09\u3001\u914d\u7f6e\u8bfb\u53d6 xml \u6587\u4ef6\u7684\u8def\u5f84<\/h3>\n\n\n\n
\u5728 properties \u6587\u4ef6\u4e2d\uff0c\u914d\u7f6e\u8bfb\u53d6 xml \u6587\u4ef6\u7684\u8def\u5f84\u4fe1\u606f\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n
#################################\n## MyBatis \u914d\u7f6e\n#################################\nmybatis.mapper-locations=classpath:mapper\/mysql\/*.xml<\/code><\/pre>\n\n\n\n
\u56db\u3001\u521b\u5efa\u5305<\/h3>\n\n\n\n
\u4e3a\u4e86\u8ba9\u4ee3\u7801\u76ee\u5f55\u66f4\u52a0\u4fe1\u606f\u660e\u4e86\uff0c\u9700\u8981\u521b\u5efa\u51e0\u4e2a\u5305\uff1amapper\u3001service\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
\u4e94\u3001\u7f16\u5199\u6d4b\u8bd5\u4ee3\u7801<\/h3>\n\n\n\n
\u5b9e\u4f53\u7c7b UserInfo.java\uff1a<\/p>\n\n\n\n
<\/div>
  1. package<\/span> com.menglanglang.test.springboot.entity;  <\/span><\/span><\/li>
  2.   <\/span><\/li>
  3. \/**<\/span> <\/span><\/li>
  4.  * @desc \u7528\u6237\u4fe1\u606f\u7c7b<\/span> <\/span><\/li>
  5.  *<\/span> <\/span><\/li>
  6.  * @author \u5b5f\u90ce\u90ce<\/span> <\/span><\/li>
  7.  * @blog http:\/\/blog.csdn.net\/tzhuwb<\/span> <\/span><\/li>
  8.  * @version 1.0<\/span> <\/span><\/li>
  9.  * @date 2018\u5e749\u670816\u65e5\u4e0b\u53484:59:40<\/span> <\/span><\/li>
  10.  *\/<\/span>  <\/span><\/span><\/li>
  11. public<\/span> <\/span>class<\/span> UserInfo {  <\/span><\/span><\/li>
  12.   <\/span><\/li>
  13.     \/**<\/span> <\/span><\/li>
  14.      * \u4e3b\u952e<\/span> <\/span><\/li>
  15.      *\/<\/span>  <\/span><\/span><\/li>
  16.     private<\/span> <\/span>int<\/span> id;  <\/span><\/span><\/li>
  17.   <\/span><\/li>
  18.     \/**<\/span> <\/span><\/li>
  19.      * \u7528\u6237\u59d3\u540d<\/span> <\/span><\/li>
  20.      *\/<\/span>  <\/span><\/span><\/li>
  21.     private<\/span> String name;  <\/span><\/span><\/li>
  22.   <\/span><\/li>
  23.     \/**<\/span> <\/span><\/li>
  24.      * \u7528\u6237\u5e74\u9f84<\/span> <\/span><\/li>
  25.      *\/<\/span>  <\/span><\/span><\/li>
  26.     private<\/span> <\/span>int<\/span> age;  <\/span><\/span><\/li>
  27.   <\/span><\/li>
  28.     public<\/span> <\/span>int<\/span> getId() {  <\/span><\/span><\/li>
  29.         return<\/span> id;  <\/span><\/span><\/li>
  30.     }  <\/span><\/li>
  31.   <\/span><\/li>
  32.     public<\/span> <\/span>void<\/span> setId(<\/span>int<\/span> id) {  <\/span><\/span><\/li>
  33.         this<\/span>.id = id;  <\/span><\/span><\/li>
  34.     }  <\/span><\/li>
  35.   <\/span><\/li>
  36.     public<\/span> String getName() {  <\/span><\/span><\/li>
  37.         return<\/span> name;  <\/span><\/span><\/li>
  38.     }  <\/span><\/li>
  39.   <\/span><\/li>
  40.     public<\/span> <\/span>void<\/span> setName(String name) {  <\/span><\/span><\/li>
  41.         this<\/span>.name = name;  <\/span><\/span><\/li>
  42.     }  <\/span><\/li>
  43.   <\/span><\/li>
  44.     public<\/span> <\/span>int<\/span> getAge() {  <\/span><\/span><\/li>
  45.         return<\/span> age;  <\/span><\/span><\/li>
  46.     }  <\/span><\/li>
  47.   <\/span><\/li>
  48.     public<\/span> <\/span>void<\/span> setAge(<\/span>int<\/span> age) {  <\/span><\/span><\/li>
  49.         this<\/span>.age = age;  <\/span><\/span><\/li>
  50.     }  <\/span><\/li>
  51.   <\/span><\/li>
  52. }  <\/span><\/li><\/ol><\/div>\n\n\n\n
    SQL\u811a\u672c mybati-mapper.xml\uff1a<\/p>\n\n\n\n
    <\/div>
    1. <?xml version=<\/span>\"1.0\"<\/span> encoding=<\/span>\"UTF-8\"<\/span> ?>  <\/span><\/span><\/li>
    2. <!DOCTYPE mapper PUBLIC<\/span> <\/span>\"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\"<\/span> <\/span>\"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\"<\/span> >  <\/span><\/span><\/li>
    3. <mapper namespace=\"com.menglanglang.test.springboot.mapper.MyBatisMapper\"<\/span>>  <\/span><\/span><\/li>
    4.     <resultMap id=\"UserMap\"<\/span> type=<\/span>\"com.menglanglang.test.springboot.entity.UserInfo\"<\/span>>  <\/span><\/span><\/li>
    5.         <result column<\/span>=<\/span>\"ID\"<\/span> property=<\/span>\"id\"<\/span> jdbcType=<\/span>\"INTEGER\"<\/span> \/>  <\/span><\/span><\/li>
    6.         <result column<\/span>=<\/span>\"NAME\"<\/span> property=<\/span>\"name\"<\/span> jdbcType=<\/span>\"VARCHAR\"<\/span> \/>  <\/span><\/span><\/li>
    7.         <result column<\/span>=<\/span>\"AGE\"<\/span> property=<\/span>\"age\"<\/span> jdbcType=<\/span>\"INTEGER\"<\/span> \/>  <\/span><\/span><\/li>
    8.     <\/resultMap>  <\/span><\/li>
    9.   <\/span><\/li>
    10.     <select<\/span> id=<\/span>\"selectUserList\"<\/span> resultMap=<\/span>\"UserMap\"<\/span>>  <\/span><\/span><\/li>
    11.         select<\/span> * <\/span>from<\/span> <\/span>user<\/span>  <\/span><\/span><\/li>
    12.     <\/select<\/span>>  <\/span><\/span><\/li>
    13.   <\/span><\/li>
    14.     <select<\/span> id=<\/span>\"selectUser\"<\/span> parameterType=<\/span>\"java.lang.Integer\"<\/span> resultMap=<\/span>\"UserMap\"<\/span>>  <\/span><\/span><\/li>
    15.         select<\/span> * <\/span>from<\/span> <\/span>user<\/span> <\/span>where<\/span> id = #{id,jdbcType=<\/span>INTEGER<\/span>}  <\/span><\/span><\/li>
    16.     <\/select<\/span>>  <\/span><\/span><\/li>
    17.   <\/span><\/li>
    18. <\/mapper>  <\/span><\/li><\/ol><\/div>\n\n\n\n
      Mapper\u63a5\u53e3 MyBatisMapper.java\uff1a<\/p>\n\n\n\n
      <\/div>
      1. package<\/span> com.menglanglang.test.springboot.mapper;  <\/span><\/span><\/li>
      2.   <\/span><\/li>
      3. import<\/span> java.util.List;  <\/span><\/span><\/li>
      4.   <\/span><\/li>
      5. import<\/span> org.apache.ibatis.annotations.Mapper;  <\/span><\/span><\/li>
      6.   <\/span><\/li>
      7. import<\/span> com.menglanglang.test.springboot.entity.UserInfo;  <\/span><\/span><\/li>
      8.   <\/span><\/li>
      9. \/**<\/span> <\/span><\/li>
      10.  * @desc MyBatis Mapper\u7c7b<\/span> <\/span><\/li>
      11.  *<\/span> <\/span><\/li>
      12.  * @author \u5b5f\u90ce\u90ce<\/span> <\/span><\/li>
      13.  * @blog http:\/\/blog.csdn.net\/tzhuwb<\/span> <\/span><\/li>
      14.  * @version 1.0<\/span> <\/span><\/li>
      15.  * @date 2018\u5e749\u670816\u65e5\u4e0b\u53484:56:53<\/span> <\/span><\/li>
      16.  *\/<\/span>  <\/span><\/span><\/li>
      17. @Mapper<\/span>  <\/span><\/span><\/li>
      18. public<\/span> <\/span>interface<\/span> MyBatisMapper {  <\/span><\/span><\/li>
      19.   <\/span><\/li>
      20.     \/**<\/span> <\/span><\/li>
      21.      * \u67e5\u8be2\u7528\u6237\u4fe1\u606f\u5217\u8868<\/span> <\/span><\/li>
      22.      * <\/span> <\/span><\/li>
      23.      * @return \u7528\u6237\u4fe1\u606f\u5217\u8868<\/span> <\/span><\/li>
      24.      *\/<\/span>  <\/span><\/span><\/li>
      25.     List<UserInfo> selectUserList();  <\/span><\/li>
      26.   <\/span><\/li>
      27.     \/**<\/span> <\/span><\/li>
      28.      * \u67e5\u8be2\u6307\u5b9a\u7528\u6237<\/span> <\/span><\/li>
      29.      * <\/span> <\/span><\/li>
      30.      * @param id<\/span> <\/span><\/li>
      31.      *            \u7528\u6237ID<\/span> <\/span><\/li>
      32.      * @return \u7528\u6237\u4fe1\u606f<\/span> <\/span><\/li>
      33.      *\/<\/span>  <\/span><\/span><\/li>
      34.     UserInfo selectUser(int<\/span> id);  <\/span><\/span><\/li>
      35.   <\/span><\/li>
      36. }  <\/span><\/li><\/ol><\/div>\n\n\n\n
        \u670d\u52a1\u7c7b MyBatisService.java\uff1a<\/p>\n\n\n\n
        <\/div>
        1. package<\/span> com.menglanglang.test.springboot.service;  <\/span><\/span><\/li>
        2.   <\/span><\/li>
        3. import<\/span> java.util.List;  <\/span><\/span><\/li>
        4.   <\/span><\/li>
        5. import<\/span> org.springframework.beans.factory.annotation.Autowired;  <\/span><\/span><\/li>
        6. import<\/span> org.springframework.stereotype.Service;  <\/span><\/span><\/li>
        7.   <\/span><\/li>
        8. import<\/span> com.menglanglang.test.springboot.entity.UserInfo;  <\/span><\/span><\/li>
        9. import<\/span> com.menglanglang.test.springboot.mapper.MyBatisMapper;  <\/span><\/span><\/li>
        10.   <\/span><\/li>
        11. \/**<\/span> <\/span><\/li>
        12.  * @desc MyBatis\u670d\u52a1\u63a5\u53e3\u7c7b<\/span> <\/span><\/li>
        13.  *<\/span> <\/span><\/li>
        14.  * @author \u5b5f\u90ce\u90ce<\/span> <\/span><\/li>
        15.  * @blog http:\/\/blog.csdn.net\/tzhuwb<\/span> <\/span><\/li>
        16.  * @version 1.0<\/span> <\/span><\/li>
        17.  * @date 2018\u5e749\u670816\u65e5\u4e0b\u53484:56:53<\/span> <\/span><\/li>
        18.  *\/<\/span>  <\/span><\/span><\/li>
        19. @Service<\/span>  <\/span><\/span><\/li>
        20. public<\/span> <\/span>class<\/span> MyBatisService {  <\/span><\/span><\/li>
        21.   <\/span><\/li>
        22.     @Autowired<\/span>  <\/span><\/span><\/li>
        23.     private<\/span> MyBatisMapper myBatisMapper;  <\/span><\/span><\/li>
        24.   <\/span><\/li>
        25.     \/**<\/span> <\/span><\/li>
        26.      * \u67e5\u8be2\u7528\u6237\u4fe1\u606f\u5217\u8868<\/span> <\/span><\/li>
        27.      * <\/span> <\/span><\/li>
        28.      * @return \u7528\u6237\u4fe1\u606f\u5217\u8868<\/span> <\/span><\/li>
        29.      *\/<\/span>  <\/span><\/span><\/li>
        30.     public<\/span> List<UserInfo> getUserList() {  <\/span><\/span><\/li>
        31.         return<\/span> myBatisMapper.selectUserList();  <\/span><\/span><\/li>
        32.     }  <\/span><\/li>
        33.   <\/span><\/li>
        34.     \/**<\/span> <\/span><\/li>
        35.      * \u67e5\u8be2\u6307\u5b9a\u7528\u6237<\/span> <\/span><\/li>
        36.      * <\/span> <\/span><\/li>
        37.      * @param id<\/span> <\/span><\/li>
        38.      *            \u7528\u6237ID<\/span> <\/span><\/li>
        39.      * @return \u7528\u6237\u4fe1\u606f<\/span> <\/span><\/li>
        40.      *\/<\/span>  <\/span><\/span><\/li>
        41.     public<\/span> UserInfo getUser(<\/span>int<\/span> id) {  <\/span><\/span><\/li>
        42.         return<\/span> myBatisMapper.selectUser(id);  <\/span><\/span><\/li>
        43.     }  <\/span><\/li>
        44.   <\/span><\/li>
        45. }  <\/span><\/li><\/ol><\/div>\n\n\n\n
          \u6d4b\u8bd5\u7c7b MyBatisController.java\uff1a<\/p>\n\n\n\n
          <\/div>
          1. package<\/span> com.menglanglang.test.springboot.controller;  <\/span><\/span><\/li>
          2.   <\/span><\/li>
          3. import<\/span> java.util.List;  <\/span><\/span><\/li>
          4.   <\/span><\/li>
          5. import<\/span> org.springframework.beans.factory.annotation.Autowired;  <\/span><\/span><\/li>
          6. import<\/span> org.springframework.web.bind.annotation.RequestMapping;  <\/span><\/span><\/li>
          7. import<\/span> org.springframework.web.bind.annotation.RestController;  <\/span><\/span><\/li>
          8.   <\/span><\/li>
          9. import<\/span> com.menglanglang.test.springboot.entity.UserInfo;  <\/span><\/span><\/li>
          10. import<\/span> com.menglanglang.test.springboot.service.MyBatisService;  <\/span><\/span><\/li>
          11.   <\/span><\/li>
          12. \/**<\/span> <\/span><\/li>
          13.  * @desc MyBatis\u6d4b\u8bd5\u63a7\u5236\u7c7b<\/span> <\/span><\/li>
          14.  *<\/span> <\/span><\/li>
          15.  * @author \u5b5f\u90ce\u90ce<\/span> <\/span><\/li>
          16.  * @blog http:\/\/blog.csdn.net\/tzhuwb<\/span> <\/span><\/li>
          17.  * @version 1.0<\/span> <\/span><\/li>
          18.  * @date 2018\u5e749\u670816\u65e5\u4e0b\u53484:54:58<\/span> <\/span><\/li>
          19.  *\/<\/span>  <\/span><\/span><\/li>
          20. @RestController<\/span>  <\/span><\/span><\/li>
          21. @RequestMapping<\/span>(<\/span>\"\/mybatis\"<\/span>)  <\/span><\/span><\/li>
          22. public<\/span> <\/span>class<\/span> MyBatisController {  <\/span><\/span><\/li>
          23.   <\/span><\/li>
          24.     @Autowired<\/span>  <\/span><\/span><\/li>
          25.     private<\/span> MyBatisService myBatisService;  <\/span><\/span><\/li>
          26.   <\/span><\/li>
          27.     @RequestMapping<\/span>(<\/span>\"\/getUsers\"<\/span>)  <\/span><\/span><\/li>
          28.     public<\/span> List<UserInfo> getUsers() {  <\/span><\/span><\/li>
          29.         List<UserInfo> list = myBatisService.getUserList();  <\/span><\/li>
          30.         return<\/span> list;  <\/span><\/span><\/li>
          31.     }  <\/span><\/li>
          32.   <\/span><\/li>
          33.     @RequestMapping<\/span>(<\/span>\"\/getUser\"<\/span>)  <\/span><\/span><\/li>
          34.     public<\/span> UserInfo getUser() {  <\/span><\/span><\/li>
          35.         UserInfo user = myBatisService.getUser(2<\/span>);  <\/span><\/span><\/li>
          36.         return<\/span> user;  <\/span><\/span><\/li>
          37.     }  <\/span><\/li>
          38.   <\/span><\/li>
          39. }  <\/span><\/li><\/ol><\/div>\n\n\n\n
            \u516d\u3001\u542f\u52a8\u9879\u76ee\u5e76\u6d4b\u8bd5<\/h3>\n\n\n\n
            \u542f\u52a8\u9879\u76ee\uff0c\u6d4f\u89c8\u5668\u8bbf\u95ee http:\/\/localhost:8080\/mybatis\/getUser \u548c http:\/\/localhost:8080\/mybatis\/getUsers \u6d4b\u8bd5\u7ed3\u679c\u5982\u4e0b\uff1a<\/p>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            \"\"<\/figure>\n\n\n\n
            \u200b\u539f\u6587\u94fe\u63a5\uff1ahttps:\/\/blog.csdn.net\/tzhuwb\/article\/details\/82725788<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
            \u57fa\u4e8e\u4e0a\u7bc7\u6587\u7ae0\uff0c\u8fd9\u7bc7\u4e3b\u8981\u8bf4\u4e0b\u5982\u4f55\u96c6\u6210 MyBatis\uff0c\u8fd9\u6837\u6d4b\u8bd5\u65f6\u4e5f\u4e0d\u7528\u5728\u50cf JdbcTemplate  […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[707],"tags":[608,186,650,708,183,332],"class_list":["post-3774","post","type-post","status-publish","format-standard","hentry","category-springboot","tag-mybatis","tag-mysql","tag-spring","tag-springboot","tag-183","tag-332"],"_links":{"self":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/3774","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3774"}],"version-history":[{"count":3,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/3774\/revisions"}],"predecessor-version":[{"id":4365,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=\/wp\/v2\/posts\/3774\/revisions\/4365"}],"wp:attachment":[{"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3774"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3774"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.menglanglang.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3774"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}