{"id":4330,"date":"2024-03-03T17:06:30","date_gmt":"2024-03-03T09:06:30","guid":{"rendered":"https:\/\/xinchewhd.com.cn\/index.php\/spring-boot\/spring-boot%e6%95%b4%e5%90%88mybatis%e9%85%8d%e7%bd%ae%e5%a4%9a%e6%95%b0%e6%8d%ae%e6%ba%90\/"},"modified":"2024-03-03T17:06:30","modified_gmt":"2024-03-03T09:06:30","slug":"spring-boot%e6%95%b4%e5%90%88mybatis%e9%85%8d%e7%bd%ae%e5%a4%9a%e6%95%b0%e6%8d%ae%e6%ba%90","status":"publish","type":"post","link":"https:\/\/xinchewhd.com.cn\/index.php\/spring-boot\/spring-boot%e6%95%b4%e5%90%88mybatis%e9%85%8d%e7%bd%ae%e5%a4%9a%e6%95%b0%e6%8d%ae%e6%ba%90\/","title":{"rendered":"Spring Boot\u6574\u5408Mybatis\u914d\u7f6e\u591a\u6570\u636e\u6e90"},"content":{"rendered":"
\n

\u5982\u679c\u6587\u7ae0\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

\u591a\u6570\u636e\u6e90\u5373\u52a8\u6001\u6570\u636e\u6e90\uff0c\u968f\u7740\u9879\u76ee\u5f00\u53d1\u9010\u6e10\u6269\u5927\uff0c\u5355\u4e2a\u6570\u636e\u6e90\u3001\u5355\u4e00\u6570\u636e\u6e90\u5df2\u7ecf\u65e0\u6cd5\u6ee1\u8db3\u9700\u6c42\u9879\u76ee\u7684\u652f\u6491\u9700\u6c42\u3002<\/span><\/p>\n

\u6216\u662f\u5355\u4e00\u6570\u636e\u5e93\u65e0\u6cd5\u627f\u8f7d\u5927\u6570\u636e\u91cf\u7684\u8bbf\u95ee\uff0c\u9700\u4f7f\u7528\u591a\u4e2a\u6570\u636e\u5e93\u8fdb\u884c\u6570\u636e\u7684\u8bfb\u5199\u5206\u79bb\uff1b<\/span><\/p>\n

\u6216\u662f\u67d0\u4e9b\u7279\u6b8a\u4e1a\u52a1\u9700\u6c42\uff0c\u9700\u64cd\u4f5c\u4e0d\u540c\u7684\u6570\u636e\u5e93\u3002<\/span><\/p>\n

\u5728 <\/span>Spring Boot\u6574\u5408MyBatis\u8fde\u63a5\u6570\u636e\u5e93<\/span><\/span><\/a> \u6587\u7ae0\u4e2d\uff0c\u5c55\u793a\u4e86Spring Boot\u6574\u5408MyBatis\u8fde\u63a5\u6570\u636e\u5e93\u7684\u65b9\u6cd5\uff0c\u57fa\u4e8e\u6b64\uff0cSpring Boot \u6574\u5408MyBatis \u914d\u7f6e\u591a\u6570\u636e\u6e90\u3002<\/span><\/p>\n

\n

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

    JDK\uff1a1.8<\/span><\/p>\n<\/li>\n

  • \n

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

  • \n

    MySQL\uff1a5.7.13<\/span><\/p>\n<\/li>\n<\/ul>\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>groupId<\/span>><\/span>mysql<\/<\/span>groupId<\/span>><\/span><\/span>  <<\/span>artifactId<\/span>><\/span>mysql-connector-java<\/<\/span>artifactId<\/span>><\/span><\/span>  <<\/span>version<\/span>><\/span>8.0.28<\/<\/span>version<\/span>><\/span><\/span>  <<\/span>scope<\/span>><\/span>runtime<\/<\/span>scope<\/span>><\/span><\/span><\/<\/span>dependency<\/span>><\/span><\/span><\/span><\/span><!--lombok--><\/span><\/span><<\/span>dependency<\/span>><\/span><\/span>  <<\/span>groupId<\/span>><\/span>org.projectlombok<\/<\/span>groupId<\/span>><\/span><\/span>  <<\/span>artifactId<\/span>><\/span>lombok<\/<\/span>artifactId<\/span>><\/span><\/span>  <<\/span>version<\/span>><\/span>1.18.30<\/<\/span>version<\/span>><\/span><\/span>  <<\/span>scope<\/span>><\/span>provided<\/<\/span>scope<\/span>><\/span><\/span><\/<\/span>dependency<\/span>><\/span><\/span><\/pre>\n
    2 \u5f15\u5165\u6570\u636e\u6e90<\/span><\/h1>\n
    server<\/span>:<\/span><\/span>  port<\/span>: <\/span>8090<\/span><\/span>spring<\/span>:<\/span><\/span>  datasource<\/span>:<\/span><\/span>   master<\/span>:<\/span><\/span>    jdbc-url<\/span>: <\/span>jdbc:<\/span>mysql:<\/span>\/\/127.0.0.1:<\/span>3306\/test_master?characterEncoding=utf8&serverTimezone=GMT%2B8<\/span>    username<\/span>: <\/span>root<\/span>    password<\/span>: <\/span>root<\/span>    driver-class-name<\/span>: <\/span>com.mysql.cj.jdbc.Driver<\/span>   slave<\/span>:<\/span><\/span>    jdbc-url<\/span>: <\/span>jdbc:<\/span>mysql:<\/span>\/\/127.0.0.1:<\/span>3306\/test_slave?characterEncoding=utf8&serverTimezone=GMT%2B8<\/span>    username<\/span>: <\/span>root<\/span>    password<\/span>: <\/span>root<\/span>    driver-class-name<\/span>: <\/span>com.mysql.cj.jdbc.Driver<\/span>#<\/span><\/span>mybatis<\/span>:<\/span><\/span>  mapper-locations<\/span>: <\/span>classpath:<\/span>mapper\/**\/*.xml<\/span>  type-aliases-package<\/span>: <\/span>cn.wbnull.springbootdemo.entity<\/span><\/pre>\n
    \u8be5\u914d\u7f6e\u65b9\u5f0f\u4e0b\uff0c\u9700\u8981\u64cd\u4f5c\u7684\u4e24\u4e2a\u6570\u636e\u5e93\u7684Mapper\u9700\u653e\u7f6e\u5728\u4e0d\u540c\u6587\u4ef6\u5939\u4e0b\uff0c\u5982\u4e0b\u56fe\u6240\u793a\uff1a<\/span><\/p>\n
    3 \u914d\u7f6emaster\u5e93\u7684\u6e90\u8fde\u63a5<\/span><\/h1>\n
    @Configuration<\/span><\/span>@MapperScan<\/span>(basePackages<\/span> =<\/span> \"cn.wbnull.springbootdemo.mapper.master\"<\/span>, sqlSessionFactoryRef<\/span> =<\/span> \"masterSqlSessionFactory\"<\/span>)<\/span>public<\/span> class<\/span> MasterDataSourceConfig<\/span> {<\/span><\/span><\/span>  @Primary<\/span><\/span>  @Bean<\/span>(\"masterDataSource\"<\/span>)<\/span>  @ConfigurationProperties<\/span>(prefix<\/span> =<\/span> \"spring.datasource.master\"<\/span>)<\/span>  public<\/span> DataSource<\/span> masterDataSource<\/span>() {<\/span>    return<\/span> DataSourceBuilder<\/span>.create<\/span>().build<\/span>();<\/span>   }<\/span><\/span><\/span>  @Primary<\/span><\/span>  @Bean<\/span>(\"masterDataSourceTransactionManager\"<\/span>)<\/span>  public<\/span> DataSourceTransactionManager<\/span> masterDataSourceTransactionManager<\/span>(@Qualifier<\/span>(\"masterDataSource\"<\/span>) DataSource<\/span> dataSource<\/span>) {<\/span>    return<\/span> new<\/span> DataSourceTransactionManager<\/span>(dataSource<\/span>);<\/span>   }<\/span><\/span><\/span>  @Primary<\/span><\/span>  @Bean<\/span>(\"masterSqlSessionFactory\"<\/span>)<\/span>  public<\/span> SqlSessionFactory<\/span> masterSqlSessionFactory<\/span>(@Qualifier<\/span>(\"masterDataSource\"<\/span>) DataSource<\/span> dataSource<\/span>) throws<\/span> Exception<\/span> {<\/span>    SqlSessionFactoryBean<\/span> sqlSessionFactory<\/span> =<\/span> new<\/span> SqlSessionFactoryBean<\/span>();<\/span>    sqlSessionFactory<\/span>.setDataSource<\/span>(dataSource<\/span>);<\/span>    Resource<\/span>[] resources<\/span> =<\/span> new<\/span> PathMatchingResourcePatternResolver<\/span>().getResources<\/span>(\"classpath:mapper\/master\/*.xml\"<\/span>);<\/span>    sqlSessionFactory<\/span>.setMapperLocations<\/span>(resources<\/span>);<\/span><\/span><\/span>    return<\/span> sqlSessionFactory<\/span>.getObject<\/span>();<\/span>   }<\/span>}<\/span><\/pre>\n
    4 \u914d\u7f6eslave\u5e93\u7684\u6e90\u8fde\u63a5<\/span><\/h1>\n
    @Configuration<\/span><\/span>@MapperScan<\/span>(basePackages<\/span> =<\/span> \"cn.wbnull.springbootdemo.mapper.slave\"<\/span>, sqlSessionFactoryRef<\/span> =<\/span> \"slaveSqlSessionFactory\"<\/span>)<\/span>public<\/span> class<\/span> SlaveDataSourceConfig<\/span> {<\/span><\/span><\/span>  @Bean<\/span>(\"slaveDataSource\"<\/span>)<\/span>  @ConfigurationProperties<\/span>(prefix<\/span> =<\/span> \"spring.datasource.slave\"<\/span>)<\/span>  public<\/span> DataSource<\/span> slaveDataSource<\/span>() {<\/span>    return<\/span> DataSourceBuilder<\/span>.create<\/span>().build<\/span>();<\/span>   }<\/span><\/span><\/span>  @Bean<\/span>(\"slaveDataSourceTransactionManager\"<\/span>)<\/span>  public<\/span> DataSourceTransactionManager<\/span> slaveDataSourceTransactionManager<\/span>(@Qualifier<\/span>(\"slaveDataSource\"<\/span>) DataSource<\/span> dataSource<\/span>) {<\/span>    return<\/span> new<\/span> DataSourceTransactionManager<\/span>(dataSource<\/span>);<\/span>   }<\/span><\/span><\/span>  @Bean<\/span>(\"slaveSqlSessionFactory\"<\/span>)<\/span>  public<\/span> SqlSessionFactory<\/span> slaveSqlSessionFactory<\/span>(@Qualifier<\/span>(\"slaveDataSource\"<\/span>) DataSource<\/span> dataSource<\/span>) throws<\/span> Exception<\/span> {<\/span>    SqlSessionFactoryBean<\/span> sqlSessionFactory<\/span> =<\/span> new<\/span> SqlSessionFactoryBean<\/span>();<\/span>    sqlSessionFactory<\/span>.setDataSource<\/span>(dataSource<\/span>);<\/span>    Resource<\/span>[] resources<\/span> =<\/span> new<\/span> PathMatchingResourcePatternResolver<\/span>().getResources<\/span>(\"classpath:mapper\/slave\/*.xml\"<\/span>);<\/span>    sqlSessionFactory<\/span>.setMapperLocations<\/span>(resources<\/span>);<\/span><\/span><\/span>    return<\/span> sqlSessionFactory<\/span>.getObject<\/span>();<\/span>   }<\/span>}<\/span><\/pre>\n
    5 \u6d4b\u8bd5<\/span><\/h1>\n
    5.1 \u65b0\u5efa\u6570\u636e\u5e93\u8868<\/span><\/h2>\n
    CREATE<\/span> SCHEMA `test_master` DEFAULT CHARACTER SET<\/span> utf8mb4 ;<\/span><\/span><\/span>CREATE<\/span> TABLE<\/span> `test_master`.`user` (<\/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><\/span><\/span>INSERT<\/span> INTO<\/span> `test_master`.`user` (`name`) VALUES<\/span> ('\u5f20\u4e09'<\/span>);<\/span>INSERT<\/span> INTO<\/span> `test_master`.`user` (`name`) VALUES<\/span> ('\u674e\u56db'<\/span>);<\/span>INSERT<\/span> INTO<\/span> `test_master`.`user` (`name`) VALUES<\/span> ('\u738b\u4e94'<\/span>);<\/span>INSERT<\/span> INTO<\/span> `test_master`.`user` (`name`) VALUES<\/span> ('\u5468\u516d'<\/span>);<\/span><\/span><\/span><\/span><\/span>CREATE<\/span> SCHEMA `test_slave` DEFAULT CHARACTER SET<\/span> utf8mb4 ;<\/span><\/span><\/span>CREATE<\/span> TABLE<\/span> `test_slave`.`user_info` (<\/span>  `id` INT<\/span> NOT<\/span> NULL<\/span> AUTO_INCREMENT,<\/span>  `userCode` VARCHAR<\/span>(20<\/span>) NOT<\/span> NULL<\/span>,<\/span>  `userName` VARCHAR<\/span>(45<\/span>) NULL<\/span>,<\/span>  `password` VARCHAR<\/span>(40<\/span>) NOT<\/span> NULL<\/span>,<\/span>  PRIMARY KEY (`id`));<\/span> <\/span>INSERT<\/span> INTO<\/span> `test_slave`.`user_info` (`id`, `userCode`, `userName`, `password`) VALUES<\/span> ('1'<\/span>, 'zhangsan'<\/span>, '\u5f20\u4e09\u4e09'<\/span>, 'zhangsan'<\/span>);<\/span>INSERT<\/span> INTO<\/span> `test_slave`.`user_info` (`id`, `userCode`, `userName`, `password`) VALUES<\/span> ('2'<\/span>, 'lisi'<\/span>, '\u674e\u56db\u56db'<\/span>, 'lisi'<\/span>);<\/span>INSERT<\/span> INTO<\/span> `test_slave`.`user_info` (`id`, `userCode`, `userName`, `password`) VALUES<\/span> ('3'<\/span>, 'wangwu'<\/span>, '\u738b\u4e94\u4e94'<\/span>, 'wangwu'<\/span>);<\/span>INSERT<\/span> INTO<\/span> `test_slave`.`user_info` (`id`, `userCode`, `userName`, `password`) VALUES<\/span> ('4'<\/span>, 'zhouliu'<\/span>, '\u5468\u516d\u516d'<\/span>, 'zhouliu'<\/span>);<\/span><\/pre>\n
    5.2 \u65b0\u5efa\u5b9e\u4f53\u7c7b<\/span><\/h2>\n
    @Data<\/span><\/span>public<\/span> class<\/span> User<\/span> {<\/span><\/span><\/span>  private<\/span> int<\/span> id<\/span>;<\/span>  private<\/span> String<\/span> name<\/span>;<\/span>}<\/span><\/pre>\n
    @Data<\/span><\/span>public<\/span> class<\/span> UserInfo<\/span> {<\/span><\/span><\/span>  private<\/span> Integer<\/span> id<\/span>;<\/span>  private<\/span> String<\/span> userCode<\/span>;<\/span>  private<\/span> String<\/span> userName<\/span>;<\/span>  private<\/span> String<\/span> password<\/span>;<\/span>}<\/span><\/pre>\n
    5.3 \u65b0\u5efaMapper<\/span><\/h2>\n
    @Repository<\/span><\/span>public<\/span> interface<\/span> UserMapper<\/span> {<\/span><\/span><\/span>  void<\/span> add<\/span>(@Param<\/span>(\"user\"<\/span>) User<\/span> user<\/span>);<\/span><\/span><\/span>  List<\/span><<\/span>User<\/span>><\/span> query<\/span>();<\/span><\/span><\/span>  void<\/span> update<\/span>(@Param<\/span>(\"id\"<\/span>) int<\/span> id<\/span>, @Param<\/span>(\"name\"<\/span>) String<\/span> name<\/span>);<\/span><\/span><\/span>  void<\/span> delete<\/span>(@Param<\/span>(\"id\"<\/span>) int<\/span> id<\/span>);<\/span>}<\/span><\/pre>\n
    @Repository<\/span><\/span>public<\/span> interface<\/span> UserInfoMapper<\/span> {<\/span><\/span><\/span>  List<\/span><<\/span>User<\/span>><\/span> query<\/span>();<\/span>}<\/span><\/pre>\n
    5.4 \u65b0\u5efa\u6620\u5c04\u6587\u4ef6<\/span><\/h2>\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.mapper.master.UserMapper\"<\/span>><\/span><\/span><\/span><\/span>  <!-- \u901a\u7528\u67e5\u8be2\u6620\u5c04\u7ed3\u679c --><\/span><\/span>  <<\/span>resultMap<\/span> id<\/span>=\"BaseResultMap\"<\/span> type<\/span>=\"cn.wbnull.springbootdemo.entity.User\"<\/span>><\/span><\/span>    <<\/span>id<\/span> column<\/span>=\"id\"<\/span> property<\/span>=\"id\"<\/span>\/><\/span><\/span>    <<\/span>result<\/span> column<\/span>=\"name\"<\/span> property<\/span>=\"name\"<\/span>\/><\/span><\/span>  <\/<\/span>resultMap<\/span>><\/span><\/span><\/span><\/span>  <!-- \u901a\u7528\u67e5\u8be2\u7ed3\u679c\u5217 --><\/span><\/span>  <<\/span>sql<\/span> id<\/span>=\"Base_Column_List\"<\/span>><\/span><\/span>     id, name<\/span>  <\/<\/span>sql<\/span>><\/span><\/span><\/span><\/span>  <<\/span>insert<\/span> id<\/span>=\"add\"<\/span>><\/span><\/span>     INSERT INTO user(<<\/span>include<\/span> refid<\/span>=\"Base_Column_List\"<\/span>\/><\/span>)<\/span>     VALUES<\/span>     (<\/span>     #{user.id},<\/span>     #{user.name}<\/span>     )<\/span>  <\/<\/span>insert<\/span>><\/span><\/span><\/span><\/span>  <<\/span>select<\/span> id<\/span>=\"query\"<\/span> resultMap<\/span>=\"BaseResultMap\"<\/span>><\/span><\/span>     SELECT * FROM user<\/span>  <\/<\/span>select<\/span>><\/span><\/span><\/span><\/span>  <<\/span>update<\/span> id<\/span>=\"update\"<\/span>><\/span><\/span>     UPDATE user SET name = '${name}' WHERE id = '${id}'<\/span>  <\/<\/span>update<\/span>><\/span><\/span><\/span><\/span>  <<\/span>update<\/span> id<\/span>=\"delete\"<\/span>><\/span><\/span>     DELETE FROM user where id = '${id}'<\/span>  <\/<\/span>update<\/span>><\/span><\/span><\/<\/span>mapper<\/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.mapper.slave.UserInfoMapper\"<\/span>><\/span><\/span><\/span><\/span>  <!-- \u901a\u7528\u67e5\u8be2\u6620\u5c04\u7ed3\u679c --><\/span><\/span>  <<\/span>resultMap<\/span> id<\/span>=\"BaseResultMap\"<\/span> type<\/span>=\"cn.wbnull.springbootdemo.entity.UserInfo\"<\/span>><\/span><\/span>    <<\/span>id<\/span> column<\/span>=\"id\"<\/span> property<\/span>=\"id\"<\/span> \/><\/span><\/span>    <<\/span>result<\/span> column<\/span>=\"userCode\"<\/span> property<\/span>=\"userCode\"<\/span> \/><\/span><\/span>    <<\/span>result<\/span> column<\/span>=\"userName\"<\/span> property<\/span>=\"userName\"<\/span> \/><\/span><\/span>    <<\/span>result<\/span> column<\/span>=\"password\"<\/span> property<\/span>=\"password\"<\/span> \/><\/span><\/span>  <\/<\/span>resultMap<\/span>><\/span><\/span><\/span><\/span>  <!-- \u901a\u7528\u67e5\u8be2\u7ed3\u679c\u5217 --><\/span><\/span>  <<\/span>sql<\/span> id<\/span>=\"Base_Column_List\"<\/span>><\/span><\/span>     id, userCode, userName, password<\/span>  <\/<\/span>sql<\/span>><\/span><\/span><\/span><\/span>  <<\/span>select<\/span> id<\/span>=\"query\"<\/span> resultMap<\/span>=\"BaseResultMap\"<\/span>><\/span><\/span>     SELECT * FROM user_info<\/span>  <\/<\/span>select<\/span>><\/span><\/span><\/<\/span>mapper<\/span>><\/span><\/span><\/pre>\n
    5.5 \u65b0\u5efaService<\/span><\/h2>\n
    @Service<\/span><\/span>public<\/span> class<\/span> UserService<\/span> {<\/span><\/span><\/span>  @Autowired<\/span><\/span>  private<\/span> UserMapper<\/span> userMapper<\/span>;<\/span><\/span><\/span>  public<\/span> String<\/span> add<\/span>(String<\/span> name<\/span>) {<\/span>    User<\/span> user<\/span> =<\/span> new<\/span> User<\/span>();<\/span>    user<\/span>.setName<\/span>(name<\/span>);<\/span><\/span><\/span>    userMapper<\/span>.add<\/span>(user<\/span>);<\/span><\/span><\/span>    return<\/span> \"\u64cd\u4f5c\u6210\u529f\"<\/span>;<\/span>   }<\/span><\/span><\/span>  public<\/span> List<\/span><<\/span>User<\/span>><\/span> query<\/span>() {<\/span>    return<\/span> userMapper<\/span>.query<\/span>();<\/span>   }<\/span><\/span><\/span>  public<\/span> String<\/span> update<\/span>(int<\/span> id<\/span>, String<\/span> name<\/span>) {<\/span>    userMapper<\/span>.update<\/span>(id<\/span>, name<\/span>);<\/span><\/span><\/span>    return<\/span> \"\u64cd\u4f5c\u6210\u529f\"<\/span>;<\/span>   }<\/span><\/span><\/span>  public<\/span> String<\/span> delete<\/span>(int<\/span> id<\/span>) {<\/span>    userMapper<\/span>.delete<\/span>(id<\/span>);<\/span><\/span><\/span>    return<\/span> \"\u64cd\u4f5c\u6210\u529f\"<\/span>;<\/span>   }<\/span>}<\/span><\/pre>\n
    @Service<\/span><\/span>public<\/span> class<\/span> UserInfoService<\/span> {<\/span><\/span><\/span>  @Autowired<\/span><\/span>  private<\/span> UserInfoMapper<\/span> userInfoMapper<\/span>;<\/span><\/span><\/span>  public<\/span> List<\/span><<\/span>User<\/span>><\/span> query<\/span>() {<\/span>    return<\/span> userInfoMapper<\/span>.query<\/span>();<\/span>   }<\/span>}<\/span><\/pre>\n
    5.6 \u65b0\u5efaController<\/span><\/h2>\n
    @RestController<\/span><\/span>@RequestMapping<\/span>(\"user\"<\/span>)<\/span>public<\/span> class<\/span> UserController<\/span> {<\/span><\/span><\/span>  @Autowired<\/span><\/span>  public<\/span> UserService<\/span> userService<\/span>;<\/span><\/span><\/span>  @PostMapping<\/span>(value<\/span> =<\/span> \"add\"<\/span>)<\/span>  public<\/span> String<\/span> add<\/span>(@RequestParam<\/span>(value<\/span> =<\/span> \"name\"<\/span>) String<\/span> name<\/span>) {<\/span>    return<\/span> userService<\/span>.add<\/span>(name<\/span>);<\/span>   }<\/span><\/span><\/span>  @PostMapping<\/span>(value<\/span> =<\/span> \"query\"<\/span>)<\/span>  public<\/span> List<\/span><<\/span>User<\/span>><\/span> query<\/span>() {<\/span>    return<\/span> userService<\/span>.query<\/span>();<\/span>   }<\/span><\/span><\/span>  @PostMapping<\/span>(value<\/span> =<\/span> \"update\"<\/span>)<\/span>  public<\/span> String<\/span> update<\/span>(@RequestParam<\/span>(value<\/span> =<\/span> \"id\"<\/span>) int<\/span> id<\/span>, @RequestParam<\/span>(value<\/span> =<\/span> \"name\"<\/span>) String<\/span> name<\/span>) {<\/span>    return<\/span> userService<\/span>.update<\/span>(id<\/span>, name<\/span>);<\/span>   }<\/span><\/span><\/span>  @PostMapping<\/span>(value<\/span> =<\/span> \"delete\"<\/span>)<\/span>  public<\/span> String<\/span> delete<\/span>(@RequestParam<\/span>(value<\/span> =<\/span> \"id\"<\/span>) int<\/span> id<\/span>) {<\/span>    return<\/span> userService<\/span>.delete<\/span>(id<\/span>);<\/span>   }<\/span>}<\/span><\/pre>\n
    @Controller<\/span><\/span>@RequestMapping<\/span>(\"userInfo\"<\/span>)<\/span>public<\/span> class<\/span> UserInfoController<\/span> {<\/span><\/span><\/span>  @Autowired<\/span><\/span>  public<\/span> UserInfoService<\/span> userInfoService<\/span>;<\/span><\/span><\/span>  @PostMapping<\/span>(value<\/span> =<\/span> \"query\"<\/span>)<\/span>  public<\/span> List<\/span><<\/span>User<\/span>><\/span> query<\/span>() {<\/span>    return<\/span> userInfoService<\/span>.query<\/span>();<\/span>   }<\/span>}<\/span><\/pre>\n
    5.7 \u6d4b\u8bd5<\/span><\/h2>\n
    \u4f7f\u7528Postman\u6d4b\u8bd5\uff0c\u8f93\u51fa\u7ed3\u679c\u5982\u4e0b<\/span><\/p>\n
    5.8.1 master select<\/span><\/h3>\n
    5.8.2 master insert<\/span><\/h3>\n
    \u6570\u636e\u5e93\u4e2d\u63d2\u5165\u6210\u529f<\/span><\/p>\n
    5.8.3 master update<\/span><\/h3>\n
    \u6570\u636e\u5e93\u4e2d\u66f4\u65b0\u6210\u529f<\/span><\/p>\n
    5.8.4 master delete<\/span><\/h3>\n
    \u6570\u636e\u5e93\u4e2d\u5220\u9664\u6210\u529f<\/span><\/p>\n
    5.8.5 slave select<\/span><\/h3>\n
    \u622a\u81f3\u8fd9\u91cc\uff0cSpring Boot\u5df2\u7ecf\u6210\u529f\u6574\u5408MyBatis\u591a\u6570\u636e\u6e90\uff0c\u5e76\u8fde\u63a5\u4e0a\u4e86\u6570\u636e\u5e93\uff0c\u4e14\u6d4b\u8bd5\u6b63\u5e38\u3002<\/span><\/p>\n
    \n
    \n
    CSDN\uff1a<\/span>https:\/\/blog.csdn.net\/dkbnull\/article\/details\/136433910<\/span><\/span><\/p>\n
    \u77e5\u4e4e\uff1a<\/span>https:\/\/zhuanlan.zhihu.com\/p\/685038746<\/span><\/span><\/span><\/p>\n
    \n
    <\/mp-style-type><\/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\u6587\u7ae0\u4e2d\u4ee3\u7801\u4e0d\u4fbf\u4e8e\u9605\u8bfb\uff0c\u8bf7\u4f7f\u7528\u7535\u8111\u67e5\u770b\u6216\u70b9\u51fb\u9605\u8bfb\u539f\u6587\u3002 \u591a\u6570\u636e\u6e90\u5373\u52a8\u6001\u6570\u636e\u6e90\uff0c\u968f\u7740\u9879\u76ee\u5f00\u53d1\u9010\u6e10\u6269\u5927\uff0c\u5355\u4e2a\u6570\u636e\u6e90\u3001\u5355\u4e00\u6570\u636e\u6e90\u5df2\u7ecf\u65e0 …<\/p>\n","protected":false},"author":1,"featured_media":4318,"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-4330","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\/20240524152905546-150x150.jpeg","content_first_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152910379.png","post_medium_image_300":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152905546-300x127.jpeg","post_thumbnail_image_624":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152905546-1024x435.jpeg","post_frist_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152910379.png","post_medium_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152905546-300x127.jpeg","post_large_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152905546-1024x435.jpeg","post_full_image":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152905546.jpeg","post_all_images":[{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152910379.png","id":"image0"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152910379.png","id":"image1"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152912574.png","id":"image2"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152912574.png","id":"image3"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152914778.png","id":"image4"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152914778.png","id":"image5"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152916298.png","id":"image6"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152916298.png","id":"image7"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152918932.png","id":"image8"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152918932.png","id":"image9"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152920169.png","id":"image10"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152920169.png","id":"image11"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152922440.png","id":"image12"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152922440.png","id":"image13"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152924160.png","id":"image14"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152924160.png","id":"image15"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152926518.png","id":"image16"},{"imagesurl":"https:\/\/wp-moto-1258805347.cos.ap-shanghai.myqcloud.com\/2024\/05\/20240524152926518.png","id":"image17"}],"videoAdId":"","listAd":"0","listAdId":"","listAdEvery":6,"total_comments":0,"category_name":"Mybatis","post_date":"2024-03-03","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":329,"next_post_id":4317,"next_post_title":"Spring Boot\u6574\u5408MyBatis Plus\u914d\u7f6e\u591a\u6570\u636e\u6e90","previous_post_id":3764,"previous_post_title":"Mybaits\/MybatisPlus\u505a\u884c\u9501","_links":{"self":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/4330","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=4330"}],"version-history":[{"count":0,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/posts\/4330\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media\/4318"}],"wp:attachment":[{"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/media?parent=4330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/categories?post=4330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xinchewhd.com.cn\/index.php\/wp-json\/wp\/v2\/tags?post=4330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}