SpringBoot整合MyBatis 简单查询与插入

新建一个SpringBoot项目

使用Spring Initializr生成工具生成一个SpringBoot项目

创建SpringBoot项目名称以及JDK版本

选择项目所要添加的依赖

• Spring Boot DevTools 热部署
• Spring Web web项目
• MyBatis FrameWork MyBatis 框架
• MySQL Driver MySQL驱动包

创建项目成功，查看pom文件中所添加的依赖jar包

		<!--springboot与mybatis的整合包-->
		<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.2</version>
        </dependency>
        
        <!--热部署的jar包-->
		<dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        
        <!--MySQL的驱动包-->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>

添加配置文件
以前配置项目用的是application.properties文件，而现在使用application.yml文件。其实SpringBoot底层会把application.yml文件解析为application.properties文件。
该文件风格比较简洁，配置也比较简单。

#连接数据库所需要的参数
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    #连接数据库的url遇到时区错误，须设置时区
    url: jdbc:mysql://localhost:3306/jdbctest?serverTimezone=GMT%2B8
    username: root
    password: 123456
   #配置模板引擎，返回页面
  thymeleaf:
    suffix: .html
    prefix: classpath:/templates/
  #配置热部署，当静态资源发生改变时，我们不要让springboot重新部署
  devtools:
    restart:
      exclude: static/**,templates/**
#mapper-locations 映射所在的路径
#给模型的包起别名
mybatis:
  mapper-locations: classpath:/mappers/*Mapper.xml
  type-aliases-package: com.nya.springboot.model
#打印日志 SQL执行语句
logging:
  level:
      com:
          nya:
             springboot:
               dao: debug

创建实体类、controller、service与dao层

Controller

package com.nya.springboot.controller;

import com.nya.springboot.model.User;
import com.nya.springboot.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;

@RestController
public class UserController {

    private UserService userService;

    @Autowired
    public void setUserService(UserService userService) {
        this.userService = userService;
    }

    @GetMapping("/userLogin")
    public String userLogin(String username, String password){
        User user = new User();
        user.setUsername(username);
        user.setPassword(password);
        int register = this.userService.register(user);
        System.out.println(register);
        return "register success";
    }

    @GetMapping("/userQuery")
    public String userQuery(Integer id){
        User user = this.userService.queryUser(id);
        System.out.println(user.toString());
        return "query success";
    }
}

实体类

package com.nya.springboot.model;

import java.io.Serializable;

public class User implements Serializable {
    //属性名一般与数据库的字段名保持一致 如果不一致查询会有问题
    private int id;
    private String username;
    private String password;

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    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;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

Service层

package com.nya.springboot.service;

import com.nya.springboot.dao.IUserDao;
import com.nya.springboot.model.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * 对dao层属性进行注入，调用dao层方法进行查询
 */
@Service
public class UserService {

    private IUserDao userDao;

    @Autowired
    public void setUserDao(IUserDao userDao) {
        this.userDao = userDao;
    }

    public int register(User user){
        return this.userDao.addUser(user);
    }

    public User queryUser(Integer id){
        return this.userDao.queryUser(id);
    }
}

dao层接口与mapper配置文件

package com.nya.springboot.dao;

import com.nya.springboot.model.User;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface IUserDao {
    int addUser(User user);

    User queryUser(Integer id);
}

<?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">
<!--namespace写dao的包的类路径-->
<mapper namespace="com.nya.springboot.dao.IUserDao">
    <!--id 值就是UserDao中的方法名称-->
    <insert id="addUser" parameterType="com.nya.springboot.model.User">
        insert into sb_user(username,password) values (#{username},#{password})
    </insert>

    <select id="queryUser" parameterType="java.lang.Integer" resultType="com.nya.springboot.model.User">
        select * from sb_user where id=#{id}
    </select>
</mapper>

在启动类中配置扫描mapper路径

package com.nya.springboot;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
//配置文件扫描
@MapperScan("com.nya.springboot.dao")
public class SpringBootMyBatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringBootMyBatisApplication.class, args);
    }

}

使用注解的方式对MyBatis进行配置

在dao层添加一个查询User的方法，不须配置mapper.xml文件

//select注解进行数据查询，使用Results注解对结果封装
@Select("select * from sb_user where id=#{id}")
    @Results({
            @Result(property = "username",column = "username"),
            @Result(property = "password",column = "password"),
            @Result(property = "id",column = "id")
    })
    User selectUser(Integer id);

在controller中调用service层调用的新方法

@GetMapping("/selectUser/{id}")
//@PathVariable是对url后的id值进行参数绑定
    public String selectUser(@PathVariable Integer id){
        User user = this.userService.selectUser(id);
        if(user!=null){
            return user.toString();
        }else {
            return "No person！！！！！！！！";
        }
    }

一个简易的springboot整合mybatis框架结构就构造好了，启动项目在浏览器上测试即可