e254. getting the column names in a result set.txt

这里面包含了一百多个JAVA源文件

try {
        // Create a result set
        Statement stmt = connection.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM my_table");
    
        // Get result set meta data
        ResultSetMetaData rsmd = rs.getMetaData();
        int numColumns = rsmd.getColumnCount();
    
        // Get the column names; column indices start from 1
        for (int i=1; i<numColumns+1; i++) {
            String columnName = rsmd.getColumnName(i);
    
            // Get the name of the column's table name
            String tableName = rsmd.getTableName(i);
        }
    } catch (SQLException e) {
    }