titleservlet.java

简易java框架开源论坛系统源码easyjf_bbs0.1.rar

package servlet;

import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import conn.*;
import bean.*;
import face.*;
import java.util.List;
import java.util.Iterator;
import util.*;

public class TitleServlet extends HttpServlet
{
	public void init(ServletConfig config) throws ServletException
	{
		super.init(config);
	}

	public void service(ServletRequest request, ServletResponse respone) throws ServletException,IOException
	{
		request.setCharacterEncoding("gb2312");
		String id = request.getParameter("id");
		String pageNo = request.getParameter("pageNo");
		int current;
		if(pageNo == null)
		{
			current = 1;
		}
		else
		{
			current = Integer.parseInt(pageNo);
		}
		PrintStream out = new PrintStream(respone.getOutputStream());
		try
		{
			FlashDbDao dd = FlashDbDao.instance(Constants.driver,
			Constants.url,Constants.username,Constants.password);
			String sql = "select tiezi_id,ed.edition_title,tiezi_title,user_name,tiezi_count from bbs_tiezi ti, "
				+ "bbs_edition ed where ti.edition_id = ed.edition_id and ti.edition_id='" + id + "'";
			dd.setPstmt(sql);
			Pagination pager = new Pagination(dd);
			pager.setPageSize(7);
			TitleBean tb = new TitleBean();
			out.print("&page=" + current);
			out.print("&count=" + pager.getNonce(current));
			out.print("&pageCount=" + pager.getPageCount());
			List ls = pager.getPageResult(current,tb);
			String allId = "";
			String allEdition = "";
			String allTitle = "";
			String allUser = "";
			String allCount= "";
			for(Iterator it = ls.iterator(); it.hasNext(); )
			{
				tb = (TitleBean)it.next();
				allId += tb.getId() + "#";
				allEdition += tb.getEdition() + "#";
				allTitle += tb.getTitle() + "#";
				allUser += tb.getUser() + "#";
				allCount += tb.getCount() + "#";
			}
			out.print("&allId=" + allId.substring(0, allId.length() -1));
			out.print("&allEdition=" + allEdition.substring(0, allEdition.length() -1));
			out.print("&allTitle=" + allTitle.substring(0, allTitle.length() -1));
			out.print("&allUser=" + allUser.substring(0, allUser.length() -1));
			out.print("&allCount=" + allCount.substring(0, allCount.length() -1));
		}
		catch (Exception e)
		{
			System.out.println("title的数据异常!");
		}
	}
}