读取数据表
public static void searchAllTable() { //String sql="SELECT * FROM information_schema.`TABLES`"; String sql="select table_name from information_schema.tables where table_schema='vc_2021030601';"; MySQLConnect.connectMySQL(); ResultSet rs=MySQLConnect.runSQL(sql); try { while (rs.next()) { String tableName = rs.getString(1); if(tableName.startsWith("r_")) { continue; } if(tableName.startsWith("t_")) { continue; } //System.out.println(""+tableName+""); listTables.add(tableName); } } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } MySQLConnect.close(); }