chuangjianyonghuaction.java~36~

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

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;
import yonghu.*;

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
        {
            yonghuliebiao yl=new yonghuliebiao();
            if(!yl.panduanyonghu(yonghuming))
            {

                //连接数据库
                Db db1 = new Db();
                db1.getCon("bugBarrier");

                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 + ")";

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

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