aphm001servlet.java

HW-中国移动企业信息机,请查看

package com.sxit.phonemanager;

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>类名: APHM001Servlet</p>
 * <p>功能: 显示品牌列表</p>
 * <p>公司: 深讯信科</p>
 * <p>版本: 1.0</p>
 * @程序 sxit
 * @日期 2005-03-22
 * @修改纪录
 */

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

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

          TphmbrandList tphmbrandlist=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("APHM","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="";
               }
               //添加字段，修改相应的JSP
               if(selectID.equals("0")){
                    strSearch="";
                 }else if(selectID.equals("1") && !selectMsg.equals("")){
                    strSearch=" and (a.brandid="+selectMsg+")";
               }

               //过滤数据，用户只能看属于自己的数据
               //如果表中有corporationid staffid字段,需要判断用户使用数据

               //如果表中有createdate,需要判断时间段
               //添加排序
               strSearch=strSearch+" order by a.brandid desc ";

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

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

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

               nextPage="/aphm/aphm001.jsp";
//               writeLog("APHM",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示品牌列表成功");

          }
          catch (SQLException e){
               System.out.println(e);
               request.setAttribute("messageID","显示品牌列表数据错");
               request.setAttribute("returnPage","../aphm/aphm001");
               nextPage="/aphm/aphmmessage.jsp";
               writeLog("APHM",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示品牌列表数据错");
          }
          catch (Exception e){
               System.out.println(e);
               request.setAttribute("messageID","显示品牌列表系统错");
               request.setAttribute("returnPage","../aphm/aphm001");
               nextPage="/aphm/aphmmessage.jsp";
               writeLog("APHM",LogManager.LOGTYPE_APP,myMember.getStaffid(),"显示品牌列表系统错");
          }finally{
               ConnPoolHandler.closeConnection(con);
          }
          javax.servlet.RequestDispatcher rd =getServletContext().getRequestDispatcher(nextPage);
          rd.forward(request,response);
          return nextPage;
     }
}