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>

第六步:接口测试

SpringBoot整合Mybatis+Postgresql

版权声明:玥玥 发表于 2021-05-15 17:44:20。
转载请注明:SpringBoot整合Mybatis+Postgresql | 女黑客导航