showmycardlist.java

一个信息发布系统 基于jsp+servlet+tomcat 用户分管理员跟普通用户 普通用户有发布信息 查询信息 修改信息 回复信息 管理员拥有普通用户的功能 此外还具有删除信息 管理信息的回复的功能

package control;
import java.io.IOException;
import javax.servlet.http.*;
import javax.servlet.*;

import java.util.*;

public class ShowMyCardList extends HttpServlet
{
	public void init(ServletConfig config)throws ServletException
    {
   	 super.init(config);
    }
    
    public void doGet(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
    {
   	 doPost(req,res);
    }
    
    public void doPost(HttpServletRequest req,HttpServletResponse res)throws ServletException,IOException
    {
    	req.setCharacterEncoding("gbk");
    	CardCom com = new CardCom("jdbc:mysql://localhost/mybbs","root", "root123");
    	UserCom com2 = new UserCom("jdbc:mysql://localhost/mybbs","root", "root123");	
    	Vector vc = new Vector();
    	
    	String UserName = (String)req.getSession().getAttribute("USER");
    	System.out.println(UserName);
        String Command = req.getParameter("command");
    	int pagenum = Integer.parseInt((String)req.getParameter("pagenum")); //取得要显示的网页页码,第一次进入的时候为1
    	int pagecount = Integer.parseInt((String)req.getParameter("pagecount"));
    	String Sort_Condition = (String)req.getParameter("sortcondition");      //2008.11.19修改  取得排序方式
    	System.out.println("Sort News By: " + Sort_Condition);   //2008.11.19修改  取得排序方式
    	
    	int total = com2.getTieziShuliang(UserName);  //查询该用户的所有帖子数量

    	if(total % 8==0)
    		pagecount  = total/8;
    	else
    		pagecount = ((int)total/8)+1;
    	
    	if(pagenum<=pagecount)
    	{
    		vc = com.getCardByUserName(UserName,pagenum,Sort_Condition);
    	}
    	else
    		vc = null;   	
    	req.setAttribute("Message","欢迎进入管理文章页面");
    	req.setAttribute("NewsCount",new Integer(total));
    	req.setAttribute("allcard", vc);
    	req.setAttribute("pagenum",String.valueOf(pagenum));  //当前页数
    	req.setAttribute("pagecount", String.valueOf(pagecount));//总共需要多少页面数
    	req.setAttribute("command", Command);
    	req.setAttribute("sortcondition", Sort_Condition); //2008.11.19修改  排序
    	tiaoZhuan(req,res,"/ShowMyCardList.jsp");//跳转到该页面  显示所有的帖子Card
    }
    
    public void  tiaoZhuan(HttpServletRequest req,HttpServletResponse res,String page)throws ServletException,IOException
    {
   	 RequestDispatcher dispatcher = getServletContext().getRequestDispatcher(page);
   	 dispatcher.forward(req, res);
    }
}