Mapper 开发

复杂的多表查询需在xml中手写SQL

接口

mapper 接口继承 BaseMapper 泛型为实体类

public interface SysAttachmentMapper extends BaseMapper<SysAttachment> {

    List<String> queryDeletablePathByIds(@Param("ids") List<String> ids);

    SysAttachmentVO queryById(@Param("id") String id);

}

XML

为保证Mapper层与Service层结构一致，将xml文件放置到了mapper包下

配置

新建模块请在启动类LiHuaApplication下@MapperScan 注解中新增对应mapper路径，防止扫描不到Mapper

@SpringBootApplication
@EnableAsync
@EnableAspectJAutoProxy(exposeProxy = true)
@MapperScan("com.lihua.**.mapper")
@ComponentScan("com.lihua.**")
public class LiHuaApplication {
    public static void main(String[] args) {
        SpringApplication.run(LiHuaApplication.class, args);
    }
}