MyBatis-plus连接OpenGauss

1.开启数据库

查看数据库内容

2.项目依赖

（在a,b,c中任选一种方式即可）
a.在Spring Initializr中勾选PostgreSQL Driver

b.或者直接在pom中添加依赖：

    <dependency>
      <groupId>org.postgresql</groupId>
      <artifactId>postgresql</artifactId>
      <scope>runtime</scope>
    </dependency>

c.或者直接导入jar包：
postgresql.jar

另外然后我是用的是MyBatis-plus，
所以在pom中添加

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

3.代码结构

目录结构：

写配置类MyBatisPlusConfig

package com.example.demo.common;

import com.baomidou.mybatisplus.annotation.DbType;
import com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor;
import com.baomidou.mybatisplus.extension.plugins.inner.PaginationInnerInterceptor;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

@Configuration
@MapperScan("com.example.demo.mapper")
public class MyBatisPlusConfig {
    @Bean
    public MybatisPlusInterceptor mybatisPlusInterceptor() {
        MybatisPlusInterceptor interceptor = new MybatisPlusInterceptor();
        interceptor.addInnerInterceptor(new PaginationInnerInterceptor(DbType.GAUSS));
        return interceptor;
    }
}

配置文件application.yml

spring:
  datasource:
    url: jdbc:postgresql://192.168.99.131:26000/db1?serverTimezone=UTC
    username: root
    password: "gauss@123"
    driver-class-name: org.postgresql.Driver

实体类Course

package com.example.demo.entity;

import com.baomidou.mybatisplus.annotation.TableName;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;


@TableName("course")
@Data
@NoArgsConstructor
@AllArgsConstructor
public class Course {
    private String cno;
    private String cname;
    private String ctype;
    private String cpno;
    private String ccredit;
}

mapper层

package com.example.demo.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.entity.Course;

public interface CourseMapper extends BaseMapper<Course> {
}

controller层

package com.example.demo.Controller;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.example.demo.entity.Course;
import com.example.demo.mapper.CourseMapper;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.util.List;

@RestController
@RequestMapping("/course")
public class CourseController {
    @Resource
    private CourseMapper courseMapper;
    @GetMapping
    public List<Course> findPage(){
        LambdaQueryWrapper<Course> wrapper = Wrappers.<Course>lambdaQuery();
        List<Course> courses = courseMapper.selectList(wrapper);
        return courses;
    }
}

然后运行程序，即可在接口处获取数据：