项目结构

一、Java代码

pom.xml

      4.0.0      org.example     jdservice     1.0-SNAPSHOT               8         8         UTF-8                                org.springframework.boot             spring-boot-starter-web             2.0.3.RELEASE                               org.springframework.boot             spring-boot-starter             2.0.3.RELEASE                                        org.postgresql             postgresql             42.6.0                               org.projectlombok             lombok             1.18.12                                        com.baomidou             mybatis-plus-boot-starter             3.1.0                 

controller层

package org.example.jd.controller;  import org.example.jd.pojo.TUser; import org.example.jd.service.TUserService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*;  import java.util.List;  @CrossOrigin(origins = "http://localhost:8080") @RestController public class UserController {      @Autowired     private TUserService tUserService;      @PostMapping("/api/userLogin")     public String login(@RequestBody TUser tUser) {         // 实际业务逻辑处理         String username = tUser.getUsername();         String password = tUser.getPassword();          // 这里可以进行用户名密码验证等操作         System.out.println("========Login successful=====");         System.out.println(username + "," + password);         return "Login successful"; // 返回登录成功信息或者其他响应     }      @GetMapping("/api/getUserList")     public List getUserList() {         List tUserList = tUserService.getUserList();         return tUserList;     }   } 

mapper层

package org.example.jd.mapper;  import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.example.jd.pojo.TUser;  public interface TUserMapper extends BaseMapper { //参数为实体类  }

pojo层

package org.example.jd.pojo;  import com.baomidou.mybatisplus.annotation.TableId; import com.baomidou.mybatisplus.annotation.TableName; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor;  import java.time.LocalDate;  @Data @AllArgsConstructor @NoArgsConstructor @TableName("tuser")   //指定数据库表 public class TUser {     @TableId(value = "uid") //指定主键     private int uid;     private String username;     private String password;     private int age;     private String gender;     private LocalDate birthday;     private String address; } 

service层

TUserService 

package org.example.jd.service;  import org.example.jd.pojo.TUser;  import java.util.List;  public interface TUserService {     List getUserList(); } 

TUserServiceImp 

package org.example.jd.service;  import org.example.jd.mapper.TUserMapper; import org.example.jd.pojo.TUser; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service;  import java.util.List;  @Service public class TUserServiceImp implements TUserService {      @Autowired     private TUserMapper tUserMapper;     @Override     public List getUserList() {         return tUserMapper.selectList(null);     } }

Application启动类

package org.example.jd;  import org.mybatis.spring.annotation.MapperScan; import org.springframework.boot.SpringApplication; import org.springframework.boot.autoconfigure.SpringBootApplication;  @SpringBootApplication @MapperScan("org.example.jd.mapper") //扫描mapper层 public class Application {     public static void main(String[] args) {         SpringApplication.run(Application.class, args);     } } 

TUserMapper.xml

mybatis-config.xml

application.yml配置文件

server:   port: 8090 spring:   datasource:     url: jdbc:postgresql://localhost:5432/myjd     username: postgres     password: 123456     driver-class-name: org.postgresql.Driver   #设置mybatis-plus mybatis-plus:   config-location: classpath:mybatis/mybatis-config.xml  #配置文件   mapper-locations: classpath:mybatis/mapper/*.xml  #设置mapper层对应的接口对应的mapper.xml的路径   type-aliases-package: org.example.jd.pojo  #设置别名，mapper.xml中resultType="org.example.jd.pojo.TUser"可省去包，即resultType="TUser"   #开启自动驼峰映射，注意：配置configuration.map-underscore-to-camel-case则不能配置config-location，可写到mybatis-config.xml中 #  configuration: #    map-underscore-to-camel-case: true

二、SQL

/*  Navicat Premium Data Transfer   Source Server         : myPgSQL  Source Server Type    : PostgreSQL  Source Server Version : 160003 (160003)  Source Host           : localhost:5432  Source Catalog        : myjd  Source Schema         : public   Target Server Type    : PostgreSQL  Target Server Version : 160003 (160003)  File Encoding         : 65001   Date: 19/07/2024 22:15:18 */   -- ---------------------------- -- Table structure for tuser -- ---------------------------- DROP TABLE IF EXISTS "public"."tuser"; CREATE TABLE "public"."tuser" (   "uid" int4 NOT NULL,   "username" varchar(255) COLLATE "pg_catalog"."default",   "age" int4,   "gender" varchar(1) COLLATE "pg_catalog"."default",   "birthday" date,   "address" varchar(255) COLLATE "pg_catalog"."default",   "password" varchar(255) COLLATE "pg_catalog"."default" ) ;  -- ---------------------------- -- Records of tuser -- ---------------------------- INSERT INTO "public"."tuser" VALUES (1, 'jack', 24, '男', '2021-10-19', '深圳', '123');  -- ---------------------------- -- Primary Key structure for table tuser -- ---------------------------- ALTER TABLE "public"."tuser" ADD CONSTRAINT "user_pkey" PRIMARY KEY ("uid"); 

三、运行

浏览器或者postman请求地址。

注意：浏览器只能测试get请求，如果有put、post、delete请使用postman测试。

http://localhost:8090/api/getUserList