productaction.java

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

package struts.houtaiaction;

import java.util.ArrayList;
import java.util.List;

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 java.sql.*;

import conn.DBConnection;
import dao.ProductsDao;
import domain.Products;

public class ProductAction extends Action{
    public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) {
    	
    	Connection conn = null;
    	PreparedStatement pstmt = null;
    	    	    	
    	ProductsDao pd = new ProductsDao();
    	List<Products> plist = new ArrayList<Products>();
    	
    	int page;
    	int pageSize = 10;
    	int totalRow = pd.getRowNumber();
    	int totalPage = pd.getTotalPage(pageSize);
    	
    	String page0 = request.getParameter("Page");
    	if(page0 != null && page0 != ""){
    		page = Integer.parseInt(page0);
    	}else{
    		page = 1;
    	}
    	
    	if(page < 0){
    		page = 1;
    	}
    	if(page > totalPage){
    		page = totalPage;
    	}
    	
    	String sql = "SELECT * FROM webpk.products limit ?,?";    	
    	int start = (page-1)*pageSize;
    	
    	try{
    		conn = DBConnection.getConn();
    		pstmt = conn.prepareStatement(sql);
    		pstmt.setInt(1, start);
    		pstmt.setInt(2, pageSize);
    		ResultSet rs = pstmt.executeQuery();
    		
    		Products p = null;
    		while(rs.next()){
    			p = new Products();    			
    			p.setTitle(rs.getString("title"));
    			p.setTypeid(rs.getInt("typeid"));
    			p.setPhoto(rs.getString("photo"));
    			p.setRemark(rs.getString("remark"));
    			p.setProductsid(rs.getInt("productsid"));
    			plist.add(p);
    		}	
    	}catch(Exception e){
    		e.printStackTrace();
    	}finally{
    		DBConnection.closeConn();
    	}
    	
    	request.setAttribute("totalRecord", totalRow);		
		request.setAttribute("totalPage", totalPage); 
		request.setAttribute("whichpage", page);
    	request.setAttribute("shangpin", plist);
    	
    	return mapping.findForward("products");
    }
}