Spring boot集成Mybatis

1.先创建一个string boot项目

2.写好项目名包名 选择好java版本 点击Next  勾选在web下的Spring Web(Spring Mvc)

 3.Mybatis 整合

将版本改为  2.1.3.RELEASE

在pom.xml中添加依赖

         
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            2.1.1
        
        
            mysql
            mysql-connector-java
            runtime
        

4.刷新maven后 在resources下添加配置文件 application.yml 

spring:
  datasource:
    url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&serverTimezone=CTT
    username: root  #数据库账户
    password: root  #数据库密码
    driver-class-name: com.mysql.cj.jdbc.Driver
mybatis:
  mapper-locations: classpath:mapper/*.xml  #对应mapper映射xml文件所在路径
  type-aliases-package: com.xxxx.entity  #对应实体类路径

 5. 接下来连接数据库  在配置文件中写入数据库的地址和数据库名 集成Mybatis就完成

 6.进行测试

UserMapper.xml 文件

    
        select * from user
    

 User文件

package com.test.demo.entity;
public class User {
    private Integer id;
    private String name;
    private Integer age;

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + ''' +
                ", age=" + age +
                '}';
    }

    public Integer getId() {
        return id;
    }

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

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }
}

 UserMapper文件

package com.test.demo.mapper;
import com.test.demo.entity.User;
import java.util.List;
public interface UserMapper {
    List listAll();
}

UserController文件

package com.test.demo.controller;
import com.test.demo.entity.User;
import com.test.demo.mapper.UserMapper;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import javax.annotation.Resource;
import java.util.List;
@Controller
public class UserController {
    @Resource
    private UserMapper userMapper;

    @RequestMapping("listAll")
    @ResponseBody
    public List listAll(){
        return userMapper.listAll();
    }
}

查询 数据库为test的user表数据