Java 使用元数据打印 MySQL 表

Question

我该如何修改它，以便它使用元数据来打印表格？

public String formatStudentList() throws SQLException 
{ 
    String result = String.format("%-15s %-25s %-25s", "Student ID", "Student Name", "Degree    
      Scheme\n" + String.format("%-15s %-25s %-25s\n", "**********", "" +  
      "********************", "****************************")); 

    int count = 0; 
    try 
    { 
         conn = SimpleDataSource.getConnection(); 
         prepStat = conn.prepareStatement("SELECT * FROM student");
         ResultSet print = prepStat.executeQuery(); 

         while (print.next()) 
         { 
            String id = print.getString("studentId");
            String name = print.getString("studentName"); 
            String degree = print.getString("degreeScheme"); 
            result += String.format("%-15s %-25s %-25s\n", id, name, degree); 
            count++; 
         }

        if (result == null) 
        { 
            result = "No Students Were Found In Database\n";
        } 
        else 
        { 
            result += "\nTotal Number Of Student = " + count; 
        } 
        } catch (SQLException ex) 
        { 
             result = "Error Occurred: " + ex.getMessage(); 
        } finally 
        { 
             conn.close(); 
        } 
        return result; 
}

它完美地满足了我的要求，但是使用元数据有一种方法可以自动调整表格间距和标题。谁能帮我改变这个吗？

Answer 1

从 SimpleDataSource.getConnection() 中，您可以调用 getMetaData() 来获取 DatabaseMetaData getMetaData()。

然后您可以调用getColumns

参见javadocs