dependencies {
    //mybatis-plus
    implementation 'com.baomidou:mybatis-plus-boot-starter:3.5.2'

    implementation 'org.springframework.boot:spring-boot-starter-jdbc'
    implementation 'org.springframework.boot:spring-boot-starter-web'
    runtimeOnly 'org.postgresql:postgresql'
    testImplementation 'org.springframework.boot:spring-boot-starter-test'
}

spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.url=jdbc:postgresql://xx.xx.xx.xx:8000/database?currentSchema=traffic_data
spring.datasource.username=dbadmin
spring.datasource.password=xxxxxx

CREATE TABLE "traffic_data"."customer" (
"id" int4,
"c_customer_sk" int4,
"c_customer_name" varchar(32)
);

package com.zz.testdws.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;

/**
 * <p>
 * 
 * </p>
 *
 * @author zzzili
 * @since 2023-02-16
 */
public class customer  {

    private static final long serialVersionUID = 1L;

    @TableId(value = "id", type = IdType.AUTO)
    private Integer id;

    private Integer cCustomerSk;

    private String cCustomerName;

    @Override
    public String toString() {
        return "customer{" +
                "id=" + id +
                ", cCustomerSk=" + cCustomerSk +
                ", cCustomerName='" + cCustomerName + '\'' +
                '}';
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public Integer getcCustomerSk() {
        return cCustomerSk;
    }

    public void setcCustomerSk(Integer cCustomerSk) {
        this.cCustomerSk = cCustomerSk;
    }

    public String getcCustomerName() {
        return cCustomerName;
    }

    public void setcCustomerName(String cCustomerName) {
        this.cCustomerName = cCustomerName;
    }
}
package com.zz.testdws.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.zz.testdws.entity.customer;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author zzzili
 * @since 2023-02-15
 */
public interface CustomerMapper extends BaseMapper<customer> {
}

package com.zz.testdws;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
@MapperScan("com.zz.testdws.mapper")
public class TestDwsSpringBootApplication {
    public static void main(String[] args) {
        SpringApplication.run(TestDwsSpringBootApplication.class, args);
    }
}

 @Autowired
    DataSource dataSource;

    @Test
    void testDoSQL() throws SQLException {
        System.out.println(dataSource.getClass());

        //获取连接
        Connection con =  dataSource.getConnection();
        //调用Connection的createStatement方法创建语句对象
        Statement stmt = con.createStatement();
        //调用Statement的executeUpdate方法执行SQL语句
        //int rc = stmt.executeUpdate("CREATE TABLE customer_t1(c_customer_sk INTEGER, c_customer_name VARCHAR(32));");
        //System.out.println("rc = " + rc);

        //int rc = stmt.executeUpdate("INSERT INTO customer_t1(c_customer_sk,c_customer_name) values('1001','zhangsan');");
        //System.out.println("insert rc = " + rc);

        //查询数据
        ResultSet rs= stmt.executeQuery("select * from customer_t1");
        //遍历数据
        while(rs.next()){
            String sk = rs.getString("c_customer_sk");
            String name = rs.getString("c_customer_name");
            System.out.println("sk:"+sk+" 姓名："+name);
        }

        con.close();
    }

    @Autowired
    CustomerMapper customerMapper;

    @Test
    void testMybatis(){
        //增加
        customer cus=new customer();
        cus.setcCustomerName("zzzili");
        cus.setcCustomerSk(123456);
        cus.setId(8);
        customerMapper.insert(cus);
        //改
        cus.setcCustomerSk(66666);
        customerMapper.updateById(cus);

        //查
        List<customer> list = customerMapper.selectList(null);
        System.out.println("list size="+list.size());
        for(customer node :list){
            System.out.println(node);
        }

        //删除
        customerMapper.deleteById(1);

    }