messagesearchaction.java

实现复杂的分页查询

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package jp.co.ttc.sample.message_search;

import java.io.UnsupportedEncodingException;
import java.sql.*;
import java.util.*;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.yourcompany.struts.DBBean;
import jp.co.ttc.sample.bean.*;
import jp.co.ttc.sample.message_search.*;
/** 
 * MyEclipse Struts
 * Creation date: 07-15-2008
 * 
 * XDoclet definition:
 * @struts.action path="/messageSearch" name="messageSearchForm" input="/form/message_search.jsp" scope="request" validate="true"
 */
public class MessageSearchAction extends Action {
	/*
	 * Generated Methods
	 */
	 public MessageSearchAction(){}
     ArrayList arrayList=new ArrayList();
     PageBean pb;

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 * @throws UnsupportedEncodingException 
	 * @throws UnsupportedEncodingException 
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) throws UnsupportedEncodingException {
		
		MessageSearchForm messageSearchForm = (MessageSearchForm) form;// TODO Auto-generated method stub
		
		String message_sts = messageSearchForm.getMessage_sts();
		if(message_sts!=null)
		{
			message_sts= new String(message_sts.getBytes("ISO8859_1"),"utf-8");
			if(message_sts.endsWith("枹撉")){message_sts="0";}
		    else if(message_sts.endsWith("婛撉")){message_sts="1";}
		    else if(message_sts.endsWith("慡偰")){message_sts="9";}
		}
		
		String message_admin_sts = messageSearchForm.getMessage_admin_sts();
		if(message_admin_sts!=null)
		{
			message_admin_sts= new String(message_admin_sts.getBytes("ISO8859_1"),"utf-8");
		    if(message_admin_sts.endsWith("枹懳墳")){message_admin_sts="0";}
		    else if(message_admin_sts.endsWith("懳墳拞")){message_admin_sts="1";}
		    else if(message_admin_sts.endsWith("懳墳嵪")){message_admin_sts="2";}
		    else if(message_admin_sts.endsWith("慡偰")){message_admin_sts="9";}
		 }

	 String date_from = messageSearchForm.getDate_from();
	 String date_to = messageSearchForm.getDate_to();
	 String keyword = messageSearchForm.getKeyword();
	 if(keyword!=null)
	 {keyword= new String(keyword.getBytes("ISO8859_1"),"utf-8");}

		String action;  
		action=request.getParameter("action");
		String sql = "select * from message where message_sts = ? and admin_sts = ? ";
		String args[] = new String[2];
		args[0]=message_sts;
		args[1]=message_admin_sts;
		if(action==null || action.equals("null")){  //first read data
		try{		                         
			
			  arrayList=Message.getAllMessage(sql,args);
		      //messageSearchForm.setList(arrayList);
	        }catch(Exception e){
	          e.printStackTrace();
         } 
         pb = new PageBean(arrayList);
		 Message[] messages=pb.getMessages();
		 pb.description();
		 request.setAttribute("result",messages);
		 request.setAttribute("page",pb); 

		}
		else
        {
          if(action=="nextPage" || action.equals("nextPage"))
          {
           Message[] messages=pb.getNextPage();
           request.setAttribute("page",pb);
           request.setAttribute("result",messages);  

          }
          if(action=="previousPage" || action.equals("previousPage"))
          {
           Message[] messages=pb.getPreviouspage();         
           request.setAttribute("page",pb);
           request.setAttribute("result",messages);

           }
        }
       return mapping.getInputForward();
  }        
}