affichemanagerlistservlet.java

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

package servlet.affiche;

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;

/**
 * Servlet implementation class for Servlet: AfficheManagerListServlet
 *
 */
 public class AfficheManagerListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public AfficheManagerListServlet() {
		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");
		request.setCharacterEncoding("gb2312");
		
		PrintWriter out=response.getWriter();
		String webpath=request.getContextPath();
		db.DB dt=new db.DB();
		ResultSet rs=dt.getRs("select * from affiche order by Id desc");
		try{
			out.println("<table width='100%' border='1' cellpadding='1' cellspacing='0' bordercolor='#EFEFEF'>"
				+"<tr bgcolor='#C8E6FB'><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></tr>");
			while(rs.next()){
				out.println("<tr><td align='center'>");
				out.println(rs.getString("Id"));				
				out.println("</td><td>"+rs.getString("Title"));				
				out.println("</td><td align='center'>"+rs.getString("AddTime"));				
				out.println("</td><td align='center'>"+rs.getString("StarTime").trim()+"/");
				if(rs.getString("OverTime").trim().equals("")){
					out.print("无期");
				}else{
					out.print(rs.getString("OverTime").trim());
				}
				out.println("</td><td align='center'>");
				if(rs.getString("IsSpring").trim().equals("1"))
					out.println("弹出");
				else
					out.println("文本");	
				out.println("</td><td align='center'>");
				if(rs.getString("State").trim().equals("1"))
					out.println("启用");
				else
					out.println("禁用");
				out.println("</td><td align='center'><a href='"+webpath+"/jsjadmin/Affiche/affiche_edit.jsp?Id="+rs.getString("Id")+"'>编缉</a>");
				if(rs.getString("State").trim().equals("1"))
					out.println("<a href='"+webpath+"/AfficheOperateServlet?action=UnEnable&Id="+rs.getString("Id")+"'>禁用</a>");
				else
					out.println("<a href='"+webpath+"/AfficheOperateServlet?action=Enable&Id="+rs.getString("Id")+"'>启用</a>");
				out.println("<a href='"+webpath+"/AfficheOperateServlet?action=delete&Id="+rs.getString("Id")+"'>删</a>");
				out.println("</td></tr>");
			}
			out.println("</table>");
		}catch(Exception ex){
			System.out.println("在生成公告管理列表是出错"+ex);
		}finally{
			dt.close();
		}
	}
	
	/* (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
	}   	  	    
}