# 增刪改查
```java
/**
* 用戶控制器
*/
public class UserController {
/**
* 用戶列表
* @param request
* @param response
*/
public void users(Request request, Response response){
List<User> users = MarioDb.getList("select * from t_user", User.class);
request.attr("users", users);
response.render("users");
}
/**
* 添加用戶界面
* @param request
* @param response
*/
public void show_add(Request request, Response response){
response.render("user_add");
}
/**
* 保存方法
* @param request
* @param response
* @throws ParseException
*/
public void save(Request request, Response response) throws ParseException{
String name = request.query("name");
Integer age = request.queryAsInt("age");
String date = request.query("birthday");
if(null == name || null == age || null == date){
request.attr("res", "error");
response.render("user_add");
return;
}
Date bir = new SimpleDateFormat("yyyy-MM-dd").parse(date);
int res = MarioDb.insert("insert into t_user(name, age, birthday)", name, age, bir);
if(res > 0){
String ctx = MarioContext.me().getContext().getContextPath();
String location = ctx + "/users";
response.redirect(location.replaceAll("[/]+", "/"));
} else {
request.attr("res", "error");
response.render("user_add");
}
}
/**
* 編輯頁面
* @param request
* @param response
*/
public void edit(Request request, Response response){
Integer id = request.queryAsInt("id");
if(null != id){
Map<String, Object> map = new HashMap<String, Object>();
map.put("id", id);
User user = MarioDb.get("select * from t_user where id = :id", User.class, map);
request.attr("user", user);
response.render("user_edit");
}
}
/**
* 修改信息
* @param request
* @param response
*/
public void update(Request request, Response response){
Integer id = request.queryAsInt("id");
String name = request.query("name");
Integer age = request.queryAsInt("age");
if(null == id || null == name || null == age ){
request.attr("res", "error");
response.render("user_edit");
return;
}
Map<String, Object> map = new HashMap<String, Object>();
map.put("id", id);
map.put("name", name);
map.put("age", age);
int res = MarioDb.update("update t_user set name = :name, age = :age where id = :id", map);
if(res > 0){
String ctx = MarioContext.me().getContext().getContextPath();
String location = ctx + "/users";
response.redirect(location.replaceAll("[/]+", "/"));
} else {
request.attr("res", "error");
response.render("user_edit");
}
}
/**
* 刪除
* @param request
* @param response
*/
public void delete(Request request, Response response){
Integer id = request.queryAsInt("id");
if(null != id){
Map<String, Object> map = new HashMap<String, Object>();
map.put("id", id);
MarioDb.update("delete from t_user where id = :id", map);
}
String ctx = MarioContext.me().getContext().getContextPath();
String location = ctx + "/users";
response.redirect(location.replaceAll("[/]+", "/"));
}
}
```
+ [演示程序代碼](https://github.com/junicorn/mario-sample)
+ [Blade框架](https://github.com/biezhi/blade)
