Update row with spring jdbctemplate

Question

I am new to spring. I am developing a CRUD application using spring jdbc template. I finished with the insert and select. but in the update, they encounter some problems. can anyone provide me a simple example of updating and deleting using jdbctemplate. thrks in advance.

MY CONTROLLER -

@RequestMapping(method = RequestMethod.GET) public String showUserForm(@ModelAttribute(value="userview") User user,ModelMap model) { List list=userService.companylist(); model.addAttribute("list",list); return "viewCompany"; } @RequestMapping( method = RequestMethod.POST) public String add(@ModelAttribute(value="userview") @Valid User user, BindingResult result) { userValidator.validate(user, result); if (result.hasErrors()) { return "viewCompany"; } else { userService.updateCompany(user); System.out.println("value updated"); return "updateSuccess"; } 

when I click the update button, the edited values ​​should be updated in my DB according to the row id, my problem is how to match the row id from jsp to the controller.

Answer 1

Straight from the documentation :

The following example shows a column updated for a specific primary key. In this example, the SQL statement has placeholders for the string parameters. Parameter values ​​can be passed as varargs or alternatively as an array of objects. Thus, primitives must be wrapped in primitive wrapper classes explicitly or using auto-boxing.

 import javax.sql.DataSource; import org.springframework.jdbc.core.JdbcTemplate; public class ExecuteAnUpdate { private JdbcTemplate jdbcTemplate; public void setDataSource(DataSource dataSource) { this.jdbcTemplate = new JdbcTemplate(dataSource); } public void setName(int id, String name) { this.jdbcTemplate.update( "update mytable set name = ? where id = ?", name, id); } } 

Answer 2

You can simply use request.getParamater() or command object to pass values ​​from jsp to the controller.