java得到数据库信息

// 得到当前数据库下所有的表名

public void getTableNameByCon(Connection con) {

   try {

   DatabaseMetaData meta = con.getMetaData();

   ResultSet rs = meta.getTables(null, null, null,

     new String[] { "TABLE" });

   while (rs.next()) {

     System.out.println("表名：" + rs.getString(3));

     System.out.println("表所属用户名：" + rs.getString(2));

     System.out.println("------------------------------");

   }

   con.close();

   } catch (Exception e) {

   try {

     con.close();

   } catch (SQLException e1) {

     // TODO Auto-generated catch block

     e1.printStackTrace();

   }

   // TODO Auto-generated catch block

   e.printStackTrace();

   }

}

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

//  得到表的所有字段信息

public List<DBTableFieldStruct> getFieldList(String tableName, Connection con)

throws SQLException {

String sql = " SELECT   *   FROM   " + tableName;

PreparedStatement ps = con.prepareStatement(sql);

ResultSet rs = ps.executeQuery();

ResultSetMetaData meta = rs.getMetaData();

int columnCount = meta.getColumnCount();

List<DBTableFieldStruct> result = new ArrayList<DBTableFieldStruct>();

for (int i = 0; i < columnCount; i++) {

DBTableFieldStruct field = new DBTableFieldStruct();     //javabean   如下

int cursor = i + 1;

field.setName(meta.getColumnName(cursor));

field.setType(meta.getColumnType(cursor));

field.setSize(meta.getColumnDisplaySize(cursor));

field.setScale(meta.getScale(cursor));

field.setIsNullable(meta.isNullable(cursor));

result.add(field);

}

return result;

}

 

 

 

 

 

public class DBTableFieldStruct {

private String name;

private int type;

private int size;

private int isNullable;

private int scale;

 

public String getName() {

return name;

}

 

public void setName(String name) {

this.name = name;

}

 

public int getType() {

return type;

}

 

public void setType(int type) {

this.type = type;

}

 

public int getSize() {

return size;

}

 

public void setSize(int size) {

this.size = size;

}

 

public int getIsNullable() {

return isNullable;

}

 

public void setIsNullable(int isNullable) {

this.isNullable = isNullable;

}

 

public int getScale() {

return scale;

}

 

public void setScale(int scale) {

this.scale = scale;

}

 

}