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
|
@WebMethod(operationName = "InsertionDonnees")
public boolean InsertionDonnees(@WebParam(name = "nomsociete")String nomsociete,
@WebParam(name = "TYPEPROPOSITION")String TYPEPROPOSITION,
@WebParam(name = "DATEPROPOSITION")String DATEPROPOSITION,
@WebParam(name = "TYPEPOSTE")String TYPEPOSTE ,
@WebParam(name = "SITE")String SITE,
@WebParam(name = "CONTACT")String CONTACT,
@WebParam(name = "lienoffre")String lienoffre ,
@WebParam(name = "REFAPEC")String REFAPEC) {
//TODO write your implementation code here:
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 + "' );");
return true;
} catch (Exception ex) {
Logger.getLogger(CalculatorService.class.getName()).log(Level.SEVERE, null, ex);
return false;
}
} |
Partager