gaussdb demo示例

1、部署gaussdb服务

docker pull --platform=linux/arm64 enmotech/opengauss:3.0.0

docker run -d -p 5432:5432 --privileged=true -e GS_PASSWORD=OpenGauss@123 --name gauss enmotech/opengauss:3.0.0

2、创建db、table，插入数据

3、简单示例

（1）依赖

dependencies {compile('org.springframework.boot:spring-boot-starter')compile('org.springframework.boot:spring-boot-starter-jdbc')compile('org.postgresql:postgresql:42.6.0')compileOnly('org.projectlombok:lombok')
}

（2）配置文件信息

spring.datasource.url=jdbc:postgresql://172.17.42.16:5432/testdb
spring.datasource.username=gaussdb
spring.datasource.password=OpenGauss@123
spring.datasource.driver-class-name=org.postgresql.Driver
spring.datasource.hikari.maximum-pool-size=10
spring.datasource.hikari.minimum-idle=5
spring.datasource.hikari.idle-timeout=30000
spring.datasource.hikari.connection-timeout=20000

（2）Service服务

public class UserService {@Autowiredprivate JdbcTemplate jdbcTemplate;public List<Map<String, Object>> find() {String sql = "SELECT * FROM sv_user limit 0,1";log.info("sql:{}", sql);return jdbcTemplate.queryForList(sql);}public List<Map<String, Object>> group() {String sql = "SELECT name FROM sv_user GROUP BY name";log.info("sql:{}", sql);return jdbcTemplate.queryForList(sql);}}

（3）main方法

List<Map<String, Object>> find= userService.find();
log.info("find:{}", find);
List<Map<String, Object>> group= userService.group();
log.info("group:{}", group);

（4）运行结果

2025-07-30 11:04:44 [main] INFO  cn.ac.trimps.UserService - sql:SELECT * FROM sv_user limit 0,1 
2025-07-30 11:04:44 [main] INFO  cn.ac.trimps.Application - find:[{id=1, name=tom, age=3, birth=2022-02-02}] 
2025-07-30 11:04:44 [main] INFO  cn.ac.trimps.UserService - sql:SELECT name FROM sv_user GROUP BY name 
2025-07-30 11:04:44 [main] INFO  cn.ac.trimps.Application - group:[{name=tom}, {name=jerry}]