topicmanagerlistservlet.java

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

package servlet.article;

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.sql.*;
import main.DBControl;
import java.io.PrintWriter;

/**
 * Servlet implementation class for Servlet: TopicManagerListServlet
 *
 */
 public class TopicManagerListServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public TopicManagerListServlet() {
		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%' border='1' cellpadding='1' cellspacing='0' bordercolor='#EFEFEF'>");
			out.println("<tr bgcolor='#C8E6FB'><td align='center'>专题名称</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></tr>");
			while(rs.next())
			{
				out.println("<tr>");
				
				out.println("<td>");
				out.println(rs.getString("TopicName"));				
				out.println("</td>");
				out.println("<td align='center'>");
				out.println(rs.getString("Id"));				
				out.println("</td>");
				out.println("<td align='center'>");
				out.println(rs.getString("AddTime"));				
				out.println("</td align='center'>");
				out.println("<td align='center'>");
				sql="select Id from article where TopicID like '%"+rs.getString("Id").trim()+"%'";				
				out.println(DC.getRows(sql));				
				out.println("</td>");
				out.println("<td align='center'>");
				out.println(DC.retuSumField("article", "Times", "TopicID like '%"+rs.getString("Id").trim()+"%'"));	
				out.println("</td>");
				out.println("<td align='center'>");
				out.println("<a href='"+webpath+"/TopicEnterEditServlet?Id="+rs.getString("Id")+"'>编缉</a>");
				out.println("<a href='"+webpath+"/TopicOperateServlet?action=delete&Id="+rs.getString("Id")+"' onclick='return delArticleSpecialConfirm()'>删除</a>");
				out.println("<a href='"+webpath+"/TopicOperateServlet?action=clear&Id="+rs.getString("Id")+"' onclick='return clearArticleSpecialConfirm()'>清空</a>");
				out.println("</td>");
				out.println("<td align='center'>");
				out.println("<a href='"+webpath+"/TopicOperateServlet?action=orderup&Id="+rs.getString("Id")+"'>升↑</a>");
				out.println("<a href='"+webpath+"/TopicOperateServlet?action=orderdown&Id="+rs.getString("Id")+"'>降↓</a>");
				out.println("</td>");
				
				out.println("</tr>");
				
			}
			out.println("</table>");
		}catch(Exception ex)
		{
			System.out.println("在生成专题管理列表是出错"+sql+ex);
		}
		finally
		{
			DC.closeAll();
		}
	}  	  	  	    
}