SpringBoot整合Mybatis

1.新建SpringBoot工程

引入的依赖如下：

<dependencies>

        <!-- 添加spring-boot-starter-web模块依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <!-- 添加spring-boot-starter-thymeleaf模块依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>

        <!-- 添加MySQL依赖 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

        <!-- 添加MyBatis依赖 -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.1</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-test</artifactId>
            <version>2.2.0.RELEASE</version>
            <scope>test</scope>
        </dependency>
    </dependencies>

2.目录结构如下图所示：

 

具体代码如下：

User.java

package com.example.mybatisdemo.bean;

import java.io.Serializable;

/**
 * @author 
 * @date 2019/11/4 10:46
 */
public class User implements Serializable {

    private static final long serialVersionUID = 1L;

    private int id ;
    private String loginName ;
    private String username ;
    private String password;

    public int getId() {
        return id;
    }

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

    public String getLoginName() {
        return loginName;
    }

    public void setLoginName(String loginName) {
        this.loginName = loginName;
    }

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

UserController.java

package com.example.mybatisdemo.controller;

import com.example.mybatisdemo.bean.User;
import com.example.mybatisdemo.service.UserService;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author 
 * @date 2019/11/4 11:09
 */
@RestController
@RequestMapping("/user")
public class UserController {

    @Resource
    private UserService userService;

    @RequestMapping("/insertUser")
    public String insertUser(User user){
        return "插入数据["+userService.insertUser(user)+"]条";
    }

    @RequestMapping("/insertGetKey")
    public User insertGetKey(User user) {
        userService.insertGetKey(user);
        return user ;
    }

    @RequestMapping("/selectByUsername")
    public User selectByUsername(String username){
        return userService.selectByUsername(username);
    }

    @RequestMapping("/findAll")
    public List<User> findAll(){
        return userService.findAll();
    }

    @RequestMapping("/update")
    public void update(User user) {
        userService.update(user);
    }

    @RequestMapping("/delete")
    public void delete(Integer id) {
        userService.delete(id);
    }

}

UserRepository.java

package com.example.mybatisdemo.repository;

import com.example.mybatisdemo.bean.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

/**
 * @author 
 * @date 2019/11/4 10:47
 */
public interface UserRepository {
    @Insert("insert into tb_user(loginName,username,password)"
    +" values(#{loginName},#{username},#{password})")
    public int insertUser(User user);

    /**
     * 插入数据获取主键
     */
    @Insert("insert into tb_user(loginName ,username ,password) "
            + "values (#{loginName},#{username},#{password})")
    @Options(useGeneratedKeys=true,keyProperty="id",keyColumn="id")
    public void insertGetKey(User user);

@Select("select * from tb_user where username = #{username}")
@ResultMap("userResult")
public User selectByUsername(@Param("username") String username);


    @Select("select * from tb_user")
// @Results用于映射对象属性和数据库列，常用于对象属性和数据库列不同名情况
    @Results(id = "userResult",value = {
            @Result(id=true,column = "id",property = "id"),
            @Result(column = "loginName",property = "loginName"),
            @Result(column = "username",property = "username"),
            @Result(column = "password",property = "password")
    })
    public List<User> findAll();

    @Delete("delete from tb_user where id= #{id}")
    public void delete(final Integer id);


    @Select("select * from tb_user where id=#{id}")
    // 引用id="userResult"的@Results
    @ResultMap("userResult")
    public User findUserById(int id);

    @Update("update tb_user set username=#{username}, login_name=#{loginName} where id=#{id}")
    public void update(final User user);


}

UserService.java

package com.example.mybatisdemo.service;

import com.example.mybatisdemo.bean.User;
import com.example.mybatisdemo.repository.UserRepository;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.List;

/**
 * @author 
 * @date 2019/11/4 11:03
 */
@Service
public class UserService {
    @Resource
    private UserRepository userRepository;

    public int insertUser(User user){
        return userRepository.insertUser(user);
    }
    public User selectByUsername(String username){
        return userRepository.selectByUsername(username);
    }
    public List<User> findAll(){
        return userRepository.findAll();
    }
    public void insertGetKey(User user){
        // 数据插入成功以后，Mybatis框架会将插入成功的数据主键存入到user对象中去
        userRepository.insertGetKey(user);
    }

    public void update(User user) {
        userRepository.update(user);
    }

    public void delete(Integer id) {
        userRepository.delete(id);
    }

}

启动类

package com.example.mybatisdemo;

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

@SpringBootApplication
@MapperScan("com.example.mybatisdemo.repository")
public class MybatisdemoApplication {

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

}

application.properties

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
logging.level.org.springframework.security=info
logging.level.org.fkit.securitymybatistest.mapper.UserMapper=debug
spring.thymeleaf.cache=false

插入数据：

http://127.0.0.1:8080/user/insertUser?loginName=xm&username=小明&password=123456

等等。