前端小白springboot-mybatisplus-postgresql接口开发记录

1.建立springboot工程

2.引入依赖pom.xml

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

<dependency>
    <groupId>com.baomidou</groupId>
    <artifactId>mybatis-plus-generator</artifactId>
    <version>3.3.2</version>
</dependency>

<dependency>
    <groupId>org.apache.velocity</groupId>
    <artifactId>velocity</artifactId>
    <version>1.7</version>
</dependency>

3.配置application.properties

spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.username=用户名
spring.datasource.password=密码
spring.datasource.url=jdbc:postgresql://localhost:5432/数据库名称

server.port=9090端口号

4.代码自动生成

package com.example.demo;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.generator.AutoGenerator;
import com.baomidou.mybatisplus.generator.config.DataSourceConfig;
import com.baomidou.mybatisplus.generator.config.GlobalConfig;
import com.baomidou.mybatisplus.generator.config.PackageConfig;
import com.baomidou.mybatisplus.generator.config.StrategyConfig;
import com.baomidou.mybatisplus.generator.config.rules.NamingStrategy;

public class GenerateTest {
    public static void main(String[] args) {
        //创建generator对象
        AutoGenerator autoGenerator = new AutoGenerator();
        //数据源
        DataSourceConfig dataSourceConfig = new DataSourceConfig();
        dataSourceConfig.setDbType(DbType.POSTGRE_SQL);
        dataSourceConfig.setDriverName("org.postgresql.Driver");
        dataSourceConfig.setUsername("");//需要更改
        dataSourceConfig.setPassword("");//需要更改
        dataSourceConfig.setUrl("");//需要更改
        autoGenerator.setDataSource(dataSourceConfig);
        //全局配置
        GlobalConfig globalConfig = new GlobalConfig();
        globalConfig.setOutputDir(System.getProperty("user.dir")+"/src/main/java");
        globalConfig.setAuthor("");//需要更改，作者名字
        globalConfig.setOpen(false);
        globalConfig.setServiceName("%sService");
        autoGenerator.setGlobalConfig(globalConfig);
        //包信息
        PackageConfig packageConfig = new PackageConfig();
        packageConfig.setParent("com.example.demo");//需要更改
        packageConfig.setEntity("entity");
        packageConfig.setMapper("mapper");
        packageConfig.setService("service");
        packageConfig.setServiceImpl("service.impl");
        packageConfig.setController("controller");
        autoGenerator.setPackageInfo(packageConfig);
        //策略配置
        StrategyConfig strategyConfig = new StrategyConfig();
        strategyConfig.setInclude("gd_point");//需要更改，表名
        strategyConfig.setNaming(NamingStrategy.underline_to_camel);
        strategyConfig.setColumnNaming(NamingStrategy.underline_to_camel);
        strategyConfig.setEntityLombokModel(true);
        autoGenerator.setStrategy(strategyConfig);
        //运行
        autoGenerator.execute();
    }
}

运行成功后

5.入口类配置mappscan

6.controller 查所有

注意要改成restcontroller

//@Controller
@RestController
@RequestMapping("//gdPoint")
public class GdPointController {
    @Autowired
    private GdPointService gdPointService;

    @GetMapping("/list")
    public List<GdPoint> list(){
        return this.gdPointService.list();
    }
}

7. 问题

nested exception is org.postgresql.util.PSQLException: 不良的类型值 int

解决方法：将entity 中的geom字段从 integer 改成 string

8.打开浏览器可以访问