遍历数据表

知道table结构的情况下：

Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = (Connection) DriverManager.getConnection(connstr);
String Sql = "select * from table" ;
Statement st = conn.createStatement();
ResultSet rs = st.executeQuery(Sql);
// 遍历数据库中已存在的表
while (rs.next()) {
    tables.add(rs.getString(1));
}
closeConn();

对任意结构的表进行遍历：

   Class.forName("com.mysql.jdbc.Driver").newInstance();
    Connection conn = (Connection) DriverManager.getConnection(connstr);
		    Statement stmt = conn.createStatement();   
    ResultSet rs = stmt.executeQuery("select * from dept");   
       
    ResultSetMetaData rsmd = rs.getMetaData();   
    int columnCount = rsmd.getColumnCount();   
    // 输出列名   
    for (int i=1; i<=columnCount; i++){   
        System.out.print(rsmd.getColumnName(i));   
        System.out.print("(" + rsmd.getColumnTypeName(i) + ")");   
        System.out.print(" | ");   
    }   
    System.out.println();   
    // 输出数据   
    while (rs.next()){   
        for (int i=1; i<=columnCount; i++){   
            System.out.print(rs.getString(i) + " | ");   
        }   
        System.out.println();   
    }   
    rs.close();   
    stmt.close();   
    conn.close();