用户管理系统——编辑用户

cstm.dao

public Customer findByCid(String cid){
		try {
		String sql="select * from t_customer where cid=?";
		return qr.query(sql, new BeanHandler <Customer>(Customer.class),cid);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			throw new RuntimeException(e);
		}
	}
	/**
	 * 编辑用户后，保存到数据库
	 */
	public void edit(Customer c){
		try {
		String sql="update t_customer set cname=?,gender=?,birthday=?," +
				"cellphone=?,email=?,description=? where cid=?" ;
		Object [] params={c.getCname(),c.getGender(),c.getBirthday(),
				c.getCellphone(),c.getEmail(),c.getDescription(),c.getCid()};
		
			qr.update(sql,params);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			throw new RuntimeException(e);
		}
	}

cstm.service

public Customer load(String cid){
		return customerDao.findByCid(cid);
	}
	/**
	 * 编辑用户后，保存
	 */
	public void edit(Customer c){
		customerDao.edit(c);
	}

cstm.servlet

public String preEdit(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		String cid=request.getParameter("cid");
		Customer c=customerService.load(cid);
		request.setAttribute("cstm", c);
		return "f:/edit.jsp";
	}
	public String edit(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		Customer c=CommonUtils.toBean(request.getParameterMap(), Customer.class);
		customerService.edit(c);
		request.setAttribute("msg", "编辑成功！");
		return "f:/msg.jsp";
	}