public static boolean insertOneContact(ContactUrgence contact) throws Exception {
Connection con;
ConnexionBd connexionBD = new ConnexionBd();
boolean insertOk = false;
con = connexionBD.createConnection();
try {
String sqlString =
"insert into contact_urgence "
+ "(id, nom, prenom, courriel, id_relation) "
+ "values ("
+ contact.getId()
+ ", '"
+ contact.getNom()
+ "', '"
+ contact.getPrenom()
+ "', '"
+ contact.getCourriel()
+ "', '"
+ contact.getRelation().getId()
+ "')";
insertOk = connexionBD.executeSQL(con, sqlString);
if (!insertOk) {
System.err.println("***To insert the data row ...." + sqlString);
}
} catch (SQLException e) {
System.err.println("***** Database error at insertOneContact: " + e.getMessage());
}
con.close();
System.out.println("Connection closed");
return insertOk;
}
public static boolean updateContactUrgence(ContactUrgence contact) throws Exception {
Connection con;
ConnexionBd connexionBD = new ConnexionBd();
boolean updateOk = false;
con = connexionBD.createConnection();
try {
String sqlString =
"Update contact_urgence "
+ " Set nom = "
+ contact.getNom()
+ ", prenom = "
+ contact.getPrenom()
+ ", courriel = "
+ contact.getCourriel()
+ ", id_relation = "
+ contact.getRelation().getId()
+ " Where id = "
+ contact.getId();
updateOk = connexionBD.executeSQL(con, sqlString);
if (!updateOk) {
System.err.println("***To update the data row ...." + sqlString);
}
} catch (SQLException e) {
System.err.println("***** Database error at updateContactUrgence: " + e.getMessage());
}
con.close();
System.out.println("Connection closed");
return updateOk;
}
public static ContactUrgence getOneContact(ContactUrgence contact) throws SQLException {
Connection con;
Statement stmt = null;
ResultSet rs = null;
ContactUrgence temp = new ContactUrgence();
ConnexionBd connexionBD = new ConnexionBd();
con = connexionBD.createConnection();
try {
stmt = con.createStatement();
rs =
stmt.executeQuery(
"select * from contact_urgence "
+ "where prenom = '"
+ contact.getPrenom()
+ "' and nom = '"
+ contact.getNom()
+ "' and courriel = '"
+ contact.getCourriel()
+ "' and id_relation = "
+ contact.getRelation().getId());
if (rs.next()) {
temp = new ContactUrgence();
temp.setId(rs.getInt("id"));
temp.setNom(rs.getString("nom"));
temp.setPrenom(rs.getString("prenom"));
temp.setCourriel(rs.getString("courriel"));
int idRelation = rs.getInt("id_relation");
// Requète pour récupérer la relation
rs = stmt.executeQuery("select * from relation where id = " + idRelation);
if (rs.next()) {
temp.setRelation(new Relation(rs.getInt("id"), rs.getString("nom")));
}
} else {
System.out.println("***** Le contact n'existe pas.");
}
} catch (SQLException e) {
System.err.println("***** Database error at getOneContact: " + e.getMessage());
} finally {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
}
con.close();
System.out.println("Connection closed");
System.err.println("***** END getOneContact()");
return temp;
}
public static ArrayList<ContactUrgence> getContactBenevole(int idBenevole) throws Exception {
Connection con;
Statement stmt = null;
ResultSet rs = null;
ContactUrgence contact = new ContactUrgence();
ArrayList<ContactUrgence> contacts = new ArrayList<ContactUrgence>();
ConnexionBd connexionBD = new ConnexionBd();
con = connexionBD.createConnection();
try {
stmt = con.createStatement();
rs =
stmt.executeQuery(
"select c.id, c.prenom, c.nom, c.id_relation from "
+ "contact_urgence as c, benevole as b, benevole_contact_urgence "
+ "where b.id = id_benevole "
+ "and c.id = id_contact_urgence "
+ "and b.id = "
+ idBenevole);
while (rs.next()) {
contact = new ContactUrgence();
contact.setId(rs.getInt("id"));
contact.setNom(rs.getString("nom"));
contact.setPrenom(rs.getString("prenom"));
contact.setRelation(new Relation(rs.getInt("id_relation"), ""));
contacts.add(contact);
}
} catch (SQLException e) {
System.err.println("***** Database error at getContactBenevole: " + e.getMessage());
} finally {
if (rs != null) {
rs.close();
}
if (stmt != null) {
stmt.close();
}
}
con.close();
System.out.println("Connection closed");
System.err.println("***** END getContactBenevole()");
return contacts;
}