Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static void metaData(String loginInfo) throws Exception {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- Connection db_connection = DriverManager.getConnection("jdbc:mysql:///cs122b", loginInfo.split(" ")[0], loginInfo.split(" ")[1]);
- DatabaseMetaData metaData = db_connection.getMetaData();
- ResultSet tables = metaData.getTables(null, null, null, null);
- Statement select = db_connection.createStatement();
- while(tables.next())
- {
- ResultSetMetaData metadata = tables.getMetaData();
- while (tables.next()) {
- ResultSet result = select.executeQuery("Select * from " + tables.getObject(3));
- System.out.println();
- System.out.println(tables.getObject(3));
- ResultSetMetaData metadata2 = result.getMetaData();
- for (int i = 1; i <= metadata2.getColumnCount(); i++)
- System.out.println("\t" + metadata2.getColumnName(i) + " is " + metadata2.getColumnTypeName(i));
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement