public class ClientAddSubmit extends Action {
// --------------------------------------------------------- Instance Variables
// --------------------------------------------------------- Methods
protected void insertUser(ActionForm form)
throws Exception,SQLException{
String user = null;
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
/*ServletContext context = servlet.getServletContext();
DataSource dataSource = (DataSource)
context.getAttribute(Action.DATA_SOURCE_KEY);*/
DataSource dataSource = (DataSource)
servlet.getServletContext().getAttribute(Action.DATA_SOURCE_KEY);
System.out.println("Debuttry");
try{
ClientAddForm cForm = (ClientAddForm) form;
conn = dataSource.getConnection();
stmt = conn.createStatement();
System.err.println("Test");
StringBuffer sqlString = new StringBuffer("insert into client");
sqlString.append("values (\"2" + "\",");
sqlString.append("values (\""
+ cForm.getTitre() + "\",");
sqlString.append("values (\""
+ cForm.getNom() + "\",");
sqlString.append("values (\""
+ cForm.getPrenom() + "\",");
sqlString.append("values (\""
+ cForm.getLogin() + "\",");
sqlString.append("values (\""
+ cForm.getPwd() + "\",");
sqlString.append("values (\""
+ cForm.getAdresse() + "\",");
sqlString.append("values (\""
+ cForm.getVille() + "\",");
sqlString.append("values (\""
+ cForm.getCodepostale() + "\",");
sqlString.append("values (\""
+ cForm.getMail() + "\",");
stmt.execute(sqlString.toString());
System.out.println(sqlString);
}
finally{
if (rs != null){
rs.close();
}
if (stmt != null){
stmt.close();
}
if(conn != null){
conn.close();
}
}System.out.println("Fintry");
}
/**
* Method execute
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(
ActionMapping mapping,
ActionForm form,
HttpServletRequest request,
HttpServletResponse response)
throws IOException ,ServletException {
//Cible par défaut en cas de succès
String target = new String ("success");
System.out.println("Debuttry1");
try{
insertUser(form);
}
catch (Exception e){
System.err.println("Setting target to error");
target = new String("error");
ActionErrors errors = new ActionErrors();
errors.add(ActionErrors.GLOBAL_ERROR,
new ActionError("error.database.error",e.getMessage()));
if(!errors.isEmpty()){
saveErrors(request,errors);
}
}
return (mapping.findForward(target));
}
}
Partager