springBoot整合Mybatis

来源：互联网发布：淘宝代运营的销售工作编辑：程序博客网时间：2024/05/16 04:41

添加依赖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":"张伟"}]

阅读全文

0 0