package com.jspdev.servlet;

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

/**
 *刪除topic或者回復的帖子
 */
public class DeleteTopicServlet extends javax.servlet.http.HttpServlet
{
	public void doGet(HttpServletRequest request,HttpServletResponse response)
		throws javax.servlet.ServletException,java.io.IOException
	{

        try
        {
        	/**
        	 *獲得請求中的參數，動態生成SQL語句。
        	 */
        	String id=request.getParameter("id");        	
          	String type=request.getParameter("type");
          	String sql="";
          	if(type.equals("reply"))
            sql="delete from reply where id='"+id+"'";
            else 
               sql="delete from reply where topicId='"+id+"';delete from topic where id='"+id+"'";
          	Connection con=DatabaseConn.getConnection();
        	Statement stmt=con.createStatement();
        	/**
             *執行數據庫更新操作，刪除指定的記錄
             */
        	stmt.executeUpdate(sql);
            stmt.close();
        	PageBusiness pb=new ForumBean();
        	PageBean  pageCtl = pb.listData("1");
        	request.setAttribute("pageCtl",pageCtl);
        }
        catch(Exception e)
        {
        	e.printStackTrace();
        }
        
        /**
         *把視圖派發到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);
	}
}