public static int updateReturnedLog(ReturnedLog log) throws ClassNotFoundException, SQLException {
String query =
"Update ReturnedLog set returnedDate='"
+ log.getReturnedDate()
+ "', reason='"
+ log.getReason()
+ "' where returnedID='"
+ log.getReturnedID()
+ "'";
Connection connection = DBConnection.getConnectionToDB();
int res = DBHandler.setData(connection, query);
return res;
}
public static int addReturnedLog(ReturnedLog log) throws ClassNotFoundException, SQLException {
String query;
if (log.getPatientIssueID() != null) {
query =
"Insert into ReturnedLog(returnedID,returnedDate,packetID,reason,PatientIssueID) values ('"
+ log.getReturnedID()
+ "','"
+ log.getReturnedDate()
+ "','"
+ log.getPacketID()
+ "','"
+ log.getReason()
+ "','"
+ log.getPatientIssueID()
+ "')";
System.out.println("===============");
System.out.println(log.getReturnedID());
System.out.println("" + log.getReturnedDate());
System.out.println("" + log.getPacketID());
System.out.println("" + log.getReason());
System.out.println("" + log.getPatientIssueID());
System.out.println("===============");
} else {
query =
"Insert into ReturnedLog(returnedID,returnedDate,packetID,reason,BulkIssueID) values ('"
+ log.getReturnedID()
+ "','"
+ log.getReturnedDate()
+ "','"
+ log.getPacketID()
+ "','"
+ log.getReason()
+ "','"
+ log.getBulkIssueID()
+ "')";
}
Connection connection = DBConnection.getConnectionToDB();
int res = DBHandler.setData(connection, query);
return res;
}