xiugaiyonghu2action.java

Bug管理系统

package tmp;

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 yonghu.xitongquanxianliebiao;
import gerenxinxi.gerenxinxi;
import javax.servlet.http.HttpSession;
import db.Db;
import java.sql.Statement;
import yonghu.yonghuliebiao;

public class xiugaiyonghu2Action extends Action {
    public ActionForward execute(ActionMapping actionMapping,
                                 ActionForm actionForm,
                                 HttpServletRequest servletRequest,
                                 HttpServletResponse servletResponse)throws Exception {
        chuanjianyonghuActionForm f = (chuanjianyonghuActionForm) actionForm;
        //个人信息
         String bangongdianhua=f.getBangongdianhua();
         String beizhu=f.getBeizhu();
         String mima=f.getMima();
         String mimatishi=f.getMimatishi();
         String msn=f.getMsn();
         String qq=f.getQq();
         String querenmima=f.getQuerenmima();
         String xitongquanxianId=f.getXitongquanxian();
         String yidongdianhua=f.getYidongdianhua();
         String yonghuming=f.getYonghuming();
         String zhenshixingming=f.getZhenshixingming();
         String yonghuId=f.getYonghuid();

         bangongdianhua= new String( bangongdianhua.getBytes("ISO-8859-1"), "gbk");
         beizhu= new String( beizhu.getBytes("ISO-8859-1"), "gbk");
         mima= new String(mima.getBytes("ISO-8859-1"), "gbk");
         mimatishi= new String(mimatishi.getBytes("ISO-8859-1"), "gbk");
         msn= new String(msn.getBytes("ISO-8859-1"), "gbk");
         qq= new String(qq.getBytes("ISO-8859-1"), "gbk");
         querenmima= new String(querenmima.getBytes("ISO-8859-1"), "gbk");
         xitongquanxianId= new String( xitongquanxianId.getBytes("ISO-8859-1"), "gbk");
         yidongdianhua= new String( yidongdianhua.getBytes("ISO-8859-1"), "gbk");
         yonghuming= new String(yonghuming.getBytes("ISO-8859-1"), "gbk");
         zhenshixingming= new String( zhenshixingming.getBytes("ISO-8859-1"), "gbk");
         yonghuId= new String(yonghuId.getBytes("ISO-8859-1"), "gbk");

         //System.out.println("yonghuId:"+yonghuId+" zhenshixingming:"+zhenshixingming+" yonghuming:"+yonghuming+" yidongdianhua:"+yidongdianhua+" xitongquanxianId:"+xitongquanxianId+" bangongdianhua:"+bangongdianhua+" beizhu:"+beizhu+" mima:"+mima+" mimatishi:"+mimatishi+" msn:"+msn+" qq:"+qq+" querenmima:"+querenmima);

         //得到用户对象
         HttpSession session = servletRequest.getSession();
         gerenxinxi yonghu1 = (gerenxinxi) session.getAttribute("yonghu1");


         //参数：系统权限
         xitongquanxianliebiao xl=new xitongquanxianliebiao();
         servletRequest.setAttribute("xl", xl);

//
         String xinxi="";
         if(!mima.equals(querenmima))
         {
             xinxi="修改用户失败，密码输入不一致！";
         }
         else if(yonghuming.equals("")||mima.equals("")||xitongquanxianId.equals("")||querenmima.equals(""))
         {
             xinxi="修改用户失败，用户信息输入不完整！";
         }
         else if(yonghu1.getXitongquanxian().equals("用户管理员")&&(xitongquanxianId.equals("1")||xitongquanxianId.equals("3")))
         {
             xinxi="修改用户失败，您无权限修改过大权限用户！";
         }
         else
         {
             yonghuliebiao yl=new yonghuliebiao();

                 //连接数据库
                 Db db1 = new Db();
                 db1.getCon("bugBarrier");
                 //
                 String s1 ="update yonghu set yonghuming='"+yonghuming+"'";
                 String s2 = "where yonghuid='"+yonghuId+"'";

                 if(!mima.equals(""))
                 {
                     s1=s1+",mima='"+mima+"'";
                 }
                 if(!mimatishi.equals(""))
                {
                    s1=s1+",mimatishi='"+mimatishi+"'";
                }
                if(!zhenshixingming.equals(""))
                {
                    s1=s1+",zhenshixingming='"+zhenshixingming+"'";
                }
                if(!bangongdianhua.equals(""))
               {
                   s1=s1+",bangongdianhua='"+bangongdianhua+"'";
               }
               if(!yidongdianhua.equals(""))
               {
                   s1=s1+",yidongdianhua='"+yidongdianhua+"'";
               }
               if(!msn.equals(""))
              {
                  s1=s1+",msn='"+msn+"'";
              }
              if(!beizhu.equals(""))
              {
                  s1=s1+",beizhu='"+beizhu+"'";
              }
              if(!xitongquanxianId.equals(""))
             {
                 s1=s1+",xitongquanxianId='"+xitongquanxianId+"'";
             }
             if(!qq.equals(""))
             {
                 s1=s1+",qq='"+qq+"'";
             }

                 String s = "";
                 s = s1 + s2;

                 //System.out.println(s);
                 //获得表中数据
                 Statement stmt = db1.conn.createStatement();
                 stmt.execute(s); //插入数据
                 db1.closeConnection();

                 xinxi = "修改用户成功!";
             }

         servletRequest.setAttribute("xinxi",xinxi);
         return actionMapping.findForward("tishixinxi");
    }
}