想要得到一个表的主键列名怎么办?当然,表的主键不止一个。
---------------------------------------------------------------
DatabaseMetaData.getPrimaryKeys
---------------------------------------------------------------
import java.io.*;
import java.sql.*;
public class Test {
public static void main(String[] args) throws SQLException,ClassNotFoundException
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:Yzl","pda","pwpda");
DatabaseMetaData dbMeta = con.getMetaData();
ResultSet rs = dbMeta.getPrimaryKeys(null,null,"KL_XFWZZT");
System.out.println("主键为:");
while(rs.next())
{
System.out.print(rs.getString(4)+" ");
}
con.close();
}
}
运行如下(表主键正是为:ZTDM00 ZD0000):
F:/>javac Test.java
F:/>java Test
主键为:
ZTDM00 ZD0000
---------------------------------------------------------------
DatabaseMetaData.getPrimaryKeys
---------------------------------------------------------------
import java.io.*;
import java.sql.*;
public class Test {
public static void main(String[] args) throws SQLException,ClassNotFoundException
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:Yzl","pda","pwpda");
DatabaseMetaData dbMeta = con.getMetaData();
ResultSet rs = dbMeta.getPrimaryKeys(null,null,"KL_XFWZZT");
System.out.println("主键为:");
while(rs.next())
{
System.out.print(rs.getString(4)+" ");
}
con.close();
}
}
运行如下(表主键正是为:ZTDM00 ZD0000):
F:/>javac Test.java
F:/>java Test
主键为:
ZTDM00 ZD0000