news4news.java

本系统实现的是一个信息发布平台

/*
 * 创建日期 2005-9-7
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package cn.edu.bit.taglib;

import java.util.Vector;

import cn.edu.bit.DBQuery.DataProcess;
import cn.edu.bit.Object.News;

import javax.servlet.jsp.tagext.TagSupport;
import javax.servlet.jsp.JspException;
import javax.servlet.jsp.JspWriter;
import javax.servlet.http.HttpServletRequest;

/**
 * @author fra
 * 
 * TODO 要更改此生成的类型注释的模板，请转至 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
public class News4news extends TagSupport {

	public int doEndTag() throws JspException {

		JspWriter out = pageContext.getOut();

		HttpServletRequest request = (HttpServletRequest) pageContext
				.getRequest();

		String str = (String) request.getQueryString();
		int page;
		if (str == null || str.equals(""))
			page = 1;
		else {
			// 根据‘=’来析取参数值
			String[] aa = str.split("=");
			page = Integer.parseInt(aa[1]);
		}

		try {
			String strSql = new String(
					"select * from news order by datetime desc");

			// search方法会把结果集中指定页的内容按行储存到Bean中，
			// ---------------------------------------------------------------
			int count = DataProcess.nCount(strSql);

			int totalPages = 0;

			if (count % 5 == 0) {
				totalPages = count / 5;
			} else {
				totalPages = count / 5 + 1;
			}

			int currentPage = 1;

			if (page <= 0) {
				currentPage = 1;
			} else if (page > totalPages) {
				currentPage = totalPages;
			} else {
				currentPage = page;
			}
			// ----------------------------------------------------------
			// 并将这些Bean保存在容器类中，然后返回
			Vector Items = News.search(strSql, page);

			out
					.println("<table width=\"100%\"  border=\"0\" cellspacing=\"1\" cellpadding=\"1\" class=\"tableBorder\">");
			// out.println("<tr>");
			// out.println("<td colspan=\"2\" align=\"center\"
			// background=\"../../images/guanli/admin_bg_1.gif\"
			// class=\"whitenormal\">新闻管理</td>");
			// out.println("</tr>");

			for (int i = 0; i < Items.size(); i++) {
				News bean = (News) Items.elementAt(i);

				out.println("<tr>");

				out.println("<td bgcolor=\"E4EDF9\" class=\"normalText\">"
						+ bean.getTitle() + "</td>");

				out.println("</tr>");

				out.println("<tr>");

				out.println("<td bgcolor=\"F1F3F5\" class=\"normalText\">"
						+ bean.getContent() + "</td>");

				out.println("</tr>");

				out.println("<tr>");

				out.println("<td>&nbsp;</td>");

				out.println("</tr>");

			}

			out.println("<tr>");

			out
					.println("<td colspan=\"2\"><table width=\"100%\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"E4EDF9\">");

			out.println("<tr class=\"normalText\">");

			out.println("<td>页次:" + currentPage + "/" + totalPages
					+ "页&nbsp;每页5 总数" + count + "</td>");

			out.println("<td align=\"right\">分页:");

			out.println("<a href=\"news.jsp?arg1=-1\">首页</a> ");

			out.println("<a href=\"news.jsp?arg2=-2\">上一页</a> ");

			out.println("<a href=\"news.jsp?arg3=-3\">下一页</a> ");

			out.println("<a href=\"news.jsp?arg4=-4\">尾页</a></td>");

			out.println("</tr>");

			out.println("</table></td>");

			out.println("</tr>");

			out.println("</table>");
		} catch (Exception e) {
			e.printStackTrace();
		}
		return SKIP_BODY;
	}

}