reversiondate.java

JSP+SQL2005 MVC模式 下载后改DB.java类的SQL密码就可用。

package com.model.servlet;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Timestamp;

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

import com.model.javabean.DB;
import com.model.tools.ToChinese;

public class ReversionDate extends HttpServlet {

	/**
	 * Constructor of the object.
	 */
	public ReversionDate() {
		super();
	}

	/**
	 * Destruction of the servlet. <br>
	 */
	public void destroy() {
		super.destroy(); // Just puts "destroy" string in log
		// Put your code here
	}


	public void doGet(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {

		ToChinese change = new ToChinese();
		String id=request.getParameter("id");
		String num=request.getParameter("num");
		String rev_title=request.getParameter("revTitle");
		String rev_user=request.getParameter("revUser");
		String rev_content=request.getParameter("revContent");
		Timestamp rev_time=new Timestamp(new java.util.Date().getTime());
		
		rev_title=change.ToChange(rev_title);
		rev_user=change.ToChange(rev_user);
		rev_content=change.ToChange(rev_content);
		
		String sql="insert into tb_revert values('"+rev_title+"','"+rev_user+"','"+rev_time+"','"+rev_content+"',"+num+","+id+")";
		System.out.print(sql);
		
		DB mydb=new DB();
		int i=mydb.CreateOrUpdate(sql);
		if(i>0){
			request.setAttribute("doResult","<li>回复帖子成功！</li>");			
		}
		else{
			request.setAttribute("doResult","<li>回复帖子失败！</li>");
		}
		RequestDispatcher rd=request.getRequestDispatcher("reversion.jsp");
		rd.forward(request,response);
	}

	
	protected void doPost(HttpServletRequest request, HttpServletResponse response)
	       throws ServletException, IOException {
		doGet(request,response);
	}
	
	

}