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 36 37
|
@WebMethod(operationName = "InsertionDonnees")
public String InsertionDonnees(@WebParam(name = "nomsociete")String nomsociete,
@WebParam(name = "TYPEPROPOSITION")String TYPEPROPOSITION,
@WebParam(name = "DATEPROPOSITION") Date 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) {
String marequete="";
try {
connect();
String sql = "INSERT INTO proposition (idproposition,nomsociete,TYPEPROPOSITION,DATEPROPOSITION,TYPEPOSTE,SITE,CONTACT,lienoffre,REFAPEC) values (SEQOFFRE.nextval, ?,?,?,?,?,?,?,?)";
try(PreparedStatement st = conn.createPStatement()){
st.setString(1,nomsociete);
st.setString(2,TYPEPROPOSITION);
st.setDate(3,new java.sql.Date(DATEPROPOSITION.getTime()));
st.setString(4,TYPEPOSTE);
st.setString(5,SITE);
st.setString(6,CONTACT);
st.setString(7,lienoffre);
st.setString(8,REFAPEC);
st.executeQuery().close();
return "ok";
}
} catch (Exception ex) {
Logger.getLogger(CalculatorService.class.getName()).log(Level.SEVERE, null, ex.toString());
return ex.toString();
} finally {
//Fermer la connextion!
disconnect();
}
} |
Partager