Guest User

Untitled

a guest
Feb 17th, 2019
275
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. public class ConnectDatabase {
  2. ConnectDatabase(String username, String password ) throws SQLException {
  3. Connection con = DriverManager.getConnection("jdbc:derby://localhost:1527/ai", username, password);
  4. Statement stmt = con.createStatement();
  5. ResultSet rs =stmt.executeQuery("SELECT * FROM TABLE1");
  6. System.out.println("done");
  7. con.close();
  8. }
  9.  
  10. public String[] getTableNames(String username, String password , String a) throws SQLException{
  11. Connection DatabaseConnection = DriverManager.getConnection("jdbc:derby://localhost:1527/ai", username, password);
  12. DatabaseMetaData DatabaseInfo = DatabaseConnection.getMetaData();
  13. ResultSet FromResultSet = DatabaseInfo.getTables(null, null, "%", null);
  14. ArrayList<String> TableNameArrayList=new ArrayList<>();
  15.  
  16. while (FromResultSet.next()){
  17. TableNameArrayList.add(FromResultSet.getString(3));
  18.  
  19. }
  20. String[] StringArrayObject= new String[TableNameArrayList.size()];
  21. String[] TableNameStringArray = TableNameArrayList.toArray(StringArrayObject);
  22. DatabaseConnection.close();
  23. return TableNameStringArray;
  24.  
  25. }
  26. }
Add Comment
Please, Sign In to add comment