Advertisement
Guest User

Untitled

a guest
Mar 10th, 2017
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. public void updateControls() {
  2. ArrayList<String> list = new ArrayList<>();
  3.  
  4. try {
  5. Connection minConnection;
  6. minConnection = DriverManager
  7. .getConnection("jdbc:sqlserver://LAPTOP-32KIS2JP\\DANIELSSQL;databaseName=YodaFitness2;user=sa;password=dani6602;");
  8.  
  9. Statement stmt = minConnection.createStatement();
  10.  
  11. ResultSet res = stmt.executeQuery("select medlemID, navn, adresse, tlfNr, oprettelsesDato from Medlem");
  12. while (res.next()) {
  13.  
  14. list.add("Id: " + res.getString(1) + " " + "Navn: " + res.getString(2) + " " +
  15. "adresse: " + res.getString(3) + " " + "tlfNr: " + res.getString(4) + " " +
  16. "oprettelsesDato: " + res.getString(5));
  17. }
  18.  
  19. if (res != null)
  20. res.close();
  21. if (stmt != null)
  22. stmt.close();
  23. if (minConnection != null)
  24. minConnection.close();
  25. } catch (Exception e) {
  26. System.out.println("fejl: " + e.getMessage());
  27. }
  28. lvwInstruktorliste.getItems().setAll(list);
  29. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement