abak001servlet.java

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

package com.sxit.pim.black;

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>类名: ABAK001Servlet</p>
 * <p>功能: 显示黑名单信息列表</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2006-01-09
 * @修改纪录
 */

public class ABAK001Servlet extends ServletAdminBase{
     public ABAK001Servlet(){
          super();
          operationRight = "ABAK0,1";
     }
     public String perform(HttpServletRequest request, HttpServletResponse response) throws Exception{

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

          TblackList tblacklist=null;

          Topmuser myMember=(Topmuser)request.getSession().getAttribute("_currentUser");
          try{

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

               String strSearch="";

               String selectID=request.getParameter("selectID");
               String selectMsg=request.getParameter("selectMsg");

               if(selectID==null){
                    selectID="0";
               }
               if(selectMsg==null){
                    selectMsg="";
               }
               if(selectID.equals("0")){
                    strSearch="";
               }else if(selectID.equals("1") && !selectMsg.equals("")){
                    strSearch=" and (a.mdn like '%"+selectMsg+"%')";
               }

               //过滤数据，用户只能看属于自己的数据
               strSearch+=" and a.corporationid in ("+myMember.getTemp2()+")";

               //在此加入查询域，以下是下拉表单查询代码和多个查询域
               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.createdate between to_date('"+fromDate+"','YYYY-MM-DD') and to_date('"+toDate+"','YYYY-MM-DD')+1 ";

               Hashtable recSearch=new Hashtable();
               recSearch.put("selectID",selectID);
               recSearch.put("selectMsg",selectMsg);
               recSearch.put("toDate",toDate);
               recSearch.put("fromDate",fromDate);

               //在此加入List调用
               tblacklist=new TblackList();
               tblacklist.createList1(con,pageNo,pageSize,strSearch);
               tblacklist.setRecSearch(recSearch);

               //在此加入List传递到JSP
               request.setAttribute("tblacklist",tblacklist);

               nextPage="/abak/abak001.jsp";
//               writeLog("ABAK",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示黑名单信息列表成功");

          }
          catch (SQLException e){
               System.out.println(e);
               request.setAttribute("messageID","显示黑名单信息列表数据错");
               request.setAttribute("returnPage","../abak/abak001");
               nextPage="/abak/abakmessage.jsp";
               writeLog("ABAK",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示黑名单信息列表数据错");
          }
          catch (Exception e){
               System.out.println(e);
               request.setAttribute("messageID","显示黑名单信息列表系统错");
               request.setAttribute("returnPage","../abak/abak001");
               nextPage="/abak/abakmessage.jsp";
               writeLog("ABAK",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示黑名单信息列表系统错");
          }finally{
               ConnPoolHandler.closeConnection(con);
          }
          javax.servlet.RequestDispatcher rd =getServletContext().getRequestDispatcher(nextPage);
          rd.forward(request,response);
          return nextPage;
     }
}