topicentereditservlet.java

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

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 Bean.Article.*;
import main.DBControl;
import javax.servlet.*;

/**
 * Servlet implementation class for Servlet: TopicEnterEditServlet
 *
 */
 public class TopicEnterEditServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public TopicEnterEditServlet() {
		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("html/text;charset=gb2312");
		request.setCharacterEncoding("gb2312");
		
		RequestDispatcher rd=null;
		
		String Id=request.getParameter("Id");
		DBControl DC=new DBControl();
		TopicBean topicbean=new TopicBean();
		DC.getConnPool();
		String sql="select * from topic where Id="+String.valueOf(Id).trim();
		ResultSet rs=null;
		try
		{
			rs=DC.QuerySQL(sql);
			if(rs.next())
			{
				topicbean.setId(Integer.valueOf(Id));
				topicbean.setTopicname(rs.getString("TopicName"));
				topicbean.setIntroduce(rs.getString("Introduce"));
				request.setAttribute("topicbean", topicbean);
				
				rd=request.getRequestDispatcher("/jsjadmin/Menu/Topic_edit.jsp");
				rd.forward(request, response);
			}
		}catch(SQLException ex)
		{
			System.out.println("在进入专题编缉时出错："+sql+ex);
		}
		finally
		{
			DC.closeAll();
		}
		
	}  	  	  	    
}