Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void getDatabaseTables(Session session) {
- 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;";
- Connection connection = null;
- int Liczba=0;
- try {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- connection = DriverManager.getConnection(url);
- String schema = connection.getSchema();
- String selectSql = String.format("select name from sys.tables");
- try (Statement statement = connection.createStatement();
- ResultSet resultSet = statement.executeQuery(selectSql)) {
- while (resultSet.next())
- {
- SessionHandler.sendToSession(session, resultSet.getString(1));
- }
- connection.close();
- }
- }
- catch (Exception e) {
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement