读书人

mysql回获得数据库的所有表

发布时间: 2012-08-29 08:40:14 作者: rapoo

mysql来获得数据库的所有表
方法一:使用metadata元数据

         private static final String COMMON_SPLIT_STR = ",";public String[] getTableArray() {String sql = "show tables";Connection conn = null;Statement sta = null;ResultSet rs = null;StringBuffer tableNameStr = new StringBuffer();try {conn = connectionUtil.getConnection();sta = conn.createStatement();rs = sta.executeQuery(sql);while (rs.next()) {tableNameStr.append(rs.getString(1)).append(COMMON_SPLIT_STR);}} catch (SQLException e) {logger.error(e);} catch(Exception e){logger.error(e);} finally {connectionUtil.closeConnection(conn, sta, rs);}return tableNameStr.toString().split(COMMON_SPLIT_STR);}

读书人网 >其他数据库

热点推荐