mardi 3 mars 2015

Error in delete a user in spring mvc

I can't delete a user. This is the error i get when i click the delete button. org.springframework.dao.TransientDataAccessResourceException: PreparedStatementCallback; SQL [DELETE FROM users WHERE id = '1']; Parameter index out of range (1 > number of parameters, which is 0).; nested exception is java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). Please help thanks a lot


Jdbc function of delete



public int deleteUser(int id){
String SQL = "DELETE FROM users WHERE id = '"+id+"'";
System.out.print(SQL);
int user = jdbcTemplateObject.update(SQL, id);
return user;
}


delete controller



RequestMapping(value = "/delete", method = RequestMethod.GET)
public ModelAndView delete(@ModelAttribute("SpringWeb")User user, ModelMap model, HttpServletRequest request)
{
try
{
SyntacksJdbc syntacksJdbc = (SyntacksJdbc)context.getBean("syntacksJdbc");
System.out.println(request.getParameter("id"));
int id = Integer.parseInt(request.getParameter("id"));
int user1 = syntacksJdbc.deleteUser(id);
model.addAttribute("message", "Questions updated successfully.");
}
catch(Exception e)
{
System.out.print(e);
model.addAttribute("message", "Error occured in posting question.");
}

return new ModelAndView("users");


on my jsp button



<a href="/Project/delete?id=${user.id}" name="delete"><button type= submit>Delete</button>

Aucun commentaire:

Enregistrer un commentaire