由 dawei 是否可以使用JDBC获取FK的目标？
我只使用getExportedKeys方法获得了源关系属性：
ResultSet fksE = dbm.getExportedKeys(conn.getCatalog(),null,"SourceRelName");
String fkTableNameE = fksE.getString("FKTABLE_NAME");
String fkColumnNameE = fksE.getString("FKCOLUMN_NAME");
然后我尝试使用getImportedKeys方法,但它没有用.
这是我的班级：
public class DbConnection {
private String userName = null;
private String password = null;
private String driver = null;
private String DbUrl = null;
private Connection conn = null;
private DatabaseMetaData dbm = null;
private ArrayList最佳答案
getImportedKeys对我有用.一些代码：
private static void printForeignKeys(Connection connection,String tableName) throws SQLException {
DatabaseMetaData metaData = connection.getMetaData();
ResultSet foreignKeys = metaData.getImportedKeys(connection.getCatalog(),tableName);
while (foreignKeys.next()) {
String fkTableName = foreignKeys.getString("FKTABLE_NAME");
String fkColumnName = foreignKeys.getString("FKCOLUMN_NAME");
String pkTableName = foreignKeys.getString("PKTABLE_NAME");
String pkColumnName = foreignKeys.getString("PKCOLUMN_NAME");
System.out.println(fkTableName + "." + fkColumnName + " -> " + pkTableName + "." + pkColumnName);
}
}