四、SpringBoot Mybatis

1.创建一个springboot项目，点击File->New->Project->Spring Initializr->勾选Spring Web

-- ----------------------------
-- Table structure for hr_user
-- ----------------------------
DROP TABLE IF EXISTS `hr_user`;
CREATE TABLE `hr_user`  (
  `id` bigint(20) NOT NULL,
  `age` tinyint(3) NULL DEFAULT NULL COMMENT '年龄',
  `name` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名字',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hr_user
-- ----------------------------
INSERT INTO `hr_user` VALUES (1, 20, 'wg1');
INSERT INTO `hr_user` VALUES (2, 20, 'wg2');
INSERT INTO `hr_user` VALUES (3, 20, 'wg3');

2.引入相关依赖包

        <!-- mysql驱动 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.27</version>
        </dependency>

        <!-- mybatis/spring包 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.2</version>
        </dependency>

        <!--lombok插件：减少实体类get、set方法-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.4</version>
        </dependency>

3.配置application.yml

server:
  port: 8080
spring:
  datasource:
    driverClassName: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useSSL=false&zeroDateTimeBehavior=convertToNull&serverTimezone=UTC
    username: root
    password: root123456

## 该配置节点为独立的节点，有很多同学容易将这个配置放在spring的节点下，导致配置无法被识别
mybatis:
  mapper-locations: classpath:mapper/*.xml #注意：一定要对应mapper映射xml文件的所在路径
  typeAliasesPackage: com.weigang.entiy # 注意：对应实体类的路径

4.Java代码

1.实体类HrUserEntity
    @Data
    @SuppressWarnings("all")
    public class HrUserEntity {

        //主键id
        private Integer id;
        //年龄
        private Integer age;
        //名字
        private String name;

    }

2.dao(接口)

    @Repository
    @Mapper
    public interface HrUserMapper{

        //获取用户列表
        @SuppressWarnings("all")
        List<HrUserEntity> selectAllUser();

    }


3.service
    @Service
    public class HrUserService {

        @Autowired
        private HrUserMapper hrUserMapper;


        /**
         * 获取用户列表
         * @param
         * @return java.util.List<HrUserEntity>
         */
        public List<HrUserEntity> getUsers(){
            List<HrUserEntity> users = hrUserMapper.selectAllUser();
            return users;
        }

    }

4.controller
    @RestController
    @RequestMapping("/user")
    public class HrUserController {

        @Autowired
        private HrUserService hrUserService;

        @GetMapping(value = "/getUsers")
        public List<HrUserEntity> getUsers(){
            return hrUserService.getUsers();//http://localhost:8080/user/getUsers
        }

    }

5.项目结构

6.执行效果