Guest User

Untitled

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