mybatis的配置

1.pom.xml的配置

<dependency>
     <groupId>com.baomidou</groupId>
     <artifactId>mybatis-plus-boot-starter</artifactId>
     <version>3.4.3.3</version>
</dependency>

2.编写repository和xml

DeviceDictionaryRepository.java

public interface DeviceDictionaryRepository extends BaseMapper<DeviceDictionaryDAO> {

    /**
     * 查询数据库所有值
     * @return
     */
    List<DeviceDictionaryDAO> queryAll();

}

DeviceDictionaryMapper.xml（注意修改namespace和resultMap中的type）

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.example.modules.repository.DeviceDictionaryRepository">

    <resultMap type="org.example.modules.repository.entity.DeviceDictionaryDAO" id="deviceDictionaryMap">
        <id column="id" property="id"/>
        <id column="type_code" property="typeCode"/>
        <id column="dict_name" property="dictName"/>
    </resultMap>

    <select id = "queryAll" resultMap="deviceDictionaryMap">
        select id,type_code,dict_name from device_dict_item
    </select>

</mapper>

3.在启动类上配置@MapperScan

@SpringBootApplication(scanBasePackages = {"com.hikvision.ga.common.boot", "org.example"})
@MapperScan({"mapper","org.example.modules.repository"})
public class Bootstrap {
  
  public static void main(String[] args) {
    SpringApplication.run(Bootstrap.class, args);
  }

}