# 增删改查

```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("[/]+", "/"));
	}
}
```

![](http://i5.tietuku.com/b77fdcfe2cecf753.png)

+ [演示程序代码](https://github.com/junicorn/mario-sample)
+ [Blade框架](https://github.com/biezhi/blade)

## links
   * [目录](<index.md>)
   * 上一节: [数据库操作](<6.dbutil.md>)