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
| try {
stmt=conn.createStatement();
} catch (SQLException ex) {
Logger.getLogger(GestionPacketDAO.class.getName()).log(Level.SEVERE, null, ex);
}
query = "insert into ALIJAN.\"PA\" ";
query1=" (C1";
query2= "values('"+packet.get(0).toString() ;
for(int i=2;i<=packet.size();i++){
query1+= ",C"+ Integer.toString(i);
query2+= "','"+packet.get(i-1).toString() ;
}
query1+= ")";
query2+="')";
query3=query+query1+query2;
System.out.println(query3);
try {
int rs = stmt.executeUpdate(query3);
} catch (SQLException ex) {
Logger.getLogger(GestionPacketDAO.class.getName()).log(Level.SEVERE, null, ex);
} |
Partager