简单的springboot整合Mybatis

创建文件勾选这四项依赖就自动导入了

路径下创建这两个配置文件

application.yml

spring:

  profiles:

    active: dev

application-dve.yml

server:

  port: 8080



spring:

  datasource:

    username: root

    password: 123456

    url: jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC

    driver-class-name: com.mysql.jdbc.Driver

mybatis:  mapper-locations: classpath:mapping/*.xml 
 type-aliases-package: com.xyj.demo991.entity

CREATE TABLE `user` (  
`id` int(32) NOT NULL AUTO_INCREMENT, 
 `userName` varchar(32) NOT NULL, 
  `passWord` varchar(50) NOT NULL,  
  `realName` varchar(32) DEFAULT NULL, 
   PRIMARY KEY (`id`))
   ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

随便加几条数据

mapper.UserMapper 改成interface

import com.xyj.demo991.entity.User;
import org.apache.ibatis.annotations.Mapper;

@Mapper
public interface UserMapper {
    User Sel(int id);
}

entity.User 使用lombok注解的话更快 get set的话方便理解

public class User {
    private Integer id;

    private String userName;

    private String passWord;

    private String realName;

    public Integer getId() {
        return id;
    }

    public void setId(Integer 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;
    }

    public String getRealName() {
        return realName;
    }

    public void setRealName(String realName) {
        this.realName = realName;
    }
    @Override

    public String toString() {

        return "User{" +

                "id=" + id +

                ", userName='" + userName + '\'' +

                ", passWord='" + passWord + '\'' +

                ", realName='" + realName + '\'' +

                '}';

    }

controller.UserController

import com.xyj.demo991.service.UserService;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;

@RestController

@RequestMapping("/testBoot")
public class UserController {
@Resource
    private UserService userService;



    @RequestMapping("getUser/{id}")

    public String GetUser(@PathVariable int id){

        return userService.Sel(id).toString();

    }

service.UserService

import com.xyj.demo991.entity.User;
import com.xyj.demo991.mapper.UserMapper;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;

@Service
public class UserService {
    @Resource

    UserMapper userMapper;

    public User Sel(int id){

        return userMapper.Sel(id);

    }

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 namespace="com.xyj.demo991.mapper.UserMapper">


    <resultMap id="BaseResultMap" type="com.xyj.demo991.entity.User">

        <result column="id" jdbcType="INTEGER" property="id" />

        <result column="userName" jdbcType="VARCHAR" property="userName" />

        <result column="passWord" jdbcType="VARCHAR" property="passWord" />

        <result column="realName" jdbcType="VARCHAR" property="realName" />

    </resultMap>

    <select id="Sel" resultMap="BaseResultMap">

        select * from user where id = #{id}

    </select>

</mapper>

建好的效果图 然后运行 去浏览器输入路径

完成