acha001servlet.java

来自「WAP PUSH后台源码,WAP PUSH后台源码」· Java 代码 · 共 105 行

package com.sxit.pim.channel;

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>类名: ACHA001Servlet</p>
 * <p>功能: 显示业务管理列表</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2005-12-14
 * @修改纪录
 */

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

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

          TchannelList tchannellist=null;

          Topmuser myMember=(Topmuser)request.getSession().getAttribute("_currentUser");
        String  Curr_CorId = myMember.getTemp2();
        //  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("ACHA","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 = " and a.corporationid in ("+Curr_CorId+")";
               }else if(selectID.equals("1") && !selectMsg.equals("")){
                    strSearch=" and (a.channel_name like '%"+selectMsg+"%')";
                      strSearch = strSearch + " and a.corporationid in (" +Curr_CorId + ")";
               }

               //过滤数据，用户只能看属于自己的数据
               Hashtable recSearch=new Hashtable();
               recSearch.put("selectID",selectID);
               recSearch.put("selectMsg",selectMsg);

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

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

               nextPage="/acha/acha001.jsp";
//               writeLog("ACHA",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示业务管理列表成功");

          }
          catch (SQLException e){
               System.out.println(e);
               request.setAttribute("messageID","显示业务管理列表数据错");
               request.setAttribute("returnPage","../acha/acha001");
               nextPage="/acha/achamessage.jsp";
               writeLog("ACHA",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示业务管理列表数据错");
          }
          catch (Exception e){
               System.out.println(e);
               request.setAttribute("messageID","显示业务管理列表系统错");
               request.setAttribute("returnPage","../acha/acha001");
               nextPage="/acha/achamessage.jsp";
               writeLog("ACHA",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示业务管理列表系统错");
          }finally{
               ConnPoolHandler.closeConnection(con);
          }
          javax.servlet.RequestDispatcher rd =getServletContext().getRequestDispatcher(nextPage);
          rd.forward(request,response);
          return nextPage;
     }
}