Spring boot整合mybatis步骤-TOY论坛

添加数据库以及mybatis maven依赖

jdbc：mybatis包含了spring-boot-starter-jdbc可以不用添加

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

<!-- mysql -->
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
</dependency>

编写mapper接口和相应的mapper xml文件

UserMapper.java

如果不添加@Mapper注解可以在SpringMybatisApplication.java也就是springboot启动类添加@MapperScan(“cn.kil.springboot_mybatis.mapper”)注解指定mapper接口的扫描路径。

package cn.kil.springboot_mybatis.mapper;

import cn.kil.springboot_mybatis.pojo.User;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

@Mapper
public interface UserMapper {
    public List<User> getAllUserList();
}

UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!-- 绑定mapper接口 -->
<mapper namespace="cn.kil.springboot_mybatis.mapper.UserMapper">
    <select id="getAllUserList" resultType="user">
        select * from kivm.k_users
    </select>
</mapper>

附加相应的实体类信息User

package cn.kil.springboot_mybatis.pojo;

import java.util.Date;

/**
 * @program: kivm
 * @ClassName: User
 * @description: 用户
 * @author: toy
 * @create: 2022-05-19 20:00
 */
public class User {
    private int uid;
    private String username;
    private String password;
    private String email;
    private String phone;
    private String icon;
    private Date createTime;
    private int status;

    public User() {
    }

    public User(int uid, String username, String password, String email, String phone, String icon, Date createTime, int status) {
        this.uid = uid;
        this.username = username;
        this.password = password;
        this.email = email;
        this.phone = phone;
        this.icon = icon;
        this.createTime = createTime;
        this.status = status;
    }

    public int getUid() {
        return uid;
    }

    public void setUid(int uid) {
        this.uid = uid;
    }

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public String getIcon() {
        return icon;
    }

    public void setIcon(String icon) {
        this.icon = icon;
    }

    public Date getCreateTime() {
        return createTime;
    }

    public void setCreateTime(Date createTime) {
        this.createTime = createTime;
    }

    public int getStatus() {
        return status;
    }

    public void setStatus(int status) {
        this.status = status;
    }

    @Override
    public String toString() {
        return "User{" +
                "uid=" + uid +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                ", email='" + email + '\'' +
                ", phone='" + phone + '\'' +
                ", icon='" + icon + '\'' +
                ", createTime=" + createTime +
                ", status=" + status +
                '}';
    }
}

编辑spring配置文件application.properties添加数据库以及Mapper xml信息

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/kivm?useSSl=true&useUnicode=true&characterEnding=utf8&serverTimezone=Asia/Shanghai
    username: root
    password: 123456
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  mapper-locations: classpath:cn/kil/springboot_mybatis/mapper/*Mapper.xml #mapper文件路径
  type-aliases-package: cn.kil.springboot_mybatis.pojo #实体类别名