producttypeaction.java

交易撮合系统是一套买卖信息沟通的平台

package struts.houtaiaction;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.List;
import java.util.ArrayList;

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 conn.DBConnection;
import dao.ProductTypeDao;
import domain.ProductType;

public class ProductTypeAction extends Action{
    public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) {
    	
    	Connection conn = null;
    	PreparedStatement pstmt = null;
		
		
    	ProductTypeDao pd = new ProductTypeDao();   	
    	List<ProductType> ptlist = new ArrayList<ProductType>();
    	
    	int page; // 要显示的页码
    	int pageSize = 10; // 每页几条记录
    	
    	
		int totalRow = pd.getRowNumber();// 得到总行数
		int totalPage = pd.getTotalPage(pageSize); // 得到总页数
		

		String page0 = request.getParameter("Page");// 从页面上接收参数
		
		if (page0 != null && !page0.equals("")) { // 如果客户没有输入页数
			page = Integer.parseInt(page0);
		} else {
			page = 1;
		}
		if(page < 0){
			page = 1;
		}
		if (page > totalPage) {
			page = totalPage;
		}
        
		String queryPageSQL = "SELECT * FROM webpk.producttype limit ?,?";
		

		int start = (page - 1) * pageSize; // 记录的起始位置
		int end = page * pageSize; // 记录的结束位置
        System.out.println("开始位置："+start+",结束位置："+end);
		if (end > totalRow) {
			end = totalRow;
		}
		
		try {
			conn = DBConnection.getConn();
			pstmt = conn.prepareStatement(queryPageSQL);
			pstmt.setInt(1,start);
			pstmt.setInt(2,pageSize);			
			ResultSet rs = pstmt.executeQuery();	
			
			
			ProductType pt = null;
			while(rs.next()){
				
				pt = new ProductType();
				pt.setTypeid(rs.getInt("typeid"));
    			pt.setTitle(rs.getString("title"));
    			pt.setParent(rs.getString("parent"));
    			pt.setRemark(rs.getString("remark"));
    			
    			ptlist.add(pt);    			
			}			
			
		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (conn != null) {
				try {
					DBConnection.closeConn();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
		// 将分页的信息传递到网页上,以备网页上使用
		request.setAttribute("totalRecord", totalRow);		
		request.setAttribute("totalPage", totalPage); 
		request.setAttribute("whichpage", page);
		request.setAttribute("leibie", ptlist);
		return mapping.findForward("producttype");
    }
}