private boolean login(String[] part) { ResultSet rs = null; try { rs = beanOracle.selection("PASSWORD", "UTILISATEURS", "LOGIN = '******'"); } catch (SQLException e) { System.err.println(e.getStackTrace()); } String pwd = null; try { if (!rs.next()) { SendMsg("ERR#Login invalide"); } else pwd = rs.getString("PASSWORD"); } catch (SQLException ex) { System.err.println(ex.getStackTrace()); } if (pwd.equals(part[2])) { SendMsg("ACK"); return true; } else SendMsg("ERR#Mot de passe incorrecte"); return false; }
private void inputLorryWithoutReserv(String[] request) { ResultSet rs = null; String[] idList = request[2].split("@"); try { rs = beanOracle.selection("X, Y", "PARC", "ETAT=0"); } catch (SQLException ex) { SendMsg("ERR#Base de donnée inaccessible"); System.err.println("Erreur SQL exception input lorry" + ex.getStackTrace()); return; } String reponse = "ACK#"; ArrayList emplacement = new ArrayList(); try // on regarde si y'a assez de place et on recupere l'id de ces places. { for (int i = 0; i < idList.length; i++) { if (rs.next()) { reponse = reponse + idList[i] + "==>(" + rs.getString("X") + ";" + rs.getString("Y") + ")@"; emplacement.add(rs.getString("X") + ";" + rs.getString("Y")); } else { SendMsg("ERR#Erreur pas assez de places"); return; } } } catch (SQLException ex) { SendMsg("ERR#Base de donnée inaccessible"); System.err.println("Erreur SQL exception input lorry" + ex.getStackTrace()); return; } // On insert les containers ajoutés dans la BD et on leur met un numéro de réservation + on // réserve leurs places Random rand = new Random(); int resID = rand.nextInt(999999); for (int i = 0; i < idList.length; i++) { String[] coord = emplacement.get(i).toString().split(";"); HashMap<String, String> insertion = new HashMap(); HashMap<String, String> update = new HashMap(); insertion.put("ID_CONTAINER", idList[i]); insertion.put("RESERVATION", Integer.toString(resID)); update.put("ETAT", "1"); try { beanOracle.ecriture("CONTAINERS", insertion); beanOracle.miseAJour("PARC", update, "X=" + coord[0] + " AND Y=" + coord[1]); } catch (requeteException ex) { System.err.println("Erreur d'insertion "); } } SendMsg(reponse); }
private void listOperation(String[] request) { String Select = "ID_MOUVEMENT, MOUVEMENTS.ID_CONTAINER, ID_TRANSPORTEUR_ENTRANT, DATE_ARRIVEE, ID_TRANSPORTEUR_SORTANT, POIDS, DATE_DEPART, DESTINATION, ID_SOCIETE"; String From = "MOUVEMENTS INNER JOIN CONTAINERS ON MOUVEMENTS.ID_CONTAINER = CONTAINERS.ID_CONTAINER"; String Where = null; if (request[1].equals("societe")) Where = "CONTAINERS.ID_SOCIETE = '" + request[2] + "'"; if (request[1].equals("destination")) Where = "DESTINATION = '" + request[2] + "'"; if (request[1].equals("date")) Where = "To_date(DATE_ARRIVEE, 'DD/MM/YYYY') BETWEEN To_date('" + request[2] + "', 'DD/MM/YYYY') AND To_date('" + request[3] + "', 'DD/MM/YYYY')"; if (Where == null) { SendMsg("ERR#Recherche impossible sur ce critere"); return; } ResultSet rs = null; try { rs = beanOracle.selection(Select, From, Where); } catch (SQLException ex) { SendMsg("ERR#Base de donnee inaccessible"); System.err.println("Erreur SQL exception input lorry" + ex.getStackTrace()); return; } boolean empty = true; String message = ""; try { while (rs.next()) { empty = false; message = message + rs.getString("ID_MOUVEMENT") + " --- " + rs.getString("ID_CONTAINER") + " --- " + rs.getString("ID_TRANSPORTEUR_ENTRANT") + " --- "; message = message + rs.getString("DATE_ARRIVEE") + " --- " + rs.getString("ID_TRANSPORTEUR_SORTANT") + " --- " + rs.getString("POIDS") + " --- "; message = message + rs.getString("DATE_DEPART") + " --- " + rs.getString("DESTINATION") + " --- " + rs.getString("ID_SOCIETE") + "#"; } } catch (SQLException ex) { SendMsg("ERR#Base de donnee inaccessible"); System.err.println("Erreur SQL exception input lorry" + ex.getStackTrace()); return; } if (empty) { SendMsg("ERR#Aucun resultats pour la societe " + request[2]); return; } SendMsg("ACK#" + message); }
private void inputLorry(String[] request) { ResultSet rs = null; try { rs = beanOracle.selection("ID_CONTAINER", "CONTAINERS", "RESERVATION = '" + request[1] + "'"); } catch (SQLException ex) { SendMsg("ERR#Base de donnée inaccessible"); System.err.println("Erreur SQL exception input lorry"); return; } boolean isResultEmpty = true; int nbrElemParc = 0; String[] idList = request[2].split("@"); System.out.println(request[2]); try { while (rs.next()) { nbrElemParc++; isResultEmpty = false; String curId = null; String id = rs.getString("ID_CONTAINER"); boolean invalidContainerID = true; for (String s : idList) { System.out.println(s + "---" + id); curId = s; if (s.equals(id)) { invalidContainerID = false; break; } } if (invalidContainerID) { SendMsg("ERR#Le container " + curId + " ne fait pas partie de la reservation"); return; } if (nbrElemParc >= idList.length) break; } } catch (SQLException ex) { SendMsg("ERR#Base de donnée inaccessible"); System.err.println("Erreur SQL exception input lorry resultat"); return; } if (isResultEmpty) { SendMsg("ERR#Le numero de reservation demande n'existe pas"); return; } try { rs = beanOracle.selection("X, Y", "PARC", "ETAT=1"); } catch (SQLException ex) { SendMsg("ERR#Base de donnée inaccessible"); System.err.println("Erreur SQL exception input lorry" + ex.getStackTrace()); return; } String reponse = "ACK#"; try { for (int i = 0; i < idList.length; i++) { if (rs.next()) { reponse = reponse + idList[i] + "==>(" + rs.getString("X") + ";" + rs.getString("Y") + ")@"; } else { SendMsg("ERR#Erreur pas assez de places reservees"); return; } } } catch (SQLException ex) { SendMsg("ERR#Base de donnee inaccessible"); System.err.println("Erreur SQL exception input lorry" + ex.getStackTrace()); return; } SendMsg(reponse); }