{"id":4395,"date":"2019-02-15T08:59:51","date_gmt":"2019-02-15T00:59:51","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/index.php\/spring-boot\/spring-boot%e5%ae%9e%e6%88%98%ef%bc%9a%e6%95%b4%e5%90%88mybatis%e8%bf%9e%e6%8e%a5%e6%95%b0%e6%8d%ae%e5%ba%93\/"},"modified":"2019-02-15T08:59:51","modified_gmt":"2019-02-15T00:59:51","slug":"spring-boot%e5%ae%9e%e6%88%98%ef%bc%9a%e6%95%b4%e5%90%88mybatis%e8%bf%9e%e6%8e%a5%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/spring-boot\/spring-boot%e5%ae%9e%e6%88%98%ef%bc%9a%e6%95%b4%e5%90%88mybatis%e8%bf%9e%e6%8e%a5%e6%95%b0%e6%8d%ae%e5%ba%93\/","title":{"rendered":"Spring Boot\u5b9e\u6218\uff1a\u6574\u5408MyBatis\u8fde\u63a5\u6570\u636e\u5e93"},"content":{"rendered":"
\n
\n

\u5982\u679c\u6559\u7a0b\u4e2d\u4ee3\u7801\u4e0d\u4fbf\u4e8e\u9605\u8bfb\uff0c\u8bf7\u4f7f\u7528\u7535\u8111\u67e5\u770b\u6216\u70b9\u51fb\u9605\u8bfb\u539f\u6587\u3002<\/span><\/h1>\n<\/blockquote>\n

0. \u5f00\u53d1\u73af\u5883<\/span><\/h1>\n
    \n
  • \n

    IDE\uff1aIntelliJ IDEA 2017.1 x64<\/span><\/span><\/p>\n<\/li>\n

  • \n

    jdk\uff1a1.8.0_91<\/span><\/span><\/p>\n<\/li>\n

  • \n

    Spring Boot\uff1a2.1.1.RELEASE<\/span><\/span><\/p>\n<\/li>\n

  • \n

    Maven\uff1a3.3.9<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n

    <\/span><\/p>\n

    1. \u5f15\u5165\u4f9d\u8d56<\/span><\/h1>\n
      <<\/span>dependency<\/span>><\/span><\/span>    <<\/span>groupId<\/span>><\/span>org.mybatis.spring.boot<\/<\/span>groupId<\/span>><\/span><\/span>    <<\/span>artifactId<\/span>><\/span>mybatis-spring-boot-starter<\/<\/span>artifactId<\/span>><\/span><\/span>    <<\/span>version<\/span>><\/span>1.3.2<\/<\/span>version<\/span>><\/span><\/span>  <\/<\/span>dependency<\/span>><\/span><\/span>    <<\/span>dependency<\/span>><\/span><\/span>    <\/span><<\/span>groupId<\/span>><\/span>mysql<\/<\/span>groupId<\/span>><\/span><\/span>    <\/span><<\/span>artifactId<\/span>><\/span>mysql-connector-java<\/<\/span>artifactId<\/span>><\/span><\/span>    <\/span><<\/span>version<\/span>><\/span>8.0.15<\/<\/span>version<\/span>><\/span><\/span>    <\/span><<\/span>scope<\/span>><\/span>runtime<\/<\/span>scope<\/span>><\/span><\/span>  <\/<\/span>dependency<\/span>><\/span><\/span><\/pre>\n
    \u8fd9\u91cc\uff0c\u5982\u679c\u4f7f\u7528\u7684 MySQL \u662f 8.X\u7248\u672c\u7684\u8bdd\uff0cmysql-connector-java \u7248\u672c\u5fc5\u987b\u662f 8.0\u4ee5\u4e0a\uff0c\u5426\u5219\u4f1a\u62a5\u9519\uff1a<\/span><\/span><\/p>\n
      java<\/span>.sql<\/span>.SQLException<\/span>: Unable<\/span> to<\/span> load<\/span> authentication<\/span> plugin<\/span> 'caching_sha2_password'<\/span><\/span><\/pre>\n
    <\/span><\/p>\n
    2. \u5f15\u5165\u6570\u636e\u6e90<\/span><\/h1>\n
    application.yml \u589e\u52a0\u5982\u4e0b\u914d\u7f6e\u4fe1\u606f<\/span><\/span><\/p>\n
        spring:<\/span>   datasource:<\/span>    url: jdbc:mysql:\/\/127.0.0.1:3306\/test?serverTimezone=GMT%2B8<\/span>    username: root<\/span>    password: root<\/span>    driver-class-name: com.mysql.cj.jdbc.Driver<\/span><\/pre>\n
    \u8fd9\u91cc\uff0c\u5982\u679c\u4f7f\u7528\u7684 mysql-connector-java \u662f5.X\u7248\u672c\u7684\u8bdd\uff0cdriver-class-name \u53ef\u4ee5\u76f4\u63a5\u7701\u7565\u4f7f\u7528\u9ed8\u8ba4\uff0c\u6216\u8005\u914d\u7f6e\u4e3a com.mysql.jdbc.Driver<\/span><\/span><\/span><\/span><\/p>\n
    \u5230\u8fd9\u91cc\uff0cSpring Boot\u5c31\u53ef\u4ee5\u8bbf\u95ee\u6570\u636e\u5e93\u4e86\uff0c\u6211\u4eec\u6765\u505a\u4e0b\u6d4b\u8bd5\u3002<\/span><\/span><\/p>\n
    <\/span><\/p>\n
    3. \u6d4b\u8bd5<\/span><\/h1>\n
    3.1 \u65b0\u5efa\u6570\u636e\u5e93\u8868<\/span><\/h2>\n
        CREATE<\/span> SCHEMA `test` ;<\/span>    CREATE<\/span> TABLE<\/span> `test`.`test` (<\/span>   `id` INT<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT,<\/span>   `name` VARCHAR<\/span>(45<\/span>) NOT<\/span> NULL<\/span>,<\/span>   PRIMARY KEY (`id`));<\/span>    INSERT<\/span> INTO<\/span> `test`.`test` (`name`) VALUES<\/span> ('\u5f20\u4e09'<\/span>);<\/span>  INSERT<\/span> INTO<\/span> `test`.`test` (`name`) VALUES<\/span> ('\u674e\u56db'<\/span>);<\/span>  INSERT<\/span> INTO<\/span> `test`.`test` (`name`) VALUES<\/span> ('\u738b\u4e94'<\/span>);<\/span>  INSERT<\/span> INTO<\/span> `test`.`test` (`name`) VALUES<\/span> ('\u5468\u516d'<\/span>);<\/span><\/pre>\n
    3.2 \u521b\u5efa\u5b9e\u4f53<\/span><\/h2>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>;<\/span>    public<\/span> class<\/span> TestModel<\/span> {<\/span>      private<\/span> int<\/span> id<\/span>;<\/span>    private<\/span> String<\/span> name<\/span>;<\/span>      public<\/span> int<\/span> getId<\/span>() {<\/span>      return<\/span> id<\/span>;<\/span>    }<\/span>      public<\/span> void<\/span> setId<\/span>(int<\/span> id<\/span>) {<\/span>      this<\/span>.id<\/span> =<\/span> id<\/span>;<\/span>    }<\/span>      public<\/span> String<\/span> getName<\/span>() {<\/span>      return<\/span> name<\/span>;<\/span>    }<\/span>      public<\/span> void<\/span> setName<\/span>(String<\/span> name<\/span>) {<\/span>      this<\/span>.name<\/span> =<\/span> name<\/span>;<\/span>    }<\/span>  }<\/span><\/pre>\n
    3.3 DAO\u5c42<\/span><\/h2>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.dao<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestModel<\/span>;<\/span>  import<\/span> org<\/span>.apache<\/span>.ibatis<\/span>.annotations<\/span>.Insert<\/span>;<\/span>  import<\/span> org<\/span>.apache<\/span>.ibatis<\/span>.annotations<\/span>.Mapper<\/span>;<\/span>  import<\/span> org<\/span>.apache<\/span>.ibatis<\/span>.annotations<\/span>.Param<\/span>;<\/span>  import<\/span> org<\/span>.apache<\/span>.ibatis<\/span>.annotations<\/span>.Select<\/span>;<\/span>    import<\/span> java<\/span>.util<\/span>.List<\/span>;<\/span>    @Mapper<\/span><\/span>  public<\/span> interface<\/span> TestMapper<\/span> {<\/span>      @Select<\/span>(\"select id,name from test\"<\/span>)<\/span>    List<\/span><<\/span>TestModel<\/span>><\/span> select<\/span>();<\/span>      @Insert<\/span>(\"insert into test(name) values(#{name})\"<\/span>)<\/span>    int<\/span> insert<\/span>(@Param<\/span>(\"name\"<\/span>) String<\/span> name<\/span>);<\/span>  }<\/span><\/pre>\n
    3.4 Service\u5c42<\/span><\/h2>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.service<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.dao<\/span>.TestMapper<\/span>;<\/span>  import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestModel<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.beans<\/span>.factory<\/span>.annotation<\/span>.Autowired<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.stereotype<\/span>.Service<\/span>;<\/span>    import<\/span> java<\/span>.util<\/span>.List<\/span>;<\/span>    @Service<\/span><\/span>  public<\/span> class<\/span> MySQLTestService<\/span> {<\/span>      @Autowired<\/span><\/span>    private<\/span> TestMapper<\/span> testMapper<\/span>; \/\/\u8fd9\u91cc\u4f1a\u6709\u62a5\u9519\uff0c\u4e0d\u7528\u7ba1<\/span><\/span>      public<\/span> List<\/span><<\/span>TestModel<\/span>><\/span> select<\/span>() {<\/span>      return<\/span> testMapper<\/span>.select<\/span>();<\/span>    }<\/span>      public<\/span> int<\/span> insert<\/span>(String<\/span> name<\/span>) {<\/span>      return<\/span> testMapper<\/span>.insert<\/span>(name<\/span>);<\/span>    }<\/span>  }<\/span><\/pre>\n
    3.5 Controller\u5c42<\/span><\/h2>\n
      package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.controller<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestModel<\/span>;<\/span>  import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.service<\/span>.MySQLTestService<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.beans<\/span>.factory<\/span>.annotation<\/span>.Autowired<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.context<\/span>.annotation<\/span>.Scope<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.PostMapping<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RequestMapping<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RequestParam<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RestController<\/span>;<\/span>    import<\/span> java<\/span>.util<\/span>.List<\/span>;<\/span>    @RestController<\/span><\/span>  @Scope<\/span>(\"prototype\"<\/span>)<\/span>  @RequestMapping<\/span>(\"\/mysql\/test\"<\/span>)<\/span>  public<\/span> class<\/span> MySQLTestController<\/span> {<\/span>      @Autowired<\/span><\/span>    private<\/span> MySQLTestService<\/span> mySQLTestService<\/span>;<\/span>      @PostMapping<\/span>(value<\/span> =<\/span> \"\/select\"<\/span>)<\/span>    public<\/span> List<\/span><<\/span>TestModel<\/span>><\/span> select<\/span>() throws<\/span> Exception<\/span> {<\/span>      return<\/span> mySQLTestService<\/span>.select<\/span>();<\/span>    }<\/span>      @PostMapping<\/span>(value<\/span> =<\/span> \"\/insert\"<\/span>)<\/span>    public<\/span> int<\/span> insert<\/span>(@RequestParam<\/span>(value<\/span> =<\/span> \"name\"<\/span>) String<\/span> name<\/span>) throws<\/span> Exception<\/span> {<\/span>      return<\/span> mySQLTestService<\/span>.insert<\/span>(name<\/span>);<\/span>    }<\/span>  }<\/span><\/pre>\n
    3.6 \u6d4b\u8bd5<\/span><\/h2>\n
    \u4f7f\u7528Postman\u8fdb\u884c\u6d4b\u8bd5\uff0c\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b<\/span><\/span><\/p>\n
    3.6.1 select<\/span><\/h3>\n
    3.6.2 insert<\/span><\/p>\n
    Postman\u63a5\u6536\u5230\u8f93\u51fa\u4e3a1\uff0c\u8868\u793a\u6210\u529f\uff0c\u6211\u4eec\u53bb\u67e5\u4e0b\u6570\u636e\u5e93<\/span><\/p>\n
    \u6570\u636e\u6210\u529f\u63d2\u5165\u3002<\/span><\/span><\/p>\n
    <\/span><\/p>\n
    4. MyBatis\u6620\u5c04\u6587\u4ef6<\/span><\/h1>\n
    \u4ee5\u4e0a\uff0c\u6211\u4eec\u8bbf\u95ee\u6570\u636e\u5e93\u65f6\uff0cSQL\u8bed\u53e5\u8fd8\u662f\u5199\u6b7b\u5728\u4ee3\u7801\u91cc\u9762\uff0c\u5904\u7406\u8d77\u6765\u5e76\u6ca1\u6709\u5f88\u65b9\u4fbf\u3002\u901a\u5e38\uff0c\u6211\u4eec\u628aSQL\u8bed\u53e5\u4e0e\u4ee3\u7801\u5206\u79bb\uff0c\u4f7f\u7528MyBatis\u6620\u5c04\u6587\u4ef6\u65b9\u5f0f\u6765\u8bbf\u95ee\u6570\u636e\u5e93\u3002<\/span><\/span><\/p>\n
    4.1 MyBatis\u914d\u7f6e<\/span><\/h2>\n
    \u6211\u4eec\u5728resources\u6587\u4ef6\u5939\u4e0b\u65b0\u5efamapper\u6587\u4ef6\u5939\uff0c\u7528\u4e8e\u5b58\u653eMyBatis\u6620\u5c04\u6587\u4ef6<\/span><\/span><\/p>\n
    <\/span><\/span><\/p>\n
    application.yml \u589e\u52a0MyBatis\u914d\u7f6e\u4fe1\u606f<\/span><\/span><\/p>\n
        mybatis:<\/span>   mapper-locations: classpath:mapper\/*.xml #\u5bf9\u5e94mapper\u6620\u5c04xml\u6587\u4ef6\u6240\u5728\u8def\u5f84<\/span>   type-aliases-package: cn.wbnull.springbootdemo.model #\u5bf9\u5e94\u5b9e\u4f53\u7c7b\u8def\u5f84<\/span><\/pre>\n
    \u5b8c\u6574\u914d\u7f6e\u5982\u4e0b\uff0c\u6ce8\u610fspring\u4e0emybatis\u90fd\u662f\u6839\u8282\u70b9<\/span><\/span><\/p>\n
        spring:<\/span>   datasource:<\/span>    url: jdbc:mysql:\/\/127.0.0.1:3306\/test?serverTimezone=GMT%2B8<\/span>    username: root<\/span>    password: root<\/span>    driver-class-name: com.mysql.cj.jdbc.Driver<\/span>  #<\/span>  mybatis:<\/span>   mapper-locations: classpath:mapper\/*.xml #\u5bf9\u5e94mapper\u6620\u5c04xml\u6587\u4ef6\u6240\u5728\u8def\u5f84<\/span>   type-aliases-package: cn.wbnull.springbootdemo.model #\u5bf9\u5e94\u5b9e\u4f53\u7c7b\u8def\u5f84<\/span><\/pre>\n
    4.2 DAO\u5c42<\/span><\/h2>\n
    \u6211\u4eec\u521b\u5efa\u4e00\u4e2a\u65b0\u7684DAO\u7c7b<\/span><\/span><\/p>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.dao<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestModel<\/span>;<\/span>    import<\/span> java<\/span>.util<\/span>.List<\/span>;<\/span>    public<\/span> interface<\/span> TestMapperV2<\/span> {<\/span>      List<\/span><<\/span>TestModel<\/span>><\/span> select<\/span>();<\/span>      int<\/span> insert<\/span>(TestModel<\/span> testModel<\/span>);<\/span>  }<\/span><\/pre>\n
    4.3 \u521b\u5efaMyBatis\u6620\u5c04\u6587\u4ef6<\/span><\/h2>\n
    resources\/mapper\u4e0b\u65b0\u5efa\u6620\u5c04\u6587\u4ef6 <\/span>TestMapper.xml<\/strong><\/span><\/span><\/p>\n
        <?xml<\/span> version=\"1.0\" encoding=\"UTF-8\" ?><\/span><\/span>  <!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\" ><\/span><\/span>  <<\/span>mapper<\/span> namespace<\/span>=\"cn.wbnull.springbootdemo.dao.TestMapperV2\"<\/span>><\/span><\/span>    <<\/span>resultMap<\/span> id<\/span>=\"BaseResultMap\"<\/span> type<\/span>=\"cn.wbnull.springbootdemo.model.TestModel\"<\/span>><\/span><\/span>      <<\/span>id<\/span> column<\/span>=\"id\"<\/span> property<\/span>=\"id\"<\/span> jdbcType<\/span>=\"INTEGER\"<\/span>\/><\/span><\/span>      <<\/span>result<\/span> column<\/span>=\"name\"<\/span> property<\/span>=\"name\"<\/span> jdbcType<\/span>=\"VARCHAR\"<\/span>\/><\/span><\/span>    <\/<\/span>resultMap<\/span>><\/span><\/span>    <<\/span>sql<\/span> id<\/span>=\"Base_Column_List\"<\/span>><\/span><\/span>      id, name<\/span>    <\/<\/span>sql<\/span>><\/span><\/span>    <<\/span>select<\/span> id<\/span>=\"select\"<\/span> resultMap<\/span>=\"BaseResultMap\"<\/span>><\/span><\/span>      select<\/span>      <<\/span>include<\/span> refid<\/span>=\"Base_Column_List\"<\/span>\/><\/span><\/span>      from test<\/span>    <\/<\/span>select<\/span>><\/span><\/span>    <<\/span>insert<\/span> id<\/span>=\"insert\"<\/span> parameterType<\/span>=\"cn.wbnull.springbootdemo.model.TestModel\"<\/span>><\/span><\/span>      insert into test (id, name<\/span>      )<\/span>      values (#{id,jdbcType=INTEGER}, #{name,jdbcType=VARCHAR}<\/span>      )<\/span>    <\/<\/span>insert<\/span>><\/span><\/span>  <\/<\/span>mapper<\/span>><\/span><\/span><\/pre>\n
    \u8fd9\u91cc\u7740\u91cd\u6ce8\u610f\u8fd9\u51e0\u70b9<\/span><\/span><\/p>\n
    \n
    1\u3001<\/span><<\/span>mapper namespace=\"cn.wbnull.springbootdemo.dao.TestMapperV2\"> namespace \u4e00\u5b9a\u8981\u5bf9\u5e94\u81ea\u5df1dao\u5305\u6240\u5728\u7684\u5305\u8def\u5f84\uff0c\u5bf9\u5e94\u6211\u4eec\u9700\u8981\u5339\u914d\u7684dao\u5c42\u7c7b<\/span><\/span><\/p>\n
    2\u3001<\/span><<\/span>resultMap id=\"BaseResultMap\" type=\"cn.wbnull.springbootdemo.model.TestModel\"> type \u4e00\u5b9a\u8981\u5bf9\u5e94\u6211\u4eec\u9700\u8981\u5339\u914d\u7684\u5b9e\u4f53\u7c7b<\/span><\/span><\/p>\n
    3\u3001  <\/span><<\/span>id column=\"id\" property=\"id\" jdbcType=\"INTEGER\"\/> <\/span> <\/span><\/span><\/p>\n
    \t <\/span><<\/span>result column=\"name\" property=\"name\" jdbcType=\"VARCHAR\"\/><\/span><\/span><\/p>\n
    \u5bf9\u5e94\u6570\u636e\u5e93\u8868\u7684\u5b57\u6bb5<\/span><\/span><\/p>\n
    4\u3001<\/span><<\/span>select id=\"select\" resultMap=\"BaseResultMap\"><\/span><\/span><\/p>\n
          select  <\/span><<\/span>include refid=\"Base_Column_List\"\/>  from test<\/span><\/span><\/p>\n
      <\/span><<\/span>\/select><\/span><\/span><\/p>\n
    <<\/span>select> \u8868\u793a\u8fd9\u662f\u4e00\u6761\u67e5\u8be2\u8bed\u53e5\uff0c id=\"select\"\u4e00\u5b9a\u8981\u4e0edao\u5c42\u9700\u8981\u5339\u914d\u7684\u65b9\u6cd5\u540d\u4e00\u81f4\uff0cresultMap \u8868\u793a\u5bf9\u5e94\u7684\u8fd4\u56de\u503c\u7c7b\u578b<\/span><\/span><\/p>\n
    5\u3001<\/span><<\/span>insert id=\"insert\" parameterType=\"cn.wbnull.springbootdemo.model.TestModel\"> parameterType\u8868\u793a\u5bf9\u5e94\u7684\u8f93\u5165\u53c2\u6570\u7c7b\u578b<\/span><\/span><\/p>\n<\/blockquote>\n
    4.4 Service\u5c42<\/span><\/h2>\n
    \u521b\u5efa\u4e00\u4e2a\u65b0\u7684Service\u7c7b<\/span><\/span><\/p>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.service<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.dao<\/span>.TestMapperV2<\/span>;<\/span>  import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestModel<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.beans<\/span>.factory<\/span>.annotation<\/span>.Autowired<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.stereotype<\/span>.Service<\/span>;<\/span>    import<\/span> java<\/span>.util<\/span>.List<\/span>;<\/span>    @Service<\/span><\/span>  public<\/span> class<\/span> MySQLTestServiceV2<\/span> {<\/span>      @Autowired<\/span><\/span>    private<\/span> TestMapperV2<\/span> testMapperV2<\/span>; \/\/\u8fd9\u91cc\u4f1a\u6709\u62a5\u9519\uff0c\u4e0d\u7528\u7ba1<\/span><\/span>      public<\/span> List<\/span><<\/span>TestModel<\/span>><\/span> select<\/span>() {<\/span>      return<\/span> testMapperV2<\/span>.select<\/span>();<\/span>    }<\/span>      public<\/span> int<\/span> insert<\/span>(int<\/span> id<\/span>, String<\/span> name<\/span>) {<\/span>      TestModel<\/span> testModel<\/span> =<\/span> new<\/span> TestModel<\/span>();<\/span>      testModel<\/span>.setId<\/span>(id<\/span>);<\/span>      testModel<\/span>.setName<\/span>(name<\/span>);<\/span>        return<\/span> testMapperV2<\/span>.insert<\/span>(testModel<\/span>);<\/span>    }<\/span>  }<\/span><\/pre>\n
    4.5 Controller\u5c42<\/span><\/h2>\n
    \u521b\u5efa\u4e00\u4e2a\u65b0\u7684Controller\u7c7b<\/span><\/span><\/p>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.controller<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestModel<\/span>;<\/span>  import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.service<\/span>.MySQLTestServiceV2<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.beans<\/span>.factory<\/span>.annotation<\/span>.Autowired<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.context<\/span>.annotation<\/span>.Scope<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.PostMapping<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RequestMapping<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RequestParam<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RestController<\/span>;<\/span>    import<\/span> java<\/span>.util<\/span>.List<\/span>;<\/span>    @RestController<\/span><\/span>  @Scope<\/span>(\"prototype\"<\/span>)<\/span>  @RequestMapping<\/span>(\"\/mysql\/test\"<\/span>)<\/span>  public<\/span> class<\/span> MySQLTestControllerV2<\/span> {<\/span>      @Autowired<\/span><\/span>    private<\/span> MySQLTestServiceV2<\/span> mySQLTestServiceV2<\/span>;<\/span>      @PostMapping<\/span>(value<\/span> =<\/span> \"\/selectV2\"<\/span>)<\/span>    public<\/span> List<\/span><<\/span>TestModel<\/span>><\/span> select<\/span>() throws<\/span> Exception<\/span> {<\/span>      return<\/span> mySQLTestServiceV2<\/span>.select<\/span>();<\/span>    }<\/span>      @PostMapping<\/span>(value<\/span> =<\/span> \"\/insertV2\"<\/span>)<\/span>    public<\/span> int<\/span> insert<\/span>(@RequestParam<\/span>(value<\/span> =<\/span> \"id\"<\/span>) int<\/span> id<\/span>,<\/span>             @RequestParam<\/span>(value<\/span> =<\/span> \"name\"<\/span>) String<\/span> name<\/span>) throws<\/span> Exception<\/span> {<\/span>      return<\/span> mySQLTestServiceV2<\/span>.insert<\/span>(id<\/span>, name<\/span>);<\/span>    }<\/span>  }<\/span><\/pre>\n
    4.6 \u9879\u76ee\u542f\u52a8\u7c7b<\/span><\/h2>\n
    \u589e\u52a0@MapperScan(\"cn.wbnull.springbootdemo.dao\")\uff0c\u5bf9\u5e94DAO\u5c42\u7684\u5305\u540d<\/span><\/span><\/p>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>;<\/span>    import<\/span> org<\/span>.mybatis<\/span>.spring<\/span>.annotation<\/span>.MapperScan<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.boot<\/span>.SpringApplication<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.boot<\/span>.autoconfigure<\/span>.SpringBootApplication<\/span>;<\/span>    @SpringBootApplication<\/span><\/span>  @MapperScan<\/span>(\"cn.wbnull.springbootdemo.dao\"<\/span>)<\/span>  public<\/span> class<\/span> SpringBootDemoApplication<\/span> {<\/span>      <\/span>public<\/span> static<\/span> void<\/span> main<\/span>(String<\/span>[] args<\/span>) {<\/span>    <\/span>  <\/span>SpringApplication<\/span>.run<\/span>(SpringBootDemoApplication<\/span>.class<\/span>, args<\/span>);<\/span>    <\/span>}<\/span>  }<\/span><\/pre>\n
    4.7 \u6d4b\u8bd5<\/span><\/h2>\n
    4.7.1 select<\/span><\/h3>\n
    4.7.2 insert<\/span><\/p>\n
    Postman\u63a5\u6536\u5230\u8f93\u51fa\u4e3a1\uff0c\u8868\u793a\u6210\u529f\uff0c\u6211\u4eec\u53bb\u67e5\u4e0b\u6570\u636e\u5e93<\/span><\/p>\n
    \u6570\u636e\u6210\u529f\u63d2\u5165<\/span><\/p>\n
    <\/span><\/p>\n
    \u622a\u81f3\u8fd9\u91cc\uff0cSpring Boot\u5df2\u6210\u529f\u6574\u5408MyBatis\u5e76\u8fde\u63a5\u4e0a\u4e86\u6570\u636e\u5e93\uff0c\u4e14\u6d4b\u8bd5\u6b63\u5e38\u3002<\/span><\/span><\/p>\n
    <\/span><\/p>\n
    \u4f46\u6211\u4eec\u5b9e\u9645\u5f00\u53d1\u8fc7\u7a0b\u4e2d\uff0c\u5982\u679c\u5b58\u5728\u5927\u91cf\u6570\u636e\u5e93\u8868\uff0c\u90a3\u6211\u4eec\u5c31\u9700\u8981\u521b\u5efa\u5927\u91cf\u7684\u5b9e\u4f53\u7c7b\u3001DAO\u5c42\u3001\u6620\u5c04\u6587\u4ef6\uff0c\u5de5\u4f5c\u91cf\u8f83\u5927\u3002\u6211\u4eec\u4f7f\u7528mybatis generator\u6765\u81ea\u52a8\u751f\u6210\u4ee3\u7801\u3002<\/span><\/span><\/p>\n
    <\/span><\/p>\n
    5. Generator<\/span><\/h1>\n
    5.1 \u65b0\u5efa\u6570\u636e\u5e93\u8868<\/span><\/h2>\n
    \u6211\u4eec\u5148\u65b0\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u8868\uff0c\u4fbf\u4e8e\u4e00\u4f1a\u81ea\u52a8\u751f\u6210\u4ee3\u7801\u4f7f\u7528<\/span><\/span><\/p>\n
        CREATE<\/span> TABLE<\/span> `test`.`testv2` (<\/span>   `id` INT<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT,<\/span>   `username` VARCHAR<\/span>(45<\/span>) NOT<\/span> NULL<\/span>,<\/span>   `password` VARCHAR<\/span>(45<\/span>) NOT<\/span> NULL<\/span>,<\/span>   PRIMARY KEY (`id`));<\/span><\/pre>\n
    5.2 Generator\u914d\u7f6e\u6587\u4ef6<\/span><\/h2>\n
    \u5728resources\u6587\u4ef6\u5939\u4e0b\u65b0\u5efagenerator\u6587\u4ef6\u5939\uff0cgenerator\u4e0b<\/span>\u65b0\u5efageneratorConfig.xml<\/span><\/span><\/p>\n
        <?xml<\/span> version=\"1.0\" encoding=\"UTF-8\"?><\/span><\/span>  <!DOCTYPE generatorConfiguration<\/span><\/span>      PUBLIC \"-\/\/mybatis.org\/\/DTD MyBatis Generator Configuration 1.0\/\/EN\"<\/span><\/span>      \"http:\/\/mybatis.org\/dtd\/mybatis-generator-config_1_0.dtd\"><\/span><\/span>  <<\/span>generatorConfiguration<\/span>><\/span><\/span>    <!--\u6570\u636e\u5e93\u9a71\u52a8\uff0c\u9009\u62e9\u672c\u5730\u786c\u76d8\u4e0a\u7684\u6570\u636e\u5e93\u9a71\u52a8\u5305\uff0c\u5efa\u8bae\u4e0epom.xml\u5f15\u5165\u7684jar\u5305\u7248\u672c\u76f8\u540c--><\/span><\/span>    <<\/span>classPathEntry<\/span><\/span>        location<\/span>=\"D:Program FilesMavenrepositorymysqlmysql-connector-java8.0.15mysql-connector-java-8.0.15.jar\"<\/span>\/><\/span><\/span>    <<\/span>context<\/span> id<\/span>=\"DB2Tables\"<\/span> targetRuntime<\/span>=\"MyBatis3\"<\/span>><\/span><\/span>      <<\/span>commentGenerator<\/span>><\/span><\/span>        <<\/span>property<\/span> name<\/span>=\"suppressDate\"<\/span> value<\/span>=\"true\"<\/span>\/><\/span><\/span>        <!--\u662f\u5426\u53bb\u9664\u81ea\u52a8\u751f\u6210\u7684\u6ce8\u91ca\uff0ctrue\uff1a\u662f false\uff1a\u5426--><\/span><\/span>        <<\/span>property<\/span> name<\/span>=\"suppressAllComments\"<\/span> value<\/span>=\"true\"<\/span>\/><\/span><\/span>      <\/<\/span>commentGenerator<\/span>><\/span><\/span>        <!--\u6570\u636e\u5e93\u9a71\u52a8\u7c7b\u3001\u94fe\u63a5url\u3001\u7528\u6237\u540d\u3001\u5bc6\u7801\uff0c\u4e0eapplication.yml\u914d\u7f6e\u76f8\u540c\u5373\u53ef--><\/span><\/span>      <<\/span>jdbcConnection<\/span> driverClass<\/span>=\"com.mysql.cj.jdbc.Driver\"<\/span><\/span>              connectionURL<\/span>=\"jdbc:mysql:\/\/127.0.0.1:3306\/test?serverTimezone=GMT%2B8\"<\/span><\/span>              userId<\/span>=\"root\"<\/span><\/span>              password<\/span>=\"root\"<\/span>><\/span><\/span>      <\/<\/span>jdbcConnection<\/span>><\/span><\/span>        <<\/span>javaTypeResolver<\/span>><\/span><\/span>        <<\/span>property<\/span> name<\/span>=\"forceBigDecimals\"<\/span> value<\/span>=\"false\"<\/span>\/><\/span><\/span>      <\/<\/span>javaTypeResolver<\/span>><\/span><\/span>        <!--\u751f\u6210\u5b9e\u4f53\u7c7b\u7684\u5305\u540d\u548c\u4f4d\u7f6e--><\/span><\/span>      <<\/span>javaModelGenerator<\/span> targetPackage<\/span>=\"cn.wbnull.springbootdemo.model\"<\/span><\/span>                targetProject<\/span>=\"src\/main\/java\"<\/span>><\/span><\/span>        <<\/span>property<\/span> name<\/span>=\"enableSubPackages\"<\/span> value<\/span>=\"true\"<\/span>\/><\/span><\/span>        <<\/span>property<\/span> name<\/span>=\"trimStrings\"<\/span> value<\/span>=\"true\"<\/span>\/><\/span><\/span>      <\/<\/span>javaModelGenerator<\/span>><\/span><\/span>        <!--\u751f\u6210\u6620\u5c04\u6587\u4ef6\u7684\u5305\u540d\u548c\u4f4d\u7f6e--><\/span><\/span>      <<\/span>sqlMapGenerator<\/span> targetPackage<\/span>=\"mapper\"<\/span><\/span>               targetProject<\/span>=\"src\/main\/resources\"<\/span>><\/span><\/span>        <<\/span>property<\/span> name<\/span>=\"enableSubPackages\"<\/span> value<\/span>=\"true\"<\/span>\/><\/span><\/span>      <\/<\/span>sqlMapGenerator<\/span>><\/span><\/span>        <!--\u751f\u6210DAO\u7684\u5305\u540d\u548c\u4f4d\u7f6e--><\/span><\/span>      <<\/span>javaClientGenerator<\/span> type<\/span>=\"XMLMAPPER\"<\/span><\/span>                 targetPackage<\/span>=\"cn.wbnull.springbootdemo.dao\"<\/span><\/span>                 targetProject<\/span>=\"src\/main\/java\"<\/span>><\/span><\/span>        <<\/span>property<\/span> name<\/span>=\"enableSubPackages\"<\/span> value<\/span>=\"true\"<\/span>\/><\/span><\/span>      <\/<\/span>javaClientGenerator<\/span>><\/span><\/span>        <!--\u9700\u8981\u81ea\u52a8\u751f\u6210\u4ee3\u7801\u7684\u6570\u636e\u5e93\u8868<\/span><\/span>       tableName\u8868\u793a\u6570\u636e\u5e93\u4e2d\u7684\u8868\u540d\u6216\u89c6\u56fe\u540d domainObjectName\u8868\u793a\u5b9e\u4f53\u7c7b\u540d--><\/span><\/span>      <<\/span>table<\/span> tableName<\/span>=\"testv2\"<\/span> domainObjectName<\/span>=\"TestV2\"<\/span><\/span>          enableCountByExample<\/span>=\"false\"<\/span> enableUpdateByExample<\/span>=\"false\"<\/span><\/span>          enableDeleteByExample<\/span>=\"false\"<\/span> enableSelectByExample<\/span>=\"false\"<\/span> selectByExampleQueryId<\/span>=\"false\"<\/span>\/><\/span><\/span>    <\/<\/span>context<\/span>><\/span><\/span>  <\/<\/span>generatorConfiguration<\/span>><\/span><\/span><\/pre>\n
    5.3 \u5f15\u5165\u4f9d\u8d56<\/span><\/h2>\n
        <<\/span>plugin<\/span>><\/span><\/span>    <\/span><<\/span>groupId<\/span>><\/span>org.mybatis.generator<\/<\/span>groupId<\/span>><\/span><\/span>    <\/span><<\/span>artifactId<\/span>><\/span>mybatis-generator-maven-plugin<\/<\/span>artifactId<\/span>><\/span><\/span>    <\/span><<\/span>version<\/span>><\/span>1.3.2<\/<\/span>version<\/span>><\/span><\/span>    <\/span><<\/span>configuration<\/span>><\/span><\/span>    <\/span>  <\/span><<\/span>configurationFile<\/span>><\/span>${basedir}\/src\/main\/resources\/generator\/generatorConfig.xml<\/<\/span>configurationFile<\/span>><\/span><\/span>    <\/span>  <\/span><<\/span>overwrite<\/span>><\/span>true<\/<\/span>overwrite<\/span>><\/span><\/span>    <\/span>  <\/span><<\/span>verbose<\/span>><\/span>true<\/<\/span>verbose<\/span>><\/span><\/span>    <\/span><\/<\/span>configuration<\/span>><\/span><\/span>  <\/<\/span>plugin<\/span>><\/span><\/span><\/pre>\n
    5.4 Generator\u914d\u7f6e<\/span><\/h2>\n
    1\u3001Run --> Edit Configurations...<\/span><\/span><\/p>\n
    <\/span><\/span><\/p>\n
    2\u3001\u589e\u52a0Maven\u914d\u7f6e<\/span><\/span><\/p>\n
    <\/span><\/span><\/p>\n
    3\u3001\u589e\u52a0Generator\u914d\u7f6e (<\/span>mybatis-generator:generate -e<\/strong><\/span>)\uff0cOK<\/span><\/span><\/span><\/p>\n
    <\/span><\/p>\n
    4\u3001\u8fd0\u884c<\/span><\/span><\/p>\n
    <\/span><\/span><\/p>\n
    <\/span><\/span>\u751f\u6210\u4ee3\u7801\u5982\u4e0b\u3002\u8fd9\u91cc\u6211\u4eec\u8fd0\u884c\u6210\u529f\u540e\uff0c\u540c\u4e00\u4e2a\u8868\uff0c\u4e0d\u8981\u8fd0\u884c\u591a\u6b21\uff0c\u5426\u5219mapper\u6620\u5c04\u6587\u4ef6\u4e2d\u4f1a\u751f\u6210\u591a\u6b21\u7684\u4ee3\u7801\u3002<\/span><\/span><\/p>\n
    <\/span><\/span><\/p>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>;<\/span>    public<\/span> class<\/span> TestV2<\/span> {<\/span>    private<\/span> Integer<\/span> id<\/span>;<\/span>      private<\/span> String<\/span> username<\/span>;<\/span>      private<\/span> String<\/span> password<\/span>;<\/span>      public<\/span> Integer<\/span> getId<\/span>() {<\/span>      return<\/span> id<\/span>;<\/span>    }<\/span>      public<\/span> void<\/span> setId<\/span>(Integer<\/span> id<\/span>) {<\/span>      this<\/span>.id<\/span> =<\/span> id<\/span>;<\/span>    }<\/span>      public<\/span> String<\/span> getUsername<\/span>() {<\/span>      return<\/span> username<\/span>;<\/span>    }<\/span>      public<\/span> void<\/span> setUsername<\/span>(String<\/span> username<\/span>) {<\/span>      this<\/span>.username<\/span> =<\/span> username<\/span> ==<\/span> null<\/span> ?<\/span> null<\/span> : username<\/span>.trim<\/span>();<\/span>    }<\/span>      public<\/span> String<\/span> getPassword<\/span>() {<\/span>      return<\/span> password<\/span>;<\/span>    }<\/span>      public<\/span> void<\/span> setPassword<\/span>(String<\/span> password<\/span>) {<\/span>      this<\/span>.password<\/span> =<\/span> password<\/span> ==<\/span> null<\/span> ?<\/span> null<\/span> : password<\/span>.trim<\/span>();<\/span>    }<\/span>  }<\/span><\/pre>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.dao<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestV2<\/span>;<\/span>    public<\/span> interface<\/span> TestV2Mapper<\/span> {<\/span>    int<\/span> insert<\/span>(TestV2<\/span> record<\/span>);<\/span>      int<\/span> insertSelective<\/span>(TestV2<\/span> record<\/span>);<\/span>  }<\/span><\/pre>\n
        <?xml<\/span> version=\"1.0\" encoding=\"UTF-8\" ?><\/span><\/span>  <!DOCTYPE mapper PUBLIC \"-\/\/mybatis.org\/\/DTD Mapper 3.0\/\/EN\" \"http:\/\/mybatis.org\/dtd\/mybatis-3-mapper.dtd\" ><\/span><\/span>  <<\/span>mapper<\/span> namespace<\/span>=\"cn.wbnull.springbootdemo.dao.TestV2Mapper\"<\/span> ><\/span><\/span>   <<\/span>resultMap<\/span> id<\/span>=\"BaseResultMap\"<\/span> type<\/span>=\"cn.wbnull.springbootdemo.model.TestV2\"<\/span> ><\/span><\/span>    <<\/span>result<\/span> column<\/span>=\"id\"<\/span> property<\/span>=\"id\"<\/span> jdbcType<\/span>=\"INTEGER\"<\/span> \/><\/span><\/span>    <<\/span>result<\/span> column<\/span>=\"username\"<\/span> property<\/span>=\"username\"<\/span> jdbcType<\/span>=\"VARCHAR\"<\/span> \/><\/span><\/span>    <<\/span>result<\/span> column<\/span>=\"password\"<\/span> property<\/span>=\"password\"<\/span> jdbcType<\/span>=\"VARCHAR\"<\/span> \/><\/span><\/span>   <\/<\/span>resultMap<\/span>><\/span><\/span>   <<\/span>insert<\/span> id<\/span>=\"insert\"<\/span> parameterType<\/span>=\"cn.wbnull.springbootdemo.model.TestV2\"<\/span> ><\/span><\/span>    insert into testv2 (id, username, password<\/span>     )<\/span>    values (#{id,jdbcType=INTEGER}, #{username,jdbcType=VARCHAR}, #{password,jdbcType=VARCHAR}<\/span>     )<\/span>   <\/<\/span>insert<\/span>><\/span><\/span>   <<\/span>insert<\/span> id<\/span>=\"insertSelective\"<\/span> parameterType<\/span>=\"cn.wbnull.springbootdemo.model.TestV2\"<\/span> ><\/span><\/span>    insert into testv2<\/span>    <<\/span>trim<\/span> prefix<\/span>=\"(\"<\/span> suffix<\/span>=\")\"<\/span> suffixOverrides<\/span>=\",\"<\/span> ><\/span><\/span>     <<\/span>if<\/span> test<\/span>=\"id != null\"<\/span> ><\/span><\/span>      id,<\/span>     <\/<\/span>if<\/span>><\/span><\/span>     <<\/span>if<\/span> test<\/span>=\"username != null\"<\/span> ><\/span><\/span>      username,<\/span>     <\/<\/span>if<\/span>><\/span><\/span>     <<\/span>if<\/span> test<\/span>=\"password != null\"<\/span> ><\/span><\/span>      password,<\/span>     <\/<\/span>if<\/span>><\/span><\/span>    <\/<\/span>trim<\/span>><\/span><\/span>    <<\/span>trim<\/span> prefix<\/span>=\"values (\"<\/span> suffix<\/span>=\")\"<\/span> suffixOverrides<\/span>=\",\"<\/span> ><\/span><\/span>     <<\/span>if<\/span> test<\/span>=\"id != null\"<\/span> ><\/span><\/span>      #{id,jdbcType=INTEGER},<\/span>     <\/<\/span>if<\/span>><\/span><\/span>     <<\/span>if<\/span> test<\/span>=\"username != null\"<\/span> ><\/span><\/span>      #{username,jdbcType=VARCHAR},<\/span>     <\/<\/span>if<\/span>><\/span><\/span>     <<\/span>if<\/span> test<\/span>=\"password != null\"<\/span> ><\/span><\/span>      #{password,jdbcType=VARCHAR},<\/span>     <\/<\/span>if<\/span>><\/span><\/span>    <\/<\/span>trim<\/span>><\/span><\/span>   <\/<\/span>insert<\/span>><\/span><\/span>  <\/<\/span>mapper<\/span>><\/span><\/span><\/pre>\n
    5.5 \u6d4b\u8bd5<\/span><\/h2>\n
    5.5.1 Service\u5c42<\/span><\/h3>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.service<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.dao<\/span>.TestV2Mapper<\/span>;<\/span>  import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.model<\/span>.TestV2<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.beans<\/span>.factory<\/span>.annotation<\/span>.Autowired<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.stereotype<\/span>.Service<\/span>;<\/span>    @Service<\/span><\/span>  public<\/span> class<\/span> MySQLTestV2Service<\/span> {<\/span>      @Autowired<\/span><\/span>    private<\/span> TestV2Mapper<\/span> testV2Mapper<\/span>; \/\/\u8fd9\u91cc\u4f1a\u6709\u62a5\u9519\uff0c\u4e0d\u7528\u7ba1<\/span><\/span>      public<\/span> int<\/span> insert<\/span>(int<\/span> id<\/span>, String<\/span> username<\/span>, String<\/span> password<\/span>) {<\/span>      TestV2<\/span> testV2<\/span> =<\/span> new<\/span> TestV2<\/span>();<\/span>      testV2<\/span>.setId<\/span>(id<\/span>);<\/span>      testV2<\/span>.setUsername<\/span>(username<\/span>);<\/span>      testV2<\/span>.setPassword<\/span>(password<\/span>);<\/span>        return<\/span> testV2Mapper<\/span>.insert<\/span>(testV2<\/span>);<\/span>    }<\/span>  }<\/span><\/pre>\n
    5.5.1 Controller\u5c42<\/span><\/h3>\n
        package<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.controller<\/span>;<\/span>    import<\/span> cn<\/span>.wbnull<\/span>.springbootdemo<\/span>.service<\/span>.MySQLTestV2Service<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.beans<\/span>.factory<\/span>.annotation<\/span>.Autowired<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.context<\/span>.annotation<\/span>.Scope<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.PostMapping<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RequestMapping<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RequestParam<\/span>;<\/span>  import<\/span> org<\/span>.springframework<\/span>.web<\/span>.bind<\/span>.annotation<\/span>.RestController<\/span>;<\/span>    @RestController<\/span><\/span>  @Scope<\/span>(\"prototype\"<\/span>)<\/span>  @RequestMapping<\/span>(\"\/mysql\/testv2\"<\/span>)<\/span>  public<\/span> class<\/span> MySQLTestV2Controller<\/span> {<\/span>      @Autowired<\/span><\/span>    private<\/span> MySQLTestV2Service<\/span> mySQLTestV2Service<\/span>;<\/span>      @PostMapping<\/span>(value<\/span> =<\/span> \"\/insert\"<\/span>)<\/span>    public<\/span> int<\/span> insert<\/span>(@RequestParam<\/span>(value<\/span> =<\/span> \"id\"<\/span>) int<\/span> id<\/span>,<\/span>             @RequestParam<\/span>(value<\/span> =<\/span> \"username\"<\/span>) String<\/span> username<\/span>,<\/span>             @RequestParam<\/span>(value<\/span> =<\/span> \"password\"<\/span>) String<\/span> password<\/span><\/span>    ) throws<\/span> Exception<\/span> {<\/span>      return<\/span> mySQLTestV2Service<\/span>.insert<\/span>(id<\/span>, username<\/span>, password<\/span>);<\/span>    }<\/span>  }<\/span><\/pre>\n
    5.5.2 insert<\/span><\/h3>\n
    Postman\u63a5\u6536\u5230\u8f93\u51fa\u4e3a1\uff0c\u8868\u793a\u6210\u529f\uff0c\u6211\u4eec\u53bb\u67e5\u4e0b\u6570\u636e\u5e93<\/span><\/p>\n
    \u6570\u636e\u6210\u529f\u63d2\u5165<\/span><\/span><\/p>\n
    <\/span><\/p>\n
    \u8fd9\u6837\uff0c\u5bf9\u4e8e\u5927\u91cf\u7684\u6570\u636e\u5e93\u8868\uff0c\u6211\u4eec\u5c31\u53ef\u4ee5\u4f7f\u7528Generator\u6765\u751f\u6210\u57fa\u672c\u7684\u4ee3\u7801\uff0c\u7136\u540e\u81ea\u5df1\u518d\u6dfb\u52a0\u5176\u4ed6\u6240\u9700\u8981\u7684\u4ee3\u7801\u5373\u53ef\u3002<\/span><\/span><\/p>\n
    <\/span><\/span><\/p>\n
    \n
    <\/span><\/span>GitHub\uff1a<\/span>https:\/\/github.com\/dkbnull\/SpringBootDemo<\/span><\/span><\/span><\/p>\n
    CSDN\uff1ahttps:\/\/blog.csdn.net\/dkbnull\/article\/details\/87278817<\/span><\/span><\/span><\/span><\/span><\/span><\/p>\n
    \n
    <\/span><\/span><\/span><\/p>\n
    \n
    \u672c\u7bc7\u6587\u7ae0\u6765\u6e90\u4e8e\u5fae\u4fe1\u516c\u4f17\u53f7:                 \u7a0b\u5e8f\u5458null              <\/p>\n<\/blockquote>\n<\/div>\n","raw":"","protected":false},"excerpt":{"rendered":"
    \u5982\u679c\u6559\u7a0b\u4e2d\u4ee3\u7801\u4e0d\u4fbf\u4e8e\u9605\u8bfb\uff0c\u8bf7\u4f7f\u7528\u7535\u8111\u67e5\u770b\u6216\u70b9\u51fb\u9605\u8bfb\u539f\u6587\u3002 0. \u5f00\u53d1\u73af\u5883 IDE\uff1aIntelliJ IDEA 2017.1 x64 …<\/p>\n","protected":false},"author":1,"featured_media":4378,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"emotion":"","emotion_color":"","title_style":"","license":"","footnotes":""},"categories":[33,7],"tags":[],"class_list":["post-4395","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mybatis","category-spring-boot"],"post_thumbnail_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153356555-150x150.jpeg","content_first_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153359688.png","post_medium_image_300":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153356555-300x128.jpeg","post_thumbnail_image_624":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153356555-1024x435.jpeg","post_frist_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153359688.png","post_medium_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153356555-300x128.jpeg","post_large_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153356555-1024x435.jpeg","post_full_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153356555.jpeg","post_all_images":[{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153359688.png","id":"image0"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153359688.png","id":"image1"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153400873.png","id":"image2"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153400873.png","id":"image3"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153402212.png","id":"image4"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153402212.png","id":"image5"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153403390.png","id":"image6"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153403390.png","id":"image7"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153404871.png","id":"image8"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153404871.png","id":"image9"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153406243.png","id":"image10"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153406243.png","id":"image11"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153408612.png","id":"image12"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153408612.png","id":"image13"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153410322.png","id":"image14"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153410322.png","id":"image15"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153411693.jpg","id":"image16"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153411693.jpg","id":"image17"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153413811.jpg","id":"image18"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153413811.jpg","id":"image19"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153415615.png","id":"image20"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153415615.png","id":"image21"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153416853.png","id":"image22"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153416853.png","id":"image23"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153418155.png","id":"image24"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153418155.png","id":"image25"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153419590.png","id":"image26"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524153419590.png","id":"image27"}],"videoAdId":"","listAd":"0","listAdId":"","listAdEvery":6,"total_comments":0,"category_name":"Mybatis","post_date":"2019-02-15","like_count":"0","praiseWord":"\u9f13\u52b1","copyright_state":"","excitationAd":"0","rewardedVideoAdId":"","detailAdId":"","detailAd":"0","enterpriseMinapp":"0","audios":[],"postImageUrl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2023\/05\/20230519082947553.jpg","avatarurls":[],"related_posts":null,"pageviews":326,"next_post_id":4377,"next_post_title":"Spring Boot\u5165\u95e8\uff1a\u4f7f\u7528Schedule\u5b9e\u73b0\u5b9a\u65f6\u4efb\u52a1","previous_post_id":4399,"previous_post_title":"Spring Boot\u5165\u95e8\uff1a\u81ea\u5b9a\u4e49log4j\u65e5\u5fd7\u8f93\u51fa","_links":{"self":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/4395","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/comments?post=4395"}],"version-history":[{"count":0,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/4395\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media\/4378"}],"wp:attachment":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media?parent=4395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/categories?post=4395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/tags?post=4395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}