mail_optionok.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.*" %>
<%@ include file="/userinfor.jsp" %>
<%
try {
    out.println("正在添加数据.......");
    String importance = Convert.toGBK(request.getParameter("importance"));
    String reach = Convert.toZeroStr(request.getParameter("reach"));
    String read = Convert.toZeroStr(request.getParameter("read"));
    String reply  = Convert.toZeroStr(request.getParameter("reply"));
    String replyto  = Convert.toZeroStr(request.getParameter("replyto"));
    String replyName  = Convert.toGBK(request.getParameter("replyName"));
    String replyto2  = Convert.toGBK(request.getParameter("replyto2"));
    String folder = Convert.toZeroStr(request.getParameter("folder"));
    String saveto = Convert.toZeroStr(request.getParameter("saveto"));

    if (saveto.equals("0")) {
        saveto = "2";
    }

    DataConn dataConn = new DataConn();
    String sTable = "";
    String sField = "";
    String sValue = "";
    String sSZID = "0";
    int userid = userInfor_session.getYGID();
    sTable = "OA_YJSZ";

    boolean flag = true;
    int iReturn = 0;
    DataAction dataAction = new DataAction(dataConn);
    flag = dataAction.isExist("OA_YJSZ", "SZRY=" + userid);
    if (flag) {
        String field_str[] = {
            "SZRY","SZZY","SZSD","SZYD","SZHF","SZHFID","SZHFRY","SZHFDZ","SZBC"
            };
        String value_str[] = {
            String.valueOf(userid),
            "'" + importance + "'",
            reach,
            read,
            reply,
            replyto,
            "'"+replyName+"'",
            "'"+replyto2+"'",
            saveto
        };
        flag = dataAction.update(sTable, field_str, value_str, "SZRY=" + userid);
    }
    else {
        System.out.print("ff12");
        sSZID = String.valueOf(KeyGenerator.getInstance().getNextKey(sTable));

        sField = "SZID,SZRY,SZZY,SZSD,SZYD,SZHF,SZHFID,SZHFRY,SZHFDZ,SZBC";
        sValue = sSZID + "," + userid + ",'" + importance + "',"+reach+","+read+","+reply+","+replyto+",'"+replyName+"','"+replyto2+"',"+saveto;
        flag = dataAction.add(sTable, sField, sValue);
    }

    String sHref = "";
    String strMessage = "";
    if (!flag) {
        strMessage = dataAction.getMessage();
        out.println("<Script Language='javaScript'>");
        out.println("alert('" + strMessage + "');");
        out.println("history.go(-1);");
        out.println("</Script>");
    } else {
        sHref = "mail_option.jsp";
        out.println("<Script Language='javaScript'>");
        out.println("document.location.href=\""+sHref+"\"");
        out.println("</Script>");
    }

    if (dataConn != null) {
        dataConn.close();
    }
}
catch(Exception e) {
    System.out.println("Error="+e);
}
%>