Use JDBC to query the table's primary key

Recently, I have been working on restructuring database tables. Today I have encountered a related operation on getting the primary key of a [given table name] and performing other related operations. Public String [] gettablepk (string tablecodes) throws exception {<br/> string [] resultarray = NULL; <br/> connection conn = NULL; <br/> databasemetadata dbmd = NULL; <br/> resultset rs = NULL; <br/> try {<br/>/** check the API, the resultset contains five columns: <br/> * The table_cat table directory is generally null <br/> * table_schem table index. The structure of the table where the primary key is located, it is usually set to dbmd. getUserName () <br/> * table_name table name containing the primary key <br/> * column_name primary key name <br/> * key_seq master Key sequence <br/> * pk_name constraint name <br/> */<br/> conn = datasource. getconnection (); <br/> dbmd = Conn. getmetadata (); <br/> rs = DBMS. getprimarykeys (null, null, tablecodes); <br/> string temppk = ""; <br/> while (RS. next () {<br/> temppk = Rs. getstring ("column_name") + ","; <br/>}< br/> resultarray = temppk. split (","); <br/> If (temppk. length () <1) {<br/> resultarray = NULL; <br/>}< br/>} catch (sqlexc Eption sqle) {<br/> logger. Error (sqle); <br/>}finally {<br/> If (RS! = NULL) {<br/> try {<br/> Rs. close (); <br/>}catch (sqlexception sqle) {<br/> logger. error (sqle); <br/>}< br/> If (Conn! = NULL) {<br/> try {<br/>} catch (sqlexception sqle) {<br/> logger. error (sqle); <br/>}< br/> return resultarray; <br/>}< br/>