1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
try {
connect();
st = conn.createStatement();
res = st.executeQuery("INSERT INTO proposition (idproposition,nomsociete,TYPEPROPOSITION,DATEPROPOSITION,TYPEPOSTE,SITE,CONTACT,lienoffre,REFAPEC) values (SEQOFFRE.nextval, '" + nomsociete + "','" + TYPEPROPOSITION + "',TO_DATE('" + DATEPROPOSITION + "','DD/MM/yyyy'), '" + TYPEPOSTE + "', '" + SITE + "' , '" + CONTACT + "', '" + lienoffre + "' , '" + REFAPEC + "' )");
//res = st.executeQuery("INSERT INTO proposition (idproposition,nomsociete,TYPEPROPOSITION,DATEPROPOSITION,TYPEPOSTE,SITE,CONTACT,lienoffre,REFAPEC) values (SEQOFFRE.nextval, '" + nomsociete + "','" + TYPEPROPOSITION + "','" +date +"', '" + TYPEPOSTE + "', '" + SITE + "' , '" + CONTACT + "', '" + lienoffre + "' , '" + REFAPEC + "' )");
return "ok";
//return true;
} catch (Exception ex) {
Logger.getLogger(CalculatorService.class.getName()).log(Level.SEVERE, null, ex.toString());
// return false;
return ex.toString();
} |
Partager