本样例代码适用于GBaseJDBC8.3.81.53 及以上版本。
package com.gbase.jdbc.simple;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class SampleAutoTransHost {
static String dbUrl =
"jdbc:gbase://192.168.2.136:5258/test?user=root&password=root&useUnicode=true&characterEncodin
g=utf8&failoverEnable=true&hostList=192.168.2.138,192.168.2.139";
public static void main(String[] args) {
Connection conn = null;
Statement stm = null;
ResultSet rs = null;
try {
Class.forName("com.gbase.jdbc.Driver");
conn = DriverManager.getConnection(dbUrl);
stm = conn.createStatement();
rs = stm.executeQuery("select 1");
rs.next();
System.out.println(rs.getObject(1));
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
} finally {
if (rs != null) {
try {
rs.close();
GBase UP 产品手册 6 应用开发指南
文档版本04(2021-04-21) 南大通用数据技术股份有限公司 1115
} catch (SQLException e) {
}
}
if (stm != null) {
try {
stm.close();
} catch (SQLException e) {
}
}
if (conn != null) {
try {
conn.close();
} catch (SQLException e) {
}
}
}
}
}