searchresult.java

留言簿架构 oracle 9i + jsp + struts 留言簿基本功能： 1 、客人签写留言 2 、基本的UBB支持

package com.guestbook.action;

 
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.apache.struts.action.*;
import javax.servlet.http.*;

import java.sql.*;
import java.util.*;

import com.guestbook.sys.DataBaseUtil;
import com.guestbook.sys.DataBaseConnection;
import com.guestbook.sys.SysInfo;
 
import oracle.jdbc.driver.*;
 

import com.guestbook.form.*;

public class SearchResult extends Action
{ 
	private static final Log logger = LogFactory.getLog( SearchResult.class );
	
	public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm,
            HttpServletRequest request,
            HttpServletResponse httpServletResponse)
	{
		SearchResultForm form = ( SearchResultForm ) actionForm;
	 
		
		int page,pageSize,maxPage;
		String pageS = request.getParameter( "page" );
		if( pageS == null )
		{
			page = 1;
		}
		else
		{
			page = Integer.parseInt( pageS );
		}
		pageSize = 10;
		try
		{
			pageSize = Integer.parseInt( SysInfo.getInstance().getDynamicParameter().get( "pageSize" ).toString() );
		}
		catch( Exception exp )
		{
			logger.error( exp );
		}
		
		int rowCount = 0;
		Vector dataTable = null;
		
		if((form.getKeyWord()==null)|| "".equals(form.getKeyWord())){
			return actionMapping.findForward("searchResult");
		}
		String where ="";
		String keyword=form.getKeyWord().replace('\'', ' ');
		switch(form.getCategory()){
		   case  1:
			   where = " and guestcontent like '%"+keyword+"%' " ;
			   break;
		   case  2:
			   where = " and guestreply like '%"+keyword+"%' " ;
			   break;
		   case  3:
			   where = " and guestname like '%"+keyword+"%' " ;
			   break;
		   
		}
		 
		
		
		try
		{ 
			
			Connection conn = DataBaseConnection.getConnection();
			CallableStatement stmt = conn.prepareCall("{  call pkg_guestInfo.p_searchInfo_List(?,?,?,?,?) }");
			stmt.setInt( 1, page );
			stmt.setInt( 2, pageSize );
			stmt.setString( 3, where );
			stmt.registerOutParameter( 4, OracleTypes.CURSOR );
			stmt.registerOutParameter( 5, OracleTypes.NUMBER );
			stmt.executeQuery();
			ResultSet rs = ( ( OracleCallableStatement ) stmt ).getCursor( 4 );
			rowCount = ( ( OracleCallableStatement ) stmt ).getInt( 5 );
	 		dataTable = DataBaseUtil.getDataTable( rs ); 
			rs.close();
			stmt.close();
			conn.close();
			

		}
		catch( Exception exp )
		{
			logger.info("\n Rs res err \n");
			logger.error( exp );
		} 
		 
		maxPage = ( int )Math.ceil( ( float )rowCount / pageSize  );
		
		if( page > maxPage )
		{
			page = maxPage;
		} 
		request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() ); 
		request.setAttribute( "searchInfoList", dataTable );
		request.setAttribute( "rowCount", rowCount );
		request.setAttribute( "page", page );
		request.setAttribute( "maxPage", maxPage ); 
		request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() );
	    return actionMapping.findForward("searchResult");	
	}
}