noteshow.java

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

package com.yhcms.note.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.common.Pages;
import com.yhcms.db.DBConnException;
import com.yhcms.note.bean.Note;
import com.yhcms.note.dao.NoteDaoIm;
import com.yhcms.note.itface.NoteDao;
import com.yhcms.utils.ReqUtils;
/**
 * <p>Title:阅读系统留言Action</p>
 * <li>进入阅读系统留言模块</li>
 * <br><b>CopyRight: yyhweb[由由华网]</b>
 * @author stephen
 * @version YH-2.0
 */
public class NoteShow extends Action{
	public ActionForward execute(ActionMapping actionmapping,ActionForm form,
			HttpServletRequest request,HttpServletResponse response){
		
		Logger yhlog = Logger.getLogger(NoteShow.class.getName());
		Note curNote = null;
		int nId = 0;
		int curPage = 0;
		int pageSize = 7;    // pagesize 可以由管理员再后台定义，此处有待改善
		int begin = 0;       //  开始查询的位置
		
		nId = ReqUtils.getInt(request,"nId");
		curPage = ReqUtils.getInt(request,"curPage");   // 当前页数
		
		int total = 0;     //    该栏目文章总数
		String link = "NoteShow.html?";// 部分相同链接
		String pageInfo = "";//  分页后得到的字符串结果
		Pages pages = null;
	
		if(curPage>1){      // 如果不是第一页，则从该页的第一条开始
			begin = (curPage-1)*pageSize;
		}
		
		NoteDao notedao = NoteDaoIm.getInstance();
		List nlist = null; // 只取得系统所有留言
		try {
			if(nId == 0){
				nlist = notedao.getAllNotes(begin,pageSize);
				total = notedao.getNoteNum();
				pages = new Pages(total,curPage,pageSize,link);
				pageInfo = pages.getPageInfo();
				
				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("total",total);
				request.setAttribute("nlist",nlist);
				request.setAttribute("pageInfo",pageInfo);
				return actionmapping.findForward("ShowAll");
				
			}else{
				if(nId > 0){
					curNote = notedao.getNoteById(nId);
					request.setAttribute("curnote",curNote);
					return actionmapping.findForward("ShowOne");
				}
			}
			
		} catch (DBConnException e) {
			yhlog.warn("When show a note,throw an Exception!");
		}
		
		return null;
		
	}

}