java – JDBC获取外键引用的相关属性

发布时间：2021-05-23 10:07:25 所属栏目：编程来源：网络整理

导读：是否可以行使JDBC获取FK的方针？我只行使getExportedKeys要领得到了源相关属性： ResultSet fksE = dbm.getExportedKeys(conn.getCatalog(),null,"SourceRelName");String fkTableNameE = fksE.getString("FKTABLE_NAME");String fkColumnNameE = fksE.getS

是否可以行使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);
    }
}


                        （编辑：湖南网）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

MySQL源码安置	运用图形界面从SQL导入
MySQL5.7+keepalived+	windows系统下jsp+mys