1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
public void insertOrders(){
try{
List paramServer = qf.racine.getChildren("Command");
Iterator i = paramServer.iterator();
while(i.hasNext())
{
Element courant = (Element)i.next();
String query= "INSERT INTO " + AppMain.cf.getTable1() + " (id, id_client, date_livraison, produit, quantite, id_pcjt, cp_client) VALUES (id_activite.nextval, ?, TO_DATE(?,'dd/MM/yyyy hh:mi'), ?, ?, ?, ?)";
PreparedStatement statement = conn.prepareStatement(query);
statement.setString(1,(String)courant.getChild("RefClient").getText());
statement.setString(2,(String)courant.getChild("DateHeure").getText());
statement.setString(3,(String)courant.getChild("Produit").getText());
statement.setString(4,(String)courant.getChild("Quantite").getText());
statement.setString(5,String.valueOf(nid));
statement.setString(6,(String)courant.getChild("CodePostal").getText());
statement.executeUpdate();
statement.close();
ack = true;
}
}catch(SQLException ex){
System.err.println("Error in insertOrders : ");
ex.printStackTrace();
ack = false;
}
} |
Partager