SpringBoot整合Mybatis

1.导入Mybatis的起步依赖

    <dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.1.1</version>
    </dependency>

2.创建实体类，生成get和set
SpringBoot整合Mybatis
3.创建Mapper接口和mapper.xml放在同一个包下

public interface UserMapper {

    List<User> findAll();

    User findById(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="cn.itcast.mapper.UserMapper">
        <select id="findAll" resultType="cn.itcast.domain.User">
            select * from t_user
        </select>
        <select id="findById" resultType="cn.itcast.domain.User">
            select * from t_user WHERE id = #{id}
        </select>
    </mapper>

4.注意要修改maven文件配置,不然找不到mapper.xml文件,在启动类上配置包扫描
SpringBoot整合Mybatis 5.写一个controller类浏览器访问进行测试

@Controller
@RequestMapping("/user2")
public class User2Controller {
    @Autowired
    private UserMapper userMapper;

    @RequestMapping
    public String findAll(Model model){

        List<User> list = userMapper.findAll();

        model.addAttribute("list",list);

        return  "user";
    }

    @RequestMapping("/{id}")
    @ResponseBody
    public User findById(@PathVariable Integer id) {
        return userMapper.findById(id);
    }
}

SpringBoot整合Mybatis

SpringBoot整合Mybatis

相关推荐