-
Notifications
You must be signed in to change notification settings - Fork 0
/
UpdateAccount.java
51 lines (41 loc) · 1.61 KB
/
UpdateAccount.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
import javax.swing.*;
import java.sql.SQLException;
import java.sql.PreparedStatement;
public class UpdateAccount {
static void update(int accountNumber, String column, String newValue) {
try {
String sql = "UPDATE account SET %s = ? WHERE id = %d";
String formatedSQL = String.format(sql, column, accountNumber);
PreparedStatement stt = Connect.connection.prepareStatement(formatedSQL);
if(column == "id"){
int newValueInt = Integer.parseInt(newValue);
stt.setInt(1, newValueInt);
Main.accountNumber = newValueInt;
} else {
stt.setString(1, newValue);
}
int response = stt.executeUpdate();
if(response > 0){
String dialog = "%s successfully updated!";
JOptionPane.showMessageDialog(null, String.format(dialog, column));
}
} catch (SQLException e){
e.printStackTrace();
}
}
static void options(int accountNumber) {
String dialog = "What do you want to update? \n\n 1) Account number \n 2) Password";
String menuOptionString = JOptionPane.showInputDialog(null, dialog);
String newValue = JOptionPane.showInputDialog(null, "Type the new value");
int option = Integer.parseInt(menuOptionString);
switch(option){
case 1 -> {
update(accountNumber, "id", newValue);
}
case 2 -> {
update(accountNumber, "pass", newValue);
}
}
Main.isLogged();
}
}