topicaddservlet.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.*;
import java.sql.*;

/**
 * Servlet implementation class for Servlet: TopicAddServlet
 *
 */
 public class TopicAddServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	 private DBControl DC=new DBControl();
	public TopicAddServlet() {
		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
		response.setContentType("text/html;charset=gb2312");
		request.setCharacterEncoding("gb2312");//解决中文显示问题
		
		RequestDispatcher rd=null;
		
		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("add", -1))
		{
			rd=request.getRequestDispatcher("/jsjadmin/Menu/Topic_add.jsp");
			rd.forward(request, response);
			return;
		}
		DC.getConnPool();
		int OrderList=DC.ReturnFieldMax("topic", "OrderList")+1;//得么排序的序号
		
		DealString dlsg=new DealString();
		PreparedStatement pstm=null;
		String sql="insert into topic (TopicName,Introduce,OrderList,AddTime,ArticleNum,ArticleClick) values(?,?,?,?,?,?)";
		try
		{
			
			pstm=DC.conn.prepareStatement(sql);
			pstm.setString(1, TopicName);
			pstm.setString(2, Introduce);
			pstm.setInt(3, OrderList);
			pstm.setString(4,dlsg.getShortTime());
			pstm.setInt(5, 0);
			pstm.setInt(6,0);
			pstm.executeUpdate();
			
			rd=request.getRequestDispatcher("/jsjadmin/Menu/Topic_add_success.jsp?action=add");
			rd.forward(request, response);
		}catch(SQLException ex)
		{
			System.out.println("在执行SQL"+sql+"时发生错误。"+ex);
		}
		finally
		{
			try
			{
				pstm.close();
				DC.closeConn();
			}catch(SQLException ex)
			{
				System.out.println("在执行SQL"+sql+"关闭。PreparedStatement和连接时发生错误"+ex);
			}
		}
		
	}   	  	    
}