index.java

来自「留言簿架构 oracle 9i + jsp + struts 留言」· Java 代码 · 共 95 行

package com.guestbook.action;

import java.io.IOException;
import java.io.PrintWriter;

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 javax.servlet.*;
import java.io.*;
import oracle.jdbc.driver.*;
import oracle.sql.*;

public class Index extends Action {

	private static final Log logger = LogFactory.getLog( Index.class );
	
	public ActionForward execute(ActionMapping actionMapping,
            ActionForm actionForm,
            HttpServletRequest request,
            HttpServletResponse httpServletResponse)
	{
		try
		{
			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 );
			}

			
			
			Connection conn = DataBaseConnection.getConnection();
			CallableStatement stmt = conn.prepareCall("{  call pkg_guestInfo.p_guestInfo_List(?,?,?,?) }");
			stmt.setInt( 1, page );
			stmt.setInt( 2, pageSize );
			stmt.registerOutParameter( 3, OracleTypes.CURSOR );
			stmt.registerOutParameter( 4, OracleTypes.NUMBER );
			stmt.executeQuery();
			ResultSet rs = ( ( OracleCallableStatement ) stmt ).getCursor( 3 );
			int rowCount = stmt.getInt( 4 );
			
			Vector dataTable = DataBaseUtil.getDataTable( rs );
			
			rs.close();
			stmt.close();
			conn.close();
			
			maxPage = ( int )Math.ceil( ( float )rowCount / pageSize  );
			
			if( page > maxPage )
			{
				page = maxPage;
			}
	 
			request.setAttribute( "dynamicParameter", SysInfo.getInstance().getDynamicParameter() ); 
			request.setAttribute( "guestInfoList", dataTable );
			request.setAttribute( "rowCount", rowCount );
			request.setAttribute( "page", page );
			request.setAttribute( "maxPage", maxPage );
			
			return actionMapping.findForward("index");
		}
		catch( Exception exp )
		{
			logger.error( exp );
		}
		return null;
	}
	

}