SpringBoot整合mybatis

第一步：创建一个SpringBoot工程

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-thymeleaf</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-devtools</artifactId>
            <scope>runtime</scope>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.8</version>
            <scope>runtime</scope>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.4</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
    </dependencies>

    <build>
        <plugins>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <configuration>
                    <excludes>
                        <exclude>
                            <groupId>org.projectlombok</groupId>
                            <artifactId>lombok</artifactId>
                        </exclude>
                    </excludes>
                </configuration>
            </plugin>
        </plugins>
    </build>

第二步：完成相关配置

建议直接复制修改，防止写错误

#修改端口号
server:
  port: 80

#数据库相关配置
spring:
  datasource:
    driver-class-name: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/mybatis
    password: root
    username: root


#mybatis相关配置
#配置mybatis相关的配置

mybatis:
  mapper-locations: classpath:mybatis/mapper/*.xml
  configuration:
    map-underscore-to-camel-case: true #开启驼峰命名
  type-aliases-package: com.hiakang.springboot_mybatis.pojo

创建POJO实体

@Data
@ToString
@NoArgsConstructor
@AllArgsConstructor
public class User {
    private Integer id;
    private String username;
    private String password;
    private Integer age;
    private String sex;
    private String email;
}

第三步：编写Mapper层

第一小步：编写`Mapper`接口

@Mapper
public interface UserMapper {
    // 根据用户名查询用户信息
    User getUserByUserName(@Param("username") String username);

    // 根据用户Id查询用户信息
    User getUserById(@Param("id") Integer id);
}

第二小步：编写Mapper.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.hiakang.springboot_mybatis.mapper.UserMapper">
<!--
    // 根据用户名查询用户信息
    User getUserByUserName(@Param("username") String username);
-->

    <select id="getUserByUserName" resultType="User">
        select * from t_user where username=#{username};
    </select>

    <!--
        // 根据用户Id查询用户信息
        User getUserById(@Param("id") Integer id);
    -->
    <select id="getUserById" resultType="User">
        select * from t_user where id=#{id};
    </select>
</mapper>

注意是：在resources目录下文件是文件夹的方式存放的，并不是以包的形式，所以在创建时，一定要以/的方式分隔，不能以.方式，包的方式才能以.方式

第三步：创建service层

第一小步：`service`接口

public interface UserService {
    // 根据用户名查询用户信息
    User getUserByUserName(@Param("username") String username);

    // 根据用户Id查询用户信息
    User getUserById(@Param("id") Integer id);
}

第二小步：service实现类

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper userMapper;

    @Override
    public User getUserByUserName(String username) {
        return userMapper.getUserByUserName(username);
    }

    @Override
    public User getUserById(Integer id) {
        return userMapper.getUserById(id);
    }
}

第四步：创建controller层

@RestController
public class TestController {

    @Autowired
    private UserService userService;

    @RequestMapping("/hello")
    public String hello(){
        return "Hello 欢迎来到SpringBoot_MyBatis整合";
    }

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

    @RequestMapping("/id")
    public User userById(Integer id){
        return userService.getUserById(id);
    }
}

测试结果如下 ：