springboot整合mybatis

1.导入mybatis的依赖

 <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.3.0</version>
        </dependency>
    </dependencies>

2.在application.properties中加入配置

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/news?useUnicode=true&characterEncoding=utf8&userSSL=false&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=123456
//扫描资源目录（resouerce）下的mappers文件夹下的所有xml
mybatis.mapperLocations=classpath:mappers/*.xml

3.在资源目录下创建mappers文件夹，并在mappers下创建mapper.xml
以下为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.stj.book.Dao.UserDao">

    <!-- 可根据自己的需求，type是bean的路径，id是自定义的，便于操作 -->
    <resultMap type="com.stj.book.Bean.User" id="User">
        <id column="u_id" property="u_id" jdbcType="INTEGER" />
        <result column="u_name" property="u_name" jdbcType="VARCHAR" />
        <result column="u_password" property="u_password" jdbcType="VARCHAR" />
        <result column="u_number" property="u_number" jdbcType="VARCHAR" />
    </resultMap>
       <!-- Dao接口的方法 -->
    <select id="selectAll"  resultMap="User">
        select *
        from user
    </select>
</mapper>

4.项目代码
Bean类

   package com.stj.book.Bean;
   //具体的set，get自己生成，数据库和这个一样
public class User {
    private int u_id;
    private String u_name;
    private String u_password;
    private String u_number;
    }

Dao类

@Repository
@Mapper
public interface UserDao {
    List<User> selectAll();//查找所有的信息
}

Service类和接口
类

@Service
public class UserIpl implements UserService {
    @Autowired
    private UserDao userDao ;
    @Override
    public List<User> selectAll() {
          return userDao.selectAll();
    }
}

接口

public interface UserService {
    List<User> selectAll();
}

Controller类

@RestController
public class UserController {
    @Autowired
    private UserService service1;
    @GetMapping("/getalluser")
    public List<User> getAllUser(){
        return service1.selectAll();
    }
}

主类

@SpringBootApplication(scanBasePackages={"com.stj.book.*"})
@MapperScan("com.stj.book.Dao")
public class BookApplication {

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

}

项目结构