介绍
很好用!单表操作全包直接用即可!
- 注解设置实体类和表字段命名转义规则
- 注解设置非表字段的处理
- 注解shsh
单表CRUD快速入门
引导类中添加注解,指定dao的包
@MapperScan(basePackages = {“com.changgou.dao”})
- 引入依赖
<!--通用mapper起步依赖-->
<dependency>
<groupId>tk.mybatis</groupId>
<artifactId>mapper-spring-boot-starter</artifactId>
<version>2.0.4</version>
</dependency>
- 对应实体类继承Mapper接口
import tk.mybatis.mapper.common.Mapper;
public interface BrandMapper extends Mapper<Brand> {
//自定义方法用于复杂查询
//将两个字段封装为map类型键为字段名,值为数据
@Select("SELECT name,image FROM tb_brand where id in( SELECT brand_id FROM tb_category_brand WHERE category_id in ( SELECT id from tb_category where name=#{categoryName}))")
public List<Map> findBrandListByCategoryName(@Param("categoryName")String categoryName);
}
- service层直接完成调用
@Service
public class BrandServiceImpl implements BrandService {
@Autowired
private BrandMapper brandMapper;
/**
* 查询全部列表
* @return
*/
@Override
public List<Brand> findAll() {
return brandMapper.selectAll();
}
/**
* 根据ID查询
* @param id
* @return
*/
@Override
public Brand findById(Integer id){
return brandMapper.selectByPrimaryKey(id);
}
/**
* 增加
* @pa