……
try {
con = DriverManager.getConnection(url, "myLogin", "myPassword");
stmt = con.createStatement();
stmt.executeUpdate(createString);
DatabaseMetaData dbmd = con.getMetaData();
ResultSet rs = dbmd.getPrimaryKeys(null, null, "TableName");
while (rs.next()) {
String name = rs.getString("TABLE_NAME");
String columnName = rs.getString("COLUMN_NAME");
String keySeq = rs.getString("KEY_SEQ");
String pkName = rs.getString("PK_NAME");
System.out.println("table name : " + name);
System.out.println("column name: " + columnName);
System.out.println("sequence in key: " + keySeq);
System.out.println("primary key name: " + pkName);
System.out.println("");
}
}
……
try {
con = DriverManager.getConnection(url, "myLogin", "myPassword");
stmt = con.createStatement();
stmt.executeUpdate(createString);
DatabaseMetaData dbmd = con.getMetaData();
ResultSet rs = dbmd.getPrimaryKeys(null, null, "TableName");
while (rs.next()) {
String name = rs.getString("TABLE_NAME");
String columnName = rs.getString("COLUMN_NAME");
String keySeq = rs.getString("KEY_SEQ");
String pkName = rs.getString("PK_NAME");
System.out.println("table name : " + name);
System.out.println("column name: " + columnName);
System.out.println("sequence in key: " + keySeq);
System.out.println("primary key name: " + pkName);
System.out.println("");
}
}
……
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货