apus001servlet.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.pim.push;

import com.sxit.common.*;
import com.sxit.operator.*;
import javax.servlet.http.*;
import javax.servlet.*;
import java.util.*;
import java.sql.*;
import java.io.*;

/**
 * <p>类名: APUS001Servlet</p>
 * <p>功能: 显示push管理列表</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2005-12-15
 * @修改纪录
 */

public class APUS001Servlet
    extends ServletAdminBase {
    public APUS001Servlet() {
        super();
        operationRight = "APUS0,1";
    }

    public String perform(HttpServletRequest request,
                          HttpServletResponse response) throws Exception {

        Connection con = null;
        String nextPage = "";
        int pageSize = 10;
        int pageNo = 1;

        TpushList tpushlist = null;

        Topmuser myMember = (Topmuser) request.getSession().getAttribute(
            "_currentUser");
        String Curr_CorId = myMember.getTemp2();
        //   System.out.println("Curr_CorId::::::::::"+Curr_CorId);
        Topmcorporation tomc = new Topmcorporation();
        try {

            con = ConnPoolHandler.getConnection();
            //  tomc.create(con,Curr_CorId);
            if (request.getParameter("pageNo") != null &&
                !request.getParameter("pageNo").equals("")) {
                pageNo = Integer.parseInt(request.getParameter("pageNo"));
            }
            pageSize = Integer.parseInt(getConfig("APUS", "pageSize"));
            if (request.getParameter("pageSize") != null &&
                !request.getParameter("pageSize").equals("")) {
                pageSize = Integer.parseInt(request.getParameter("pageSize"));
            }

            String strSearch = "and a.status=1";
            String selectID = request.getParameter("selectID");
            String selectMsg = request.getParameter("selectMsg");

            if (selectID == null) {
                selectID = "0";
            }
            if (selectMsg == null) {
                selectMsg = "";
            }
            if (selectID.equals("0")) {
                strSearch = strSearch + " and a.corporationid in (" +
                    Curr_CorId + ") ";

            }
            else if (selectID.equals("1") && !selectMsg.equals("")) {
                strSearch = " and (a.tomdn like '" + selectMsg + "%')";
                strSearch = strSearch + " and a.corporationid in (" +
                    Curr_CorId + ")";
            }
            else if (selectID.equals("2") && !selectMsg.equals("")) {
                strSearch = " and (a.frommdn like '" + selectMsg + "%')";
                strSearch = strSearch + " and a.corporationid in (" +
                    Curr_CorId + ") ";
            }
            else if (selectID.equals("3") && !selectMsg.equals("")) {
                strSearch = " and (a.title like '" + selectMsg + "%')";
                strSearch = strSearch + " and a.corporationid in (" +
                    Curr_CorId + ")";
            }
            else if (selectID.equals("4") && !selectMsg.equals("")) {
                strSearch = " and (a.url like '" + selectMsg + "%')";
                strSearch = strSearch + " and a.corporationid in (" +
                    Curr_CorId + ") ";
            }
            else if (selectID.equals("5") && !selectMsg.equals("")) {
                strSearch = " and (b.channel_name like '" + selectMsg + "%')";
                strSearch = strSearch + " and a.corporationid in (" +
                    Curr_CorId + ") ";
            }

            int yyyy, mm, dd;
            Calendar c = Calendar.getInstance();
            yyyy = c.get(Calendar.YEAR);
            mm = c.get(Calendar.MONTH) + 1;
            dd = c.get(Calendar.DAY_OF_MONTH);
            String fromDate = yyyy + "-" + (mm < 10 ? "0" : "") + mm + "-" +
                (dd < 10 ? "0" : "") + dd;
            // fromDate="2005-01-01";
            String toDate = yyyy + "-" + (mm < 10 ? "0" : "") + mm + "-" +
                (dd < 10 ? "0" : "") + dd;
            if (request.getParameter("fromDate") != null &&
                !"".equals(request.getParameter("fromDate"))) {
                fromDate = request.getParameter("fromDate");
            }
            if (request.getParameter("toDate") != null &&
                !"".equals(request.getParameter("toDate"))) {
                toDate = request.getParameter("toDate");
            }
            strSearch = strSearch + " and a.systime between to_date('" +
                fromDate + "','YYYY-MM-DD') and to_date('" + toDate +
                "','YYYY-MM-DD')+1 order by systime desc";
            //    System.out.println("date:::::::"+fromDate+"ddd:::::::::::"+toDate);
            //过滤数据，用户只能看属于自己的数据
            Hashtable recSearch = new Hashtable();
            recSearch.put("selectID", selectID);
            recSearch.put("selectMsg", selectMsg);
            recSearch.put("toDate", toDate);
            recSearch.put("fromDate", fromDate);
            //在此加入List调用
            tpushlist = new TpushList();
            //System.out.println("strSearch" + strSearch);
            tpushlist.createList1(con, pageNo, pageSize, strSearch);
            tpushlist.setRecSearch(recSearch);
            //在此加入List传递到JSP
            request.setAttribute("tpushlist", tpushlist);
            nextPage = "/apus/apus001.jsp";
        }
        catch (SQLException e) {
            System.out.println(e);
            request.setAttribute("messageID", "显示push管理列表数据错");
            request.setAttribute("returnPage", "../apus/apus001");
            nextPage = "/apus/apusmessage.jsp";
            writeLog("APUS", LogManager.LOGTYPE_APP, myMember.getStaffid(),
                     "显示push管理列表数据错");
        }
        catch (Exception e) {
            System.out.println(e);
            request.setAttribute("messageID", "显示push管理列表系统错");
            request.setAttribute("returnPage", "../apus/apus001");
            nextPage = "/apus/apusmessage.jsp";
            writeLog("APUS", LogManager.LOGTYPE_APP, myMember.getStaffid(),
                     "显示push管理列表系统错");
        }
        finally {
            ConnPoolHandler.closeConnection(con);
        }
        javax.servlet.RequestDispatcher rd = getServletContext().
            getRequestDispatcher(nextPage);
        rd.forward(request, response);
        return nextPage;
    }
}