SpringBoot整合Mybatis+Postgresql

第一步：配置文件（application.yml）

server:
  port: 8081
spring:
  datasource:
    url: jdbc:postgresql://localhost:5432/STBCSystem
    username: postgres
    password: 123
    driver-class-name: org.postgresql.Driver
mybatis:
  mapperLocations: classpath:mapper/*.xml
  typeAliasesPackage: tk.mapper.model

第二步：控制层（controller）

@RestController
public class DemoController {
    @Resource
    private DictService dictService;

    @RequestMapping("list")
    public List<Dict> list(){
        return dictService.list();
    }
}

第三步：Service层

public interface DictService {

    List<Dict> list();
}

@Component
@Transactional
public class DictServiceImpl implements DictService {

    @Resource
    private DictMapper dictMapper;

    @Override
    public List<Dict> list() {
        return dictMapper.list();
    }
}

第四步：实体类（entity）

public class Dict {
    private Integer ID;
    private String NAME;
    private String FORM;

    public Integer getID() {
        return ID;
    }

    public void setID(Integer ID) {
        this.ID = ID;
    }

    public String getNAME() {
        return NAME;
    }

    public void setNAME(String NAME) {
        this.NAME = NAME;
    }

    public String getFORM() {
        return FORM;
    }

    public void setFORM(String FORM) {
        this.FORM = FORM;
    }
}

第五步：Dao层

public interface DictMapper {

    List<Dict> list();
}

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.example.demo.dao.DictMapper">

    <select id="list" resultType="com.example.demo.entity.Dict">
        select * from dict
    </select>
</mapper>

第六步：接口测试