chuangjianyonghuaction.java~33~

来自「Bug管理系统」· JAVA~33~ 代码 · 共 127 行

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 db.*;
import java.sql.Statement;
import java.sql.ResultSet;
import gerenxinxi.gerenxinxi;
import javax.servlet.http.HttpSession;

public class chuangjianyonghuAction 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 xitongquanxian=f.getXitongquanxian();
        String yidongdianhua=f.getYidongdianhua();
        String yonghuming=f.getYonghuming();
        String zhenshixingming=f.getZhenshixingming();

        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");
        xitongquanxian= new String( xitongquanxian.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");

        //得到对象
        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("")||xitongquanxian.equals("")||querenmima.equals(""))
        {
            xinxi="新建用户失败，用户信息输入不完整！";
        }
        else if(yonghu1.getXitongquanxian().equals("用户管理员")&&(xitongquanxian.equals("1")||xitongquanxian.equals("3")))
        {
            xinxi="您无权限创建过大权限用户";
        }
        else
        {
                //连接数据库
                Db db1 = new Db();
                db1.getCon("bugBarrier");
                //获得表中数据
                Statement stmt = db1.conn.createStatement();
                String s1="insert into yonghu(yonghuming,mima,xitongquanxianid ";
                String s2=") values('"+yonghuming+"','"+mima+"','"+xitongquanxian+"'";
                if(!mimatishi.equals(""))
                {
                    s1=s1+",mimatishi";
                    s2=s2+",'"+mimatishi+"' ";
                }
                if(!zhenshixingming.equals(""))
                {
                    s1=s1+",zhenshixingming";
                    s2=s2+",'"+zhenshixingming+"' ";
                }
                if(!bangongdianhua.equals(""))
                {
                    s1=s1+",bangongdianhua";
                    s2=s2+",'"+bangongdianhua+"' ";
                }
                if(!yidongdianhua.equals(""))
                {
                    s1=s1+",yidongdianhua";
                    s2=s2+",'"+yidongdianhua+"' ";
                }
                if(!msn.equals(""))
                {
                    s1=s1+",msn";
                    s2=s2+",'"+msn+"' ";
                }
                if(!beizhu.equals(""))
                {
                    s1=s1+",beizhu";
                    s2=s2+",'"+beizhu+"' ";
                }
                if(!qq.equals(""))
                {
                    s1=s1+",qq";
                    s2=s2+",'"+qq+"' ";
                }

                String s="";
                s=s1+s2+")";
                System.out.println(s+" 111111111");
                stmt.executeQuery(s); //插入数据
                db1.closeConnection();

                System.out.println("44444444444444444444");
                xinxi="新建用户成功!";
        }
        servletRequest.setAttribute("xinxi",xinxi);
        return actionMapping.findForward("tishixinxi");
    }
}