Advertisement
Guest User

Untitled

a guest
Jun 10th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. try (Connection conn = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/test", "root", "12345")) {
  2.  
  3. ResultSet rsTables = conn.createStatement().executeQuery("SHOW TABLES");
  4.  
  5. while (rsTables.next()) {
  6. String tableName = rsTables.getString(1);
  7. tableList.add(tableName);
  8.  
  9. ResultSet rsInsert = conn.createStatement()
  10. .executeQuery("SELECT * FROM " + tableName);
  11.  
  12. while (rsInsert.next()) {
  13. String insert = rsInsert.getString(1);
  14. String insert1 = rsInsert.getString(2);
  15. String insert2 = rsInsert.getString(3);
  16. String insert3 = rsInsert.getString(4);
  17. tableList.add(insert);
  18. tableList.add(insert1);
  19. tableList.add(insert2);
  20. tableList.add(insert3);
  21.  
  22. }
  23. }
  24.  
  25. } catch (SQLException ex) {
  26. Logger.getLogger(Main.class.getName()).log(Level.SEVERE, null, ex);
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement