articletopiclistservlet.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.DealString;
import Bean.Pagination;

/**
 * Servlet implementation class for Servlet: ArticleTopicListServlet
 *
 */
 public class ArticleTopicListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
	    /**
	 * 
	 */
	private static final long serialVersionUID = 1L;

		/* (non-Java-doc)
		 * @see javax.servlet.http.HttpServlet#HttpServlet()
		 */
		public ArticleTopicListServlet() {
			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();
			db.DB dt=new db.DB();
			Pagination Pagein=new Pagination("article",Integer.valueOf(cur),Integer.valueOf(menu),"topic");
			Pagein.setTable("article");
			ResultSet rs=null;
			try	{
				//DC.getConnPool();
				rs=Pagein.getArticleRs();
		    	out.println("<table width='100%' border='1' cellpadding='1' cellspacing='0' bordercolor='#EFEFEF'><tr bgcolor='#C8E6FB'>" +
		    			"<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> <td align='center'>操作</td></tr>");
				while(rs.next()){
					out.println("<tr><td align='center'><input type='checkbox' name='selected' onClick='unselectall(this.form.selectAll)' value='"+rs.getString("Id")+"'/>");
					out.println("</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")));
							//DC.ReturnFieldValueString("menu", "Id", rs.getString("MenuID"), "MenuName"));
					out.println("</td>");
					
					out.println("<td align='center'>");
					DealString dstr=new DealString();
					String[] Topics=dstr.splitStr(rs.getString("TopicID"), '|');
					if(Topics!=null){	
						out.print(dt.returnString("select TopicName from topic where Id="+Topics[0]));
								//DC.ReturnFieldValueString("topic", "Id", Topics[0].trim(), "TopicName"));
						for(int i=1;i<Topics.length;i++)
							out.print("|"+dt.returnString("select TopicName from topic where Id="+Topics[i]));
							//out.print(DC.ReturnFieldValueString("topic", "Id", Topics[i].trim(), "TopicName"));
					}
					out.println("</td><td align='center'>"+rs.getString("AddMan")+"</td>");
					out.println("<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()+"/ArticleOperateServlet?action=Topicclear&Id="+
							rs.getString("Id")+"&menu="+menu.trim()+"&cur="+cur.trim()+"'>脱离专题</a></td></tr>");
				}
				out.println("</table>");
			}catch(Exception ex){
				System.out.print("在ArticleTopicListServlet中得到文章分页列表时出错"+ex);
			}
			finally	{
				Pagein.CloseConn();
				dt.close();
			}
		}  	  	  	    
	}