webparamaddservlet.java

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

package servlet;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 * Servlet implementation class for Servlet: WebParamAddServlet
 *
 */
 public class WebParamAddServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet{
   static final long serialVersionUID = 1L;
   
    /* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#HttpServlet()
	 */
	public WebParamAddServlet(){
		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
	}  	
	
	/* (non-Java-doc)
	 * @see javax.servlet.http.HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
		request.setCharacterEncoding("gb2312");
		response.setContentType("text/html;charset=gb2312");
		//DBControl DC=new DBControl();
		PrintWriter out=response.getWriter();
		String WebStatName=request.getParameter("WebStatName");
		String ManEmail=request.getParameter("ManEmail");
		String WebIntroduce=request.getParameter("WebIntroduce");
		String CallMe=request.getParameter("CallMe");
		String AboutMe=request.getParameter("AboutMe");
		String WebDownMs=request.getParameter("WebDownMs");
		//PreparedStatement pstm=null;
		String sql="update wepparameter set WebStatName=?,ManEmail=?,WebIntroduce=?,CallMe=?,AboutMe=?,WebDownMs=?";
		db.DB dt=new db.DB();
		dt.prepareStatement(sql);
		dt.setString(1, WebStatName);
		dt.setString(2, ManEmail);
		dt.setString(3, WebIntroduce);
		dt.setString(4, CallMe);
		dt.setString(5, AboutMe);
		dt.setString(6, WebDownMs);
		if(dt.executeUpdate())
			 out.println("保存失败");
		else out.println("保存成功");
		out.close();
//		try{DC.getConnPool();pstm=DC.conn.prepareStatement(sql);pstm.setString(1, WebStatName);	pstm.setString(2, ManEmail);pstm.setString(3, WebIntroduce);pstm.setString(4, CallMe);	pstm.setString(5, AboutMe);	pstm.setString(6, WebDownMs);pstm.executeUpdate();}catch(Exception ex){System.out.print("在更新站点信息时出错"+ex);}finally{//DC.closeAll();
//			out.println("保存成功");}
		}
	}