★ JDBC獲取
https://opengauss.org/zh/download/★ 環(huán)境信息
? 數(shù)據(jù)庫(kù)版本：openGauss 5.0.0
? 數(shù)據(jù)庫(kù)端口：5432
? 數(shù)據(jù)庫(kù)名稱：db_zzt
? Java版本：JDK1.8★ Java代碼
package PAC_001;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class C_O {
public static void main(String[] args) {
// 創(chuàng)建數(shù)據(jù)庫(kù)連接。
Connection conn = GetConnection("zzt", "PASSWORD");
// 執(zhí)行預(yù)編譯語(yǔ)句，查詢數(shù)據(jù)
SelectPreparedSQL(conn);
// 關(guān)閉數(shù)據(jù)庫(kù)連接。
try {
conn.close();
System.out.println("Disconnect succeed!");
} catch (SQLException e) {
e.printStackTrace();
}
}
public static Connection GetConnection(String username, String passwd) {
String driver = "org.postgresql.Driver";
String sourceURL = "jdbc:postgresql://1.1.1.9:5432/db_zzt";
Connection conn = null;
try {
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
return null;
}
try {
conn = DriverManager.getConnection(sourceURL, username, passwd);
System.out.println("Connection succeed!");
} catch (Exception e) {
e.printStackTrace();
return null;
}
return conn;
};
public static void SelectPreparedSQL(Connection conn) {
PreparedStatement pstmt = null;
try {
String sql;
sql = "SELECT empno,ename FROM zzt.emp";
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
while (rs.next()) {
int id = rs.getInt("empno");
String name = rs.getString("ename");
System.out.print("ID: " + id);
System.out.print(", NAME: " + name);
System.out.print("\n");
}
System.out.println("Select table succeed!");
rs.close();
pstmt.close();
} catch (SQLException e) {
if (pstmt != null) {
try {
pstmt.close();
} catch (SQLException e1) {
e1.printStackTrace();
}
}
e.printStackTrace();
}
}
}※ 如果您覺(jué)得文章寫(xiě)的還不錯(cuò)，?別忘了在文末給作者點(diǎn)個(gè)贊哦 ~文章來(lái)源：http://www.zghlxwxcb.cn/news/detail-642782.html
文章來(lái)源地址http://www.zghlxwxcb.cn/news/detail-642782.html
到了這里，關(guān)于GaussDB 開(kāi)發(fā)篇+Java調(diào)用JDBC訪問(wèn)openGauss數(shù)據(jù)庫(kù)的文章就介紹完了。如果您還想了解更多內(nèi)容，請(qǐng)?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
