请教,如何得到一个表得主键是哪几列?使用jdbc,可以得到吗?我查了没查到.

[superzrb]

如题,万分感谢!

[shoulders]

谢谢楼上的，学到知识了。

[haha-mark]

这个应该充数据库中得到，各个数据库得到的方法不同，一般都提供存储过程

[fog628]

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;
import java.sql.DriverManager;

import java.util.List;
import java.util.ArrayList;

class AutoScrollTest{
public static Connection getConnection(String driver,
String url,
String user,
String pwd) throws Exception{
Class.forName(driver);
Connection cnn = DriverManager.getConnection(url, user, pwd);

return cnn;
}

public static List getPrimaryKeysByTableName(Connection cnn, String tableName)
throws Exception{

List list = new ArrayList();
DatabaseMetaData dbMetaData = cnn.getMetaData();
ResultSet rs = dbMetaData.getPrimaryKeys(null, null, tableName);
/* getPrimaryKeys()返回了一个ResultSet，ResultSet里面有:
*
* TABLE_CAT String => table catalog (may be null)
* TABLE_SCHEM String => table schema (may be null)
* TABLE_NAME String => table name
* COLUMN_NAME String => column name
* KEY_SEQ short => sequence number within primary key
* PK_NAME String => primary key name (may be null)
*
**/
while(rs.next()){
//只从ResultSet里面取了COLUMN_NAME
//就是主键的列名
list.add((rs.getString("COLUMN_NAME")));

System.out.println( rs.getString("TABLE_CAT") + "\t" +
rs.getString("TABLE_SCHEM") + "\t" +
rs.getString("TABLE_NAME") + "\t" +
rs.getString("COLUMN_NAME") + "\t" +
rs.getShort("KEY_SEQ") + "\t" +
rs.getString("PK_NAME"));
}

return list;

}
public static void main(String[] args){
String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=pubs";
String user = "sa";
String pwd = "";

try{
Connection c = getConnection(driver, url, user, pwd);
List primaryKeys = getPrimaryKeysByTableName(c, "authors");

System.out.println();
System.out.print("primary keys are: ");
System.out.println(primaryKeys);
}catch(Exception e){
e.printStackTrace();
}
}
}