public void Edit() {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
result = new String[8];
try {
inp = theView.GetResult();
Class.forName("com.mysql.jdbc.Driver").newInstance();
String connectionUrl = "jdbc:mysql://127.0.0.1:3306/fakelos";
String connectionUser = "******";
String connectionPassword = "******";
String query = null;
conn = DriverManager.getConnection(connectionUrl, connectionUser, connectionPassword);
stmt = conn.createStatement();
query =
"UPDATE patience SET `Id` = '"
+ ID
+ "' ,`Onoma` = '"
+ inp[0]
+ "' ,`Eponumo` = '"
+ inp[1]
+ "' ,`Blood` = '"
+ inp[2]
+ "' ,`Piesh` = '"
+ inp[3]
+ "' ,`Temp` = '"
+ inp[4]
+ "' ,`AFM` = '"
+ inp[5]
+ "' ,`Tel` = '"
+ inp[6]
+ "' WHERE `Id` = '"
+ ID
+ "'";
System.out.println(query);
stmt.executeUpdate(query);
} catch (Exception e) {
e.printStackTrace();
} finally {
try {
if (rs != null) rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (stmt != null) stmt.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (conn != null) conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public void Result() {
theView.SetResult(result);
}
public void Inp() {
ID = theView.GetSearch();
}
