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 27 28 29 30 31 32 33 34 35
|
public void insertB(String transp,String pci,String clil,String cli,String ref,String ind,String refc,String sit,String just,
String dtm,String h,String txt,String cp,String pds,String aenv,String menv,String jenv) throws SQLException{
BaseDonnees.connexionPostgres().setAutoCommit(false);
st1 = BaseDonnees.connexionPostgres().prepareStatement("insert into savsuivitr (cste,cetab,transp,numre,codecli,libcli,cdem,ind,cdecli,sit,just," +
"datenv,heure,com,nbcol,poids,an,mois,jour,aliv,mliv,jliv,indx) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
st1.setString(1, "CRP");
st1.setString(2, "E11");
st1.setString(3, transp);
st1.setString(4, pci);
st1.setString(5, clil);
st1.setString(6, cli);
st1.setString(7, ref);
st1.setString(8, ind);
st1.setString(9, refc);
st1.setString(10, sit);
st1.setString(11, just);
st1.setString(12, dtm);
st1.setString(13, h);
st1.setString(14, txt);
st1.setString(15, cp);
st1.setString(16, pds);
st1.setString(17, a);
st1.setString(18, m);
st1.setString(19, j);
st1.setString(20, aenv);
st1.setString(21, menv);
st1.setString(22, jenv);
st1.setInt(23, indx);
rs1 = st1.executeQuery();
st1.close();
} |
Partager