SpringBoot整合MyBatis

SpringBoot整合MyBatis

1.导入MyBatis所需要的包

<dependency>
    <groupId>org.mybatis.spring.boot</groupId>
    <artifactId>mybatis-spring-boot-starter</artifactId>
    <version>2.3.0</version>
</dependency>

2.配置数据库连接信息

# 配置端口号
server:
  port: 8888
  
# 配置mysql
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/demo?serverTimezone=UTC&characterEncoding=utf-8
    username: root
    password: 123
    driver-class-name: com.mysql.cj.jdbc.Driver
​
# mybatis动态配置
mybatis:
  config-location:
  #实体类别名
  type-aliases-package: com.kk.pojo
  #扫描mapper配置文件
  mapper-locations: classpath:/mapper/*.xml

3.测试数据库是否连接成功

4.创建实体类

package com.boot.pojo;
​
import lombok.Data;
​
@Data
public class User {
    private Integer uid;//编号
    private String uname;//名字
    private String sex;//性别
    private Integer age;//年龄
    private Integer rid;//编号id
}

5.创建Mapper接口

package com.boot.mapper;
​
import com.boot.pojo.User;
import org.apache.ibatis.annotations.Mapper;
​
import java.util.List;
​
@Mapper
public interface UserMapper {
​
    List<User> findAll();
}

6.对应的Mapper映射文件

<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
​
<mapper namespace="com.boot.demo.mapper.UserMapper">
    <!--查询所有用户-->
    <select id="findAll" resultType="User">
        select * from user
    </select>
</mapper>

7.编写Controller进行测试

package com.boot.demo.web;
​
import com.boot.demo.service.UserService;
import com.boot.pojo.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
​
import java.util.List;
​
@Controller
public class UserController {
    @Autowired
    private UserService userService;
    @RequestMapping("/get")
    public String get(){
        List<User> all = userService.findAll();
        System.out.println(all.toString());
        return all.toString();
    }
}