Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void updateControls() {
- ArrayList<String> list = new ArrayList<>();
- try {
- Connection minConnection;
- minConnection = DriverManager
- .getConnection("jdbc:sqlserver://LAPTOP-32KIS2JP\\DANIELSSQL;databaseName=YodaFitness2;user=sa;password=dani6602;");
- Statement stmt = minConnection.createStatement();
- ResultSet res = stmt.executeQuery("select medlemID, navn, adresse, tlfNr, oprettelsesDato from Medlem");
- while (res.next()) {
- list.add("Id: " + res.getString(1) + " " + "Navn: " + res.getString(2) + " " +
- "adresse: " + res.getString(3) + " " + "tlfNr: " + res.getString(4) + " " +
- "oprettelsesDato: " + res.getString(5));
- }
- if (res != null)
- res.close();
- if (stmt != null)
- stmt.close();
- if (minConnection != null)
- minConnection.close();
- } catch (Exception e) {
- System.out.println("fejl: " + e.getMessage());
- }
- lvwInstruktorliste.getItems().setAll(list);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement