/** 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; }