Get parameters from the URL with JSP

Question

In JSP how do I get parameters from the URL?

For example, I have a URL somesite.com/Transaction_List.jsp?accountID=5

Can I use  request.getAttribute( "accountID" ) like there is for sessions or something similar?

Answer 1

To delete the subject record with its subject_id

@RequestMapping(value="subject_setup/delete/{subjectid}",method = RequestMethod.GET)
public ModelAndView delete(@PathVariable int subjectid) {
    subjectsDao.delete(subjectid);
    return new ModelAndView("redirect:/subject_setup");
}

and the parameter will be used for input on your query

public int delete(int subjectid) {
    String sql = "update tbl_subject set isdeleted= '1' where id = "+subjectid+"";
    return template.update(sql);
}