affichelistservlet.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: AfficheListServlet
 *
 */
 public class AfficheListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public AfficheListServlet() {
		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();
		//DBControl DC=new DBControl();
		db.DB dt=new db.DB();
		ResultSet rs=dt.getRs("select Id,Title,AddTime from affiche where State='1' order by Id desc");
		try{
			out.println("<table width='100%' border=0>");
			while(rs.next()){
				out.println("<tr><td align='left'><a href='affiche_view.jsp?Id="+rs.getString("Id")+"'>"+rs.getString("Title")+"</a>");
				out.println("</td><td align='right'>");
				out.println(rs.getString("AddTime"));
				out.println("</td></tr>");				
			}
			out.println("</table>");
		}
		catch(Exception ex){
			System.out.println("在AfficheListServlet得到公告列表进出错，错误为："+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
	}   	  	    
}