UserModAction.java~19~
资源名称:bangong.rar [点击查看]
上传用户:dlqqsh
上传日期:2021-11-13
资源大小:7840k
文件大小:2k
源码类别:
OA系统
开发平台:
Java
- 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 unmd5 = request.getParameter("username");
- if(unmd5==null){
- request.setAttribute("msg", "请选择用户!");
- return mapping.findForward("err");
- }
- String dep = request.getParameter("dep");
- String un = request.getParameter("un");
- 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");
- }
- }