java增删改查设计_增删改查 · 如何设计一个JavaWeb MVC框架 · 看云

# 增删改查

```java

/**

* 用户控制器

*/

public class UserController {

/**

* 用户列表

* @param request

* @param response

*/

public void users(Request request, Response response){

List 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 map = new HashMap();

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 map = new HashMap();

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 map = new HashMap();

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)