Spring Boot快速搭建web项目,完成数据库的增删改查操作
本文直接讲解编写数据库的增删改查操作的编写
连接上文地址:Spring Boot快速搭建web项目
1.本此开发使用RESTFUL风格编写
请求地址 | 请求方式 | 方法作用 |
---|---|---|
/user | GET | 查询所有user |
/user | PUT | 修改一个user |
/user | POST | 添加一个user |
/user/id | DELETE | 删除一个user |
/user/id | GET | 查询一个user |
2.编写Usermapper接口
@Mapper
public interface UserMapper {
//查询所有User
@Select("select * from user")
public List<User> findAll();
@Select("select * from user where id = #{id}")
//查询一个User
public User findUserById(Integer id);
@Update("update user set username = '${username}',birthday = #{birthday},sex = #{sex},address = #{address} where id = #{id}")
//修改User
public int updateUser(User user);
@Insert({
"insert into user(username,birthday,sex,address) values (#{username},#{birthday},#{sex},#{address})"})
//添加一个User
public int addUser(User user);
//删除一个User
@Delete("delete from user where id = #{id}")
public int deleteUser(Integer id);
}
3.编写Controller
- @PathVariable 用于获取地址栏的参数,一般处理get和delete请求
- @RequestParam 用于获取表单参数,一般用于处理post和put请求
@RestController
public class UserController {
@Autowired
UserMapper userMapper;
/**
* 查询所有user
* @return
*/
@GetMapping("/user")
public List<User> findAll(){
return userMapper.findAll();
}
/**
* 根据id查询一个user
* @param id
* @return
*/
@GetMapping("/user/{id}")
public User findUserById(@PathVariable("id") Integer id){
return userMapper.findUserById(id);
}
/**
* 修改user
* @param id
* @param username
* @param birthday
* @param sex
* @param address
* @return
* @throws ParseException
*/
@PutMapping("/user")
public String update(@RequestParam("id") String id,
@RequestParam("username") String username,
@RequestParam("birthday") String birthday,
@RequestParam("sex") String sex,
@RequestParam("address") String address) throws ParseException {
User user = new User();
user.setId(Integer.parseInt(id));
user.setUsername(username);
//对日期进行格式转换
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
Date date = format.parse(birthday);
user.setBirthday(date);
user.setSex(sex);
user.setAddress(address);
return userMapper.updateUser(user) == 1 ? "success" : "failed";
}
/**
* 新增一个user
* @param username
* @param birthday
* @param sex
* @param address
* @return
*/
@PostMapping("/user")
public String insertUser(@RequestParam("username") String username,
@RequestParam("birthday") String birthday,
@RequestParam("sex") String sex,
@RequestParam("address") String address) throws ParseException {
User user = new User();
user.setUsername(username);
SimpleDateFormat format = new SimpleDateFormat("