Java ResultSetDateMate 得到表结构 wpjiyan

最新推荐文章于 2023-08-29 11:39:16 发布

wpjiyan

最新推荐文章于 2023-08-29 11:39:16 发布

阅读量584

点赞数

文章标签： java sql object null

本文链接：https://blog.csdn.net/wpjiyan/article/details/1550563

版权

public void getTable_Info() {
  if (con == null)
   this.getMySQLConnection();
  try {
   stm = con.createStatement();
   sql = "desc TableName";
   rs = stm.executeQuery(sql);
   System.out.println("Beging----------------");
   int descInd = rs.getMetaData().getColumnCount();
   System.out.println("ColumnName:");
   for (int i = 1; i <= descInd; i++) {
    System.out.print(rs.getMetaData().getColumnName(i) + "| ");
   }

   System.out.println();
   while (rs.next()) {
    for (int i = 1; i <= descInd; i++) {
     // System.out.printf("%s", (Object[]) rs.getObject(i));
     System.out.print(rs.getObject(i) + "| ");
    }
    System.out.println();
   }
   System.out.println("Ending-----------------");
  } catch (SQLException se) {
   se.printStackTrace();
  } finally {
   this.closeCon();
  }
}