如何使用列不同的方法得到列數，列名，列的類型等？

解決方法

下麵的示例使用getColumnCount，getColumnName，getColumnTypeName，getColumnDisplaySize方法來獲取冇有列在表中的列的列或類型的名稱。

import java.sql.*;

public class jdbcConn {
   public static void main(String[] args) throws Exception{
      Class.forName("org.apache.derby.jdbc.ClientDriver");
      Connection con = DriverManager.getConnection
      ("jdbc:derby://localhost:1527/testDb","name","pass");
      Statement stmt = con.createStatement();
      String query = "select * from emp order by name";
      ResultSet rs = stmt.executeQuery(query);
      ResultSetMetaData rsmd = rs.getMetaData();
      System.out.println("no of columns in the table= "+
      rsmd.getColumnCount());
      System.out.println("Name of the first column "+ 
      rsmd.getColumnName(1));
      System.out.println("Type of the second column "+
      rsmd.getColumnTypeName(2));
      System.out.println("No of characters in 3rd column "+ 
      rsmd.getColumnDisplaySize(2));
   }
}

結果

上麵的代碼示例將產生以下結果。該結果可能會不同。

no of columns in the table= 3
Name of the first columnID
Type of the second columnVARCHAR
No of characters in 3rd column20