OA系统

开发平台：

Java

UserModAction.java~18~：源码内容

							package officeol.mc.actions;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionForm;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.Action;
import officeol.mc.tools.*;
public class UserModAction extends Action {
    public ActionForward execute(ActionMapping mapping, ActionForm form,
                                 HttpServletRequest request,
                                 HttpServletResponse response) {
        try{
            DBConn dbc = new DBConn();
            Tool tl  = new Tool();
            String un = request.getParameter("username");
            if(un==null){
                request.setAttribute("msg", "请选择用户！");
                return mapping.findForward("err");
            }
            String dep = request.getParameter("dep");
            String sql = "update [user] set deparment = '"+dep+"' where unmd5='"+un+"'";
            int i = dbc.executeUpdate(sql);
            if(i!=0){
                request.setAttribute("msg", "用户 " + un + " 修改成功！");
                return mapping.findForward("succ");
            }else{
                request.setAttribute("msg", "用户 " + un + " 修改出错，请重试！");
                return mapping.findForward("err");
            }
        }catch(Exception ex){
            ex.printStackTrace();
            request.setAttribute("msg","用户修改出现异常，请重试！");
        }
        return mapping.findForward("err");
    }
}

						