artclass.java

前台:文章浏览、发表留言、Game、Music 后台:文章相关:发表文章、修改文章、删除文章、批量移动文章 栏目相关:增加栏目、修改栏目、删除栏目、栏目链接、栏目排序系统栏目分为系统内部栏目和外部栏目

package com.yhcms.artclass.action;

import java.util.List;

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

import org.apache.log4j.Logger;
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 com.yhcms.artclass.dao.ArtClassDaoIm;
import com.yhcms.artclass.itface.ArtClassDao;
import com.yhcms.article.dao.ArticleDaoIm;
import com.yhcms.article.itface.ArticleDao;
import com.yhcms.common.Pages;
import com.yhcms.db.DBConnException;
import com.yhcms.utils.ReqUtils;
/**
 * <p>Title:系统栏目Action</p>
 * <li>系统栏目链接</li>
 * <li>取得栏目的所有文章列表</li>
 * <br><b>CopyRight: yyhweb[由由华网]</b>
 * @author stephen
 * @version YH-2.0
 */
public class ArtClass extends Action {
	public ActionForward execute(ActionMapping actionmapping,ActionForm form,
								 HttpServletRequest request,HttpServletResponse response){
		Logger yhlog = Logger.getLogger(ArtClass.class.getName());
		
		int classId = ReqUtils.getInt(request,"csId");// 当前栏目Id
		int curPage = ReqUtils.getInt(request,"curPage");   // 当前页数
		
		String className = ""; //栏目名称
		int pageSize = 20;    // pagesize 可以由管理员再后台定义，此处有待改善
		int begin = 0;       //  开始查询的位置
		List artList = null;
		List cList = null;   // 系统内部栏目-搜索用
							//   分页
		int total = 0;     //    该栏目文章总数
		String link = "ArtList.html?csId="+classId;// 部分相同链接
		String pageInfo = "";//  分页后得到的字符串结果
		Pages pages = null;
		ArticleDao artdao = ArticleDaoIm.getInstance();
		ArtClassDao classdao = ArtClassDaoIm.getInstance();
		
		if(curPage>1){      // 如果不是第一页，则从该页的第一条开始
			begin = (curPage-1)*pageSize;
		}
		try {
			cList = classdao.getAllInClass();
			className = classdao.getNameById(classId);
			artList = artdao.getArtByClassId(classId,begin,pageSize);
			total = artdao.getArtNum(classId);
			pages = new Pages(total,curPage,pageSize,link);
			pageInfo = pages.getPageInfo();
		} catch (DBConnException e) {
			yhlog.warn("When get a Class's article,throw an Exception.The class id is:"+classId);
		}
		
		if((pageInfo==null) || (pageInfo.equals(""))){
			StringBuffer sb = new StringBuffer();
			sb.append("<table class='tab' width=100% height=100% cellSpacing=0 cellPadding=0>");
			sb.append("<tr><td>");
			sb.append("&nbsp;&nbsp;");
 			sb.append("共");
 			sb.append("<b style=font-size:10pt>");
 			sb.append(1);
 			sb.append("</b>");
 			sb.append("页&nbsp;&nbsp;");
 			sb.append("<b style=font-size:10pt>");
 			sb.append(total);
 			sb.append("</b>");
 			sb.append("个记录&nbsp;&nbsp;");
 			sb.append("</td></tr>");
 			sb.append("<table>");
 			pageInfo = sb.toString();
 			sb = null;
		}
		request.setAttribute("className",className);
		request.setAttribute("total",total);
		request.setAttribute("artList",artList);
		request.setAttribute("cList",cList);
		request.setAttribute("pageInfo",pageInfo);
		
		return actionmapping.findForward("List");
	}

}