offersaction.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.OffersDao;
import domain.Offers;
import domain.Products;

public class OffersAction extends Action{
    public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) {
    	

    	Connection conn = null;
    	PreparedStatement pstmt = null;
    	    	    	
    	OffersDao pd = new OffersDao();
    	List<Offers> olist = new ArrayList<Offers>();
    	
    	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.offers 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();
    		
    		Offers p = null;
    		while(rs.next()){
    			p = new Offers();
    			p.setOffersid(rs.getInt("offersid"));
    			p.setProductsid(rs.getInt("productsid"));
    			p.setContent(rs.getString("content"));
    			p.setPost_time(rs.getDate("post_time"));
    			p.setEnd_time(rs.getDate("end_time"));
    			p.setEmail(rs.getString("email"));
    			p.setAmount(rs.getInt("amount"));
    			p.setDeliver(rs.getString("deliver"));
    			p.setPayment(rs.getString("payment"));
    			p.setPrice(rs.getInt("price"));
    			p.setHits(rs.getInt("hits"));
    			p.setRemark(rs.getString("remark"));
    			p.setTrade(rs.getInt("trade"));
    			p.setTitle(rs.getString("title"));
    			p.setState(rs.getString("state"));
    			olist.add(p);
    		}
    	}catch(Exception e){
    		e.printStackTrace();
    	}finally{
    		DBConnection.closeConn();
    	}
    	
    	request.setAttribute("totalRecord", totalRow);		
		request.setAttribute("totalPage", totalPage); 
		request.setAttribute("whichpage", page);
    	request.setAttribute("offer", olist);
    	return mapping.findForward("offer");
    }
}