Advertisement
Guest User

Untitled

a guest
Nov 30th, 2017
134
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. public void getDatabaseTables(Session session) {
  2. String url = "jdbc:sqlserver://mojabaza.database.windows.net:1433;database=mySampleDatabase;user=Ubein@mojabaza;password=*****;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;";
  3. Connection connection = null;
  4. int Liczba=0;
  5. try {
  6. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  7. connection = DriverManager.getConnection(url);
  8. String schema = connection.getSchema();
  9. String selectSql = String.format("select name from sys.tables");
  10. try (Statement statement = connection.createStatement();
  11. ResultSet resultSet = statement.executeQuery(selectSql)) {
  12. while (resultSet.next())
  13. {
  14. SessionHandler.sendToSession(session, resultSet.getString(1));
  15. }
  16. connection.close();
  17. }
  18. }
  19. catch (Exception e) {
  20. e.printStackTrace();
  21. }
  22.  
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement