public ArrayList getDBTables(String dbName) throws Exception { //数据库表名List ArrayList<String> tbList = new ArrayList<String>(); //获取数据库元数据 DatabaseMetaData dbMetaData = new DatabaseMetaData((com.mysql.jdbc.Connection) getConn(), dbName); //类型() String[] types = { "TABLE" , "VIEW" }; rs = dbMetaData.getTables( null , dbName, "%" , types); while (rs.next()) { tbList.add(rs.getString( 3 )); } return tbList; }
转载于:https://www.cnblogs.com/huangjihua/archive/2010/09/17/4125209.html