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 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;
}
public RunnableTraitementEntree(Socket s) {
CSocket = s;
try {
dis = new DataInputStream(new BufferedInputStream(CSocket.getInputStream()));
dos = new DataOutputStream(new BufferedOutputStream(CSocket.getOutputStream()));
} catch (IOException e) {
System.err.println("RunnableTraitement : Host non trouvé : " + e);
}
beanOracle = new BeanBDAccess();
try {
beanOracle.connexionOracle("localhost", 1521, "TRAFIC", "TRAFIC", "XE");
} catch (ClassNotFoundException ex) {
System.err.println("Class not found " + ex.getMessage());
} catch (SQLException ex) {
System.err.println("SQL Exception (oracle)" + ex.getMessage());
} catch (connexionException ex) {
System.err.println(ex.getNumException() + " -- " + ex.getMessage());
}
}
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);
}