Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public void OpdaterMedlem() {
- try {
- Connection minConnection;
- minConnection = DriverManager
- .getConnection(
- "jdbc:sqlserver://LAPTOP-3LA06A4H\\SQLEXPRESS;databaseName=YodaFitness;user=sa;password=123123");
- Statement stmt = minConnection.createStatement();
- int id = Integer.parseInt(txfIdOpdater.getText().trim());
- String navn = txfNavnOpdater.getText();
- String adresse = txfAdresseOpdater.getText();
- int tlf = Integer.parseInt(txfTelefonOpdater.getText().trim());
- String sql =
- "exec updateMedlem" + " " + id + ", '" + navn + "', " + "'" + adresse + "', " + tlf;
- System.out.println(sql);
- stmt.executeUpdate(sql);
- if (stmt != null) {
- stmt.close();
- }
- if (minConnection != null) {
- minConnection.close();
- }
- }
- catch (Exception e) {
- System.out.println("fejl: " + e.getMessage());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement