Advertisement
Guest User

Untitled

a guest
Apr 5th, 2016
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. private static void metaData(String loginInfo) throws Exception {
  2. Class.forName("com.mysql.jdbc.Driver").newInstance();
  3. Connection db_connection = DriverManager.getConnection("jdbc:mysql:///cs122b", loginInfo.split(" ")[0], loginInfo.split(" ")[1]);
  4.  
  5. DatabaseMetaData metaData = db_connection.getMetaData();
  6. ResultSet tables = metaData.getTables(null, null, null, null);
  7.  
  8. Statement select = db_connection.createStatement();
  9. while(tables.next())
  10. {
  11. ResultSetMetaData metadata = tables.getMetaData();
  12.  
  13. while (tables.next()) {
  14. ResultSet result = select.executeQuery("Select * from " + tables.getObject(3));
  15. System.out.println();
  16.  
  17. System.out.println(tables.getObject(3));
  18. ResultSetMetaData metadata2 = result.getMetaData();
  19.  
  20.  
  21. for (int i = 1; i <= metadata2.getColumnCount(); i++)
  22. System.out.println("\t" + metadata2.getColumnName(i) + " is " + metadata2.getColumnTypeName(i));
  23.  
  24. }
  25. }
  26.  
  27. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement