showaction.java

实现了基本的增删改查和分页功能很简单的但是挺不错的适合初学者

/*
 * Generated by MyEclipse Struts
 * Template path: templates/java/JavaClass.vtl
 */
package org.demo.web.action;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

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 org.demo.dao.OptProduct;

/** 
 * MyEclipse Struts
 * Creation date: 11-01-2008
 * 
 * XDoclet definition:
 * @struts.action validate="true"
 */
public class ShowAction extends Action {
	/*
	 * Generated Methods
	 */

	/** 
	 * Method execute
	 * @param mapping
	 * @param form
	 * @param request
	 * @param response
	 * @return ActionForward
	 */
	public ActionForward execute(ActionMapping mapping, ActionForm form,
			HttpServletRequest request, HttpServletResponse response) {
		// TODO Auto-generated method stub
		   String strSQL="select * from products order by pid";
		   int totalRows=OptProduct.getTotaRows(strSQL);
		   int pageSize=5;
		   int totalPages=OptProduct.getTotalPages(strSQL, pageSize);
		   String page=request.getParameter("currentPage");
		   if(page==null){
			   page="1";
		   }
		   int currentPage=Integer.parseInt(page);
		   if(currentPage<1){
			   currentPage=1;
		   }
		   if(currentPage>totalPages){
			   currentPage=totalPages;
		   }
		   OptProduct opt=new OptProduct();
		   List list=opt.showAll(pageSize, currentPage);
		   HttpSession ses=request.getSession();
		   ses.setAttribute("totalRows", totalRows);
		   ses.setAttribute("totalPages", totalPages);
		   ses.setAttribute("currentPage", currentPage);
		   ses.setAttribute("list", list);
		   return mapping.findForward("toShow");
	}
}