@GetMapping("/select") public List<Map<String,Object>> userList(){ String sql = "SELECT * FROM user"; List<Map<String, Object>> maps = jdbcTemplate.queryForList(sql); return maps; }
@GetMapping("/add") public String addUser(){ String sql = "INSERT INTO USER VALUES(3,'王五')"; jdbcTemplate.update(sql); return"添加完成"; }
@GetMapping("/update/{id}") public String updateUser(@PathVariable("id")int id){ String sql = "UPDATE user SET id=4,name='赵六' WHERE id="+id; jdbcTemplate.update(sql); return"修改完成"; }
@GetMapping("/delete/{id}") public String deleteUser(@PathVariable("id")int id){ String sql = "DELETE FROM user WHERE id=?"; jdbcTemplate.update(sql,id); return"删除成功"; } }