springBoot整合Mybatis

添加依赖mybatis-spring-boot-starter

数据库mybatis-spring-boot-starter

配置文件键不能随意写 自动加载

spring.datasource.driverClassName=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/taotao
spring.datasource.username=root
spring.datasource.password=root

web层

@RestController
public class UserController {

    @Resource
    private UserService userService;

    @RequestMapping("/list/{username}")
    public List<User> list(@PathVariable String username) {
        List<User> users = userService.queryUsersByUserName(username);
        return users;
    }
}

业务层

@Service
public class UserServiceImpl implements UserService {

    @Resource
    private UserMapper userMapper;

    @Override
    public List<User> queryUsersByUserName(String username) {
        // TODO Auto-generated method stub
        List<User> list = userMapper.queryUsersByUserName(username);
        return list;
    }

}

dao层

@Mapper
public interface UserMapper {
    @Select("select * from user where user_name like '%${value}%'")

    public List<User> queryUsersByUserName(String username);
}

[{"id":1,"userName":null,"password":"123456","name":"张三"},{"id":4,"userName":null,"password":"123456","name":"张伟"}]