postgreSQL 连接数据库的5种方式

groovy 使用jdbc驱动程序链接posgresql

jdbc连接数据库的5种方式：https://blog.csdn.net/m0_46394255/article/details/121350172

===========example1===============================
1. 在groovy 脚本中打印classpath路径(将)：
println(System.getProperty("java.class.path"))
比如打印出/usr/share/groovy/lib/groovy-2.4.17.jar
2. 将下载的postgresql jdbc驱动放到classpath路径下
sudo cp postgresql-9.4-1205.jdbc42.jar /usr/share/groovy/lib/

3. 使用jdbc连接数据库：
import java.sql.*;
import groovy.sql.Sql
def connectionString = "jdbc:postgresql://10.15.2.16:5432/testdb"
// jdbc:mysql://localhost/db?useUnicode=true&characterEncoding=UTF-8' //
def username = "test"
def password = "mypwd123"
def driver = "org.postgresql.Driver"
def sqlInstance = Sql.newInstance(connectionString, username, password, driver)
// 查询第一条数据
def firstRow = sqlInstance.firstRow("select * from author limit 5")
print firstRow

 

==============================example 2======================
import java.sql.Driver
import groovy.sql.Sql

def driver = Class.forName('org.postgresql.Driver').newInstance() as Driver

def props = new Properties()
props.setProperty("user", "test")
props.setProperty("password", "mypwd123")

def conn = driver.connect("jdbc:postgresql:///10.15.2.16:5432/testdb", props)
def sql = new Sql(conn)

try {
def first = sql.firstRow('SELECT * FROM author')
println(first)
} finally {
sql.close()
conn.close()
}

==============================example 3======================

export PGPASSWORD=test123
psql -h 10.118.3.11 -U test -d testdb -c "select 1 ;"

==============================example 4======================