增删改查

/**
 * 用户控制器
 */
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("[/]+", "/"));
    }
}

results matching ""

    No results matching ""