package com.jspdev.servlet;

import com.jspdev.business.*;
import javax.servlet.http.*;
import com.jspdev.util.DatabaseConn;
import java.sql.*;
import java.io.*;

/**
 *重新編輯指定的帖子
 */
public class EditTopicServlet extends javax.servlet.http.HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
	  
        try
        {
        	/**
        	 *獲得請求中的參數(shù)，動態(tài)生成SQL語句。
        	 */
        	String type=request.getParameter("type");
        	String id=request.getParameter("id");
        	String title=request.getParameter("title");
        	String author=request.getParameter("author");
        	String email=request.getParameter("email");
        	String content=request.getParameter("content");
        	String sql="";
        	if(type.equals("topic"))
        	   sql="update topic set title='"+title+"',author='"+author+"',email='"+email+"',content='"+content+"' where id='"+id+"'";
        	else 
        	   sql="update reply set title='"+title+"',author='"+author+"',email='"+email+"',content='"+content+"' where id='"+id+"'";
        	Connection con=DatabaseConn.getConnection();
        	Statement stmt=con.createStatement();
            /**
             *執(zhí)行數(shù)據(jù)庫更新操作，更新的信息保存到數(shù)據(jù)庫中
             */
        	stmt.executeUpdate(sql);
        	stmt.close();
        	con.close();
        	PageBusiness pb=new ForumBean();
        	PageBean  pageCtl = pb.listData("1");
        	request.setAttribute("pageCtl",pageCtl);
        }
        catch(Exception e)
        {
        	e.printStackTrace();
        }
       
       /**
         *把視圖派發(fā)到viewForum.jsp
         */  
        javax.servlet.RequestDispatcher dis=request.getRequestDispatcher("/forum/viewForum.jsp");
        dis.forward(request,response);
    }
    public void doPost(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{
		doGet(request,response);
	}
}