pop_addok.jsp

一个做得非常好的电子政务系统

<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.ijipin.tool.*" %>
<%@ page import="com.ijipin.database.*" %>
<%@ page import="com.ijipin.property.*" %>
<%@ include file="/userinfor.jsp" %>
<%@ include file="/share/page/page_request.jsp"%>
<%@ page import="com.ijipin.oa.mail.*" %>
<%
try {
    String sName     =  Convert.toGBK(request.getParameter("name"));
    String sPop      =  Convert.toGBK(request.getParameter("pop"));
    String sSmtp     =  Convert.toGBK(request.getParameter("smtp"));
    String sLogin    =  Convert.toGBK(request.getParameter("login"));
    String sPassword =  request.getParameter("password");
    String sEmailAddr=  Convert.toGBK(request.getParameter("email_address"));
    String sFolder   =  Convert.toZeroStr(request.getParameter("folder"));
    String sAuth     =  Convert.toZeroStr(request.getParameter("auth"));
    String sDefault  =  Convert.toZeroStr(request.getParameter("default"));

    DataConn dataConn = new DataConn();
    DataAction dataAction = new DataAction(dataConn);
    boolean flag = true;
    int userid = userInfor_session.getYGID();
    String sTable = "OA_YJZH";
    String sField = "ZHID,ZHRY,ZHMC,ZHPOP,ZHSMTP,ZHYH,ZHWJJ,ZHMR,ZHYZ,ZHDZ";
    String sCond  = "ZHRY="+userid + " and ZHMC='" + sName + "'";
    flag = dataAction.isExist(sTable, sCond);
    if (flag) {
        out.println("<Script Language='javaScript'>");
        out.println("alert('帐号名称已经存在，请重新填写！')");
        out.println("history.go(-1);");
        out.println("</Script>");
    }
    else {
        int iZHID =KeyGenerator.getInstance().getNextKey(sTable);
        String sValue = iZHID + "," +userid+ ",'" + sName + "','"+sPop+"','"+sSmtp+"','"+sLogin+"',"+sFolder+
                ","+sDefault+","+sAuth + ",'"+ sEmailAddr + "'";

        flag = dataAction.add(sTable, sField, sValue);
        ///////////////密码带有","和"'"的时候？？？
        //密码加密
        //indollar.com.oa.security.encryption encryClass = new indollar.com.oa.security.encryption();
        //sPassword = encryClass.getEncrypt(sPassword);
        //
        if (flag) {
            sCond =  "ZHID="+ iZHID;
            flag = dataAction.update(sTable,"ZHMM='"+sPassword + "'",sCond);
        }

        String sHref = "";
        if ( flag) {
            sHref = "pop_list.jsp";
            out.println("<Script Language='javaScript'>");
            out.println("document.location.href=\""+sHref+"\"");
            out.println("</Script>");
        }
        else {
            out.println("<Script Language='javaScript'>");
            out.println("alert('异常！')");
            out.println("history.go(-1);");
            out.println("</Script>");
        }

	if (dataConn != null) {
	    dataConn.close();
	}
    }

}
catch(Exception eeee) {}

%>