articlesaction.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.ArticleDao;
import domain.Articles;

public class ArticlesAction extends Action{
    public ActionForward execute(ActionMapping mapping,ActionForm form,HttpServletRequest request,HttpServletResponse response) {
    	
    	Connection conn = null;
    	PreparedStatement pstmt = null;
    	    	    	
    	ArticleDao pd = new ArticleDao();
    	List<Articles> alist = new ArrayList<Articles>();
    	
    	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.articles ORDER BY articles.articlesid DESC 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();
    		
    		Articles p = null;
    		while(rs.next()){
    			p = new Articles();
    			p.setArticlesid(rs.getInt("articlesid"));
    			p.setHits(rs.getInt("hits"));
    			p.setAddress(rs.getInt("address"));
    			p.setTitle(rs.getString("title"));
    			p.setPost_time(rs.getDate("post_time"));
    			p.setKindid(rs.getInt("kindid"));
    			alist.add(p);
    		}
    	}catch(Exception e){
    		e.printStackTrace();
    	}finally{
    		DBConnection.closeConn();
    	}
    	
    	request.setAttribute("totalRecord", totalRow);		
		request.setAttribute("totalPage", totalPage); 
		request.setAttribute("whichpage", page);
    	
    	request.setAttribute("articles", alist);
    	return mapping.findForward("articles");
    }
}