<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd"><modelVersion>4.0.0</modelVersion><parent><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-parent</artifactId><version>2.6.7</version><relativePath/> <!-- lookup parent from repository --></parent><groupId>com.example</groupId><artifactId>demo4</artifactId><version>0.0.1-SNAPSHOT</version><name>demo4</name><description>demo4</description><properties><java.version>1.8</java.version></properties><dependencies><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-web</artifactId></dependency><dependency><groupId>org.mybatis.spring.boot</groupId><artifactId>mybatis-spring-boot-starter</artifactId><version>2.2.2</version></dependency><dependency><groupId>mysql</groupId><artifactId>mysql-connector-java</artifactId><scope>runtime</scope></dependency><dependency><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId><optional>true</optional></dependency><dependency><groupId>org.springframework.boot</groupId><artifactId>spring-boot-starter-test</artifactId><scope>test</scope></dependency><dependency><groupId>org.postgresql</groupId><artifactId>postgresql</artifactId><scope>runtime</scope></dependency></dependencies><build><plugins><plugin><groupId>org.springframework.boot</groupId><artifactId>spring-boot-maven-plugin</artifactId><configuration><excludes><exclude><groupId>org.projectlombok</groupId><artifactId>lombok</artifactId></exclude></excludes></configuration></plugin></plugins><resources><resource><directory>src/main/java</directory><includes><include>**/*.xml</include></includes><filtering>true</filtering></resource></resources></build></project>

項目pom所需的所有依賴

spring.datasource.username=dbuser spring.datasource.password=12345678 spring.datasource.driver-class-name=org.postgresql.Driver spring.datasource.url=jdbc:postgresql://localhost:12345/imag002 mybatis.type-aliases-package=com.example.demo.pojo mybatis.mapper-locations=classpath:mybatis/mapper/**.xml

首先在idea當中連接好我們服務器數據庫，連接成功后開始配數據庫文件

項目結構如圖所示，需要在application.properties當中設定好pojo包的別名，以及需要設置好mapper.xml文件掃描包

package com.example.demo.pojo;import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor;@Data @NoArgsConstructor @AllArgsConstructor public class Conference {private String name;private String author;private String conf_name;private String organizer;private String conf_dat;private String dat;private String employ; }

?pojo模塊，設置@data 和無參有參構造

package com.example.demo.mapper;import com.example.demo.pojo.Conference; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository;import java.util.List; @Mapper @Repository public interface ConferenceMapper {List<Conference> queryall(); }

然后這是mapper接口，我們這里只設置了一個求所有論文的方法

接下來我們需要寫一個xml來實現這個接口

package com.example.demo.mapper;import com.example.demo.pojo.Conference; import org.apache.ibatis.annotations.Mapper; import org.springframework.stereotype.Repository;import java.util.List; @Mapper @Repository public interface ConferenceMapper {List<Conference> queryall(); }

在resource文件夾下面 新建mybites.mapper

把xml文件放在該目錄下面

package com.example.demo.controller;import com.example.demo.mapper.ConferenceMapper; import com.example.demo.pojo.Conference; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.GetMapping; import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestController public class Controller {@AutowiredConferenceMapper conferenceMapper;@GetMapping("/honors")public List<Conference> getall(){return conferenceMapper.queryall();}

controller 記得注解 restcontroller? 然后getmapping?

?測試結果 ，完美！

另外，在連接數據庫時，要顯示所有表的步驟：

?

?

?

總結

以上是生活随笔為你收集整理的springboot+postsql 做接口api的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。