# Java连接示例

import java.sql.*;

public class YashanDBConnection {
public static void main(String[] args) {
String url = “jdbc:yashandb://192.168.1.100:5432/fgedudb”;
String user = “fgedu”;
String password = “fgedu123”;

try {
Connection conn = DriverManager.getConnection(url, user, password);
System.out.println(“Connected to YashanDB successfully!”);

Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(“SELECT version()”);

while (rs.next()) {
System.out.println(rs.getString(1));
}

conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}

Connected to YashanDB successfully!
YashanDB 23.4.0 on x86_64-pc-linux-gnu

3.2 ODBC连接配置

BI工具集成ODBC连接配置：