Advertisement
Guest User

Untitled

a guest
Mar 7th, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. public void OpdaterMedlem() {
  2. try {
  3. Connection minConnection;
  4. minConnection = DriverManager
  5. .getConnection(
  6. "jdbc:sqlserver://LAPTOP-3LA06A4H\\SQLEXPRESS;databaseName=YodaFitness;user=sa;password=123123");
  7.  
  8. Statement stmt = minConnection.createStatement();
  9.  
  10. int id = Integer.parseInt(txfIdOpdater.getText().trim());
  11. String navn = txfNavnOpdater.getText();
  12. String adresse = txfAdresseOpdater.getText();
  13. int tlf = Integer.parseInt(txfTelefonOpdater.getText().trim());
  14.  
  15. String sql =
  16. "exec updateMedlem" + " " + id + ", '" + navn + "', " + "'" + adresse + "', " + tlf;
  17. System.out.println(sql);
  18.  
  19. stmt.executeUpdate(sql);
  20.  
  21. if (stmt != null) {
  22. stmt.close();
  23. }
  24. if (minConnection != null) {
  25. minConnection.close();
  26. }
  27.  
  28. }
  29. catch (Exception e) {
  30. System.out.println("fejl: " + e.getMessage());
  31. }
  32. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement