articlerecyclelistservlet.java

这是一个内容管理系统（CMS）以MVC方式写出,没有使用框架

package servlet.article;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.ResultSet;

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

import Bean.Pagination;

/**
 * Servlet implementation class for Servlet: ArticleRecycleListServlet
 *
 */
 public class ArticleRecycleListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public ArticleRecycleListServlet() {
		super();
	}   	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.setContentType("text/html;charset=gb2312");
		PrintWriter out=response.getWriter();
		String cur=request.getParameter("cur");//得到要显示的页数
		String menu=request.getParameter("menu");//得到显示栏目
		
		//DBControl DC=new DBControl();	
		Pagination Pagein=new Pagination("article",Integer.valueOf(cur),Integer.valueOf(menu),"recycle");
		Pagein.setTable("article");
		ResultSet rs=null;
		db.DB dt=new db.DB();
		try
		{
			//DC.getConnPool();
			rs=Pagein.getArticleRs();
	    	out.println("<table width='100%' border='1' cellpadding='1' cellspacing='0' bordercolor='#EFEFEF'>");
	    	out.println("<tr bgcolor='#C8E6FB'>");
	    	out.println("<td align='center'><input type='checkbox' name='selectAll' value='checkbox' onClick='checkAll(this.form)'></td> <td align='center'>ID</td> <td align='center'>标题</td> <td align='center'>所属栏目</td> <td align='center'>添加者</td> <td align='center'>添加日期</td> <td align='center'>已审核</td> <td align='center'>操作</td>");
	    	out.println("</tr>");
	    	
			while(rs.next()){
				out.println("<tr><td align='center'><input type='checkbox' name='selected' onClick='unselectall(this.form.selectAll)' value='"+rs.getString("Id")+"'/></td>");
				out.println("<td align='center'>"+
						rs.getString("Id")+"</td><td>");
				if(rs.getString("IsHead").trim().equals("1")){
					out.println("<img src='"+request.getContextPath()+"/jsjadmin/images/IS_ONTOP.gif'/>");
				}
				else if(rs.getString("IsGood").trim().equals("1")){
					out.println("<img src='"+request.getContextPath()+"/jsjadmin/images/IS_COMMEND.gif'/>");
				}
				else{
					out.println("<img src='"+request.getContextPath()+"/jsjadmin/images/COMMON.gif'/>");
				}
				if(rs.getString("IsImg").trim().equals("1")){
					out.println(rs.getString("Title")+"(图片)");
				}
				else{
					out.println(rs.getString("Title"));
				}
				out.println("</td>");
				
				out.println("<td align='center'>");
				out.print(dt.returnString("select MenuName from Menu where Id="+rs.getString("MenuID")));
				//out.println(DC.ReturnFieldValueString("Menu", "Id", rs.getString("MenuID"), "MenuName"));
				out.println("</td>");
				
				out.println("<td align='center'>");
				out.println(rs.getString("AddMan"));
				out.println("</td>");
				
				out.println("<td align='center'>");
				out.println(rs.getString("AddTime"));
				out.println("</td>");
				
				out.println("<td align='center'>");
				if(rs.getString("IsShow").trim().equals("1")){
					out.println("√");
				}else	out.println("×");
				out.println("</td><td align='center'>");
				out.println("<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=recycle&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>还原</a>"+
						"<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=recycledelete&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+
						"'>彻底删除</a></td></tr>");
			}
			out.println("</table>");
		}catch(Exception ex){
			System.out.print("在ArticleAduitListServlet中得到文章分页列表时出错"+ex);
		}
		finally
		{
			Pagein.CloseConn();
			dt.close();
		}
	}  	  	  	    
}