如何使用列的不同方法来计算列数、获取列名、获取 Java 中的列类型

问题描述

如何使用列的不同方法来计算列数、获取列名、获取列类型等?

解决方案

以下示例使用 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