topiclistservlet.java

来自「这是一个内容管理系统（CMS）以MVC方式写出,没有使用框架」· Java 代码 · 共 70 行

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 main.DBControl;

/**
 * Servlet implementation class for Servlet: TopicListServlet
 *
 */
 public class TopicListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public TopicListServlet() {
		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");
		request.setCharacterEncoding("gb2312");
		
		DBControl DC=new DBControl();
		
		PrintWriter out=response.getWriter();
		String webpath=request.getContextPath();
		DC.getConnPool();
		String sql="select * from topic order by OrderList";
		ResultSet rs=null;
		try
		{
			rs=DC.QuerySQL(sql);
			out.println("<table width='100%'>");
			while(rs.next())
			{
				out.println("<tr>");
				
				out.println("<td>");
				out.println("<a href='article_topiclist.jsp?Id="+rs.getString("Id")+"' target='_blank' title='"+rs.getString("Introduce")+"'>"+rs.getString("TopicName")+"</a>");				
				out.println("</td>");
				
				out.println("<td align='right'>");
				out.println(rs.getString("AddTime"));				
				out.println("</td");
				
				out.println("</tr>");
				
			}
			out.println("</table>");
		}catch(Exception ex)
		{
			System.out.println("在生成专题管理列表是出错"+sql+ex);
		}
		finally
		{
			DC.closeAll();
		}
	}  	  	  	    
}