articleaduitlistservlet.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: ArticleAduitListServlet
 *
 */
 public class ArticleAduitListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public ArticleAduitListServlet() {
		super();
	}   	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		response.setContentType("text/html;charset=gb2312");
		PrintWriter out=response.getWriter();
		String cur=request.getParameter("cur");//得到要显示的页数
		String menu=request.getParameter("menu");//得到显示栏目
			
		Pagination Pagein=new Pagination("article",Integer.valueOf(cur),Integer.valueOf(menu),"aduit");
		Pagein.setTable("article");
		ResultSet rs=null;
		try{
			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><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><td align='center'>");
				db.DB dt=new db.DB();
				out.println(dt.returnString("select MenuName from menu where Id="+rs.getString("MenuID")));//dt.ReturnFieldValueString("Menu", "Id", rs.getString("MenuID"), "MenuName"));
				dt.close();
				out.println("</td><td align='center'>"+rs.getString("AddMan")+
						"</td><td align='center'>"+rs.getString("AddTime")+
						"</td><td align='center'>");
				if(rs.getString("IsShow").trim().equals("1")){
					out.println("√");
				}else{out.println("×");
				}
				out.println("</td><td align='center'>" +
						"<a href='"+request.getContextPath()+"/jsjadmin/Article/article_edit.jsp?Id="+rs.getString("Id")+"'>编缉</a>" +
								"<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=aduit&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>通过审核</a>" +
								"<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=deleteRAduit&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();
		}
	}
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
	}   	  	    
}