articlemaglistservlet.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 db.DB;

import Bean.Pagination;

/**
 * Servlet implementation class for Servlet: ArticleMaglistServlet
 *
 */
 public class ArticleMaglistServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public ArticleMaglistServlet() {
		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");//得到显示栏目
		
		//DBCon DC=new DBCon();	
		Pagination Pagein=new Pagination("article",Integer.valueOf(cur),Integer.valueOf(menu),"manager");
		Pagein.setTable("article");
		ResultSet rs=null;
		DB dt=new 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><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'>");
				out.println(dt.returnString("select MenuName from menu where Id="+rs.getString("MenuID")));
				//out.println(DC.ReturnFieldValueString("Menu", "Id", rs.getString("MenuID"), "MenuName"));
				out.println("</td><td align='center'>"+rs.getString("AddMan")+
				"</td><td align='center'>"+rs.getString("Times")+
				"</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=deleteR&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>删</a>");
				if(rs.getString("IsHead").trim().equals("1"))
					out.println("<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=notop&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>解固</a>");
				else
					out.println("<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=top&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>固顶</a>");
				if(rs.getString("IsGood").trim().equals("1"))
					out.println("<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=nocommend&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>解荐</a>");
				else
					out.println("<a href='"+request.getContextPath()+"/ArticleOperateServlet?action=commend&Id="+rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>推荐</a>");
				
				out.println("<a href='"+request.getContextPath()+"/article_view.jsp?Id="+rs.getString("Id")+"' target='_blank'>查看</a>");
				out.println("</td></tr>");
			}
			out.println("</table>");
		}catch(Exception ex){
			System.out.print("在ArticleMaglistServlet中得到文章分页列表时出错"+ex);
		}
		finally{
			Pagein.CloseConn();
			dt.close();
			out.close();
		}
	}  	  	  	    
}