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

/**
 * Servlet implementation class for Servlet: TopicEditServlet
 *
 */
 public class TopicEditServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public TopicEditServlet() {
		super();
	}   	 	
	
	/* (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
		DBControl DC=new DBControl();
		response.setContentType("text/html;charset=gb2312");
		request.setCharacterEncoding("gb2312");
		
		RequestDispatcher rd=null;
		
		String Id=request.getParameter("Id"); 
		String TopicName=request.getParameter("TopicName");
		String Introduce=request.getParameter("Introduce");
		TopicBean topicbean=new TopicBean();
		topicbean.setTopicname(TopicName);
		topicbean.setIntroduce(Introduce);
		request.setAttribute("topicbean", topicbean);
		if(!topicbean.validata("edit", Integer.valueOf(Id)))
		{
			rd=request.getRequestDispatcher("/jsjadmin/Menu/Topic_edit.jsp");
			rd.forward(request, response);
			return;
		}
		
		DC.getConnPool();
		PreparedStatement pstm=null;
		String sql="update topic set TopicName=?,Introduce=? where Id=?";
		try
		{
			pstm=DC.conn.prepareStatement(sql);
			pstm.setString(1, TopicName);
			pstm.setString(2, Introduce);
			pstm.setInt(3, Integer.valueOf(Id));
			pstm.executeUpdate();
			
			rd=request.getRequestDispatcher("/jsjadmin/Menu/Topic_add_success.jsp?action=edit");
			rd.forward(request, response);
		}catch(Exception ex)
		{
			System.out.println("在修改专题时出错："+sql+ex);
		}
		finally
		{
			try
			{
				pstm.close();
				DC.closeConn();
			}catch(SQLException ex)
			{
				System.out.println("在修改专题关闭连接时出错："+sql+ex);
			}

		}
	}   	  	    
}