/** Avoid duplicated record in DB */
private boolean isExist(Patient patient) {
int count = 0;
try {
statement =
con.prepareStatement(
"SELECT COUNT(*) as c FROM patients WHERE UPPER(firstname) = UPPER(?) "
+ "AND UPPER(lastname) = UPPER(?) AND UPPER(email) = UPPER(?)");
statement.setString(1, patient.getFirstName());
statement.setString(2, patient.getLastName());
statement.setString(3, patient.getEmail());
rs = statement.executeQuery();
rs.first();
count = rs.getInt("c");
if (rs != null) rs.close();
} catch (SQLException e) {
System.out.println("Error: Could not count volunteers");
e.printStackTrace();
} finally {
try { // close statement
if (statement != null) statement.close();
} catch (Exception e) {
// Ignore
}
}
if (count > 0) return true;
else return false;
}
