Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try (Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "12345")) {
- ResultSet rsTables = conn.createStatement().executeQuery("SHOW TABLES");
- while (rsTables.next()) {
- String tableName = rsTables.getString(1);
- tableList.add(tableName);
- ResultSet rsInsert = conn.createStatement()
- .executeQuery("SELECT * FROM " + tableName);
- while (rsInsert.next()) {
- String insert = rsInsert.getString(1);
- String insert1 = rsInsert.getString(2);
- String insert2 = rsInsert.getString(3);
- String insert3 = rsInsert.getString(4);
- tableList.add(insert);
- tableList.add(insert1);
- tableList.add(insert2);
- tableList.add(insert3);
- }
- }
- } catch (SQLException ex) {
- Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement