1.Java连接GaussDB

package com.gaussdb.demo;

import java.sql.Connection;
import java.sql.DriverManager;

public class JdbcGaussDBDemo {

    public static void main(String[] args) {

        //GaussDb JDBC的驱动
        String driverClass ="org.postgresql.Driver";
        String url= "jdbc:postgresql://192.168.3.177:15432/myschool";
        String username ="gaussdb";
        String password="Root@123";

        Connection conn = null;
        try{
            Class.forName(driverClass); //加载驱动
            //获得连接对象
            conn = DriverManager.getConnection(url,username,password);
            if(conn!=null){
                System.out.println("GaussDB连接成功！");
            }else{
                System.out.println("GaussDB连接失败！");
            }
        }catch(Exception ex){
            ex.printStackTrace();
        }
    }
}

2.python连接GaussDB

# -*- coding: utf-8 -*-
# @Time : 2022/5/25 15:38
# @File : gaussdb_demo.py
# @Software : PyCharm

import psycopg2

# 创建连接对象
conn = psycopg2.connect(database="myschool", user="gaussdb", password="Root@123", host="192.168.3.177", port="15432")
cur = conn.cursor()  # 创建指针对象
# 创建表
cur.execute("CREATE TABLE students(id integer,name varchar,gender varchar);")
# 插入数据
cur.execute("INSERT INTO students(id,name,gender) VALUES(%s,%s,%s)", (1, '张三', 'M'))
cur.execute("INSERT INTO students(id,name,gender) VALUES(%s,%s,%s)", (2, '李四', 'F'))
# 获取结果
cur.execute('SELECT * FROM students')
results = cur.fetchall()
print(results)
# 关闭连接
conn.commit()
cur.close()