用Mybatis-Plus插件生成代码遇到的坑

1、报错Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘XXXServiceImpl’: Unsatisfied dependency expressed through field ‘baseMapper’;

​

原因：因为缺少扫描mapper注解

解决方式（任选其一即可）

1、在启动类添加扫描mapper的注解（参数为你的mapper的路径）

@MapperScan("com.hyt.mybatis_plus.hikcamera.mapper")//扫描mapper文件夹
@SpringBootApplication
public class MybatisPlusApplication {

    public static void main(String[] args) {
        SpringApplication.run(MybatisPlusApplication.class, args);
        System.out.println("启动成功");
    }

}

2、在mapper添加@Mapper注解

@Mapper
public interface HikCameraSearchMapper extends BaseMapper<HikCameraSearch> {

}

2、sql字段不匹配报错Cause: java.sql.SQLSyntaxErrorException: Unknown column ‘index_code’ in ‘field list’; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: Unknown column ‘index_code’ in ‘field list’

原因:因为驼峰命名会让字段转换的时候出现下划线

解决方法：在属性名上加上@TableField(“数据库表中对应的字段名”)注解

@TableField("indexCode")
private String indexCode;