package com.service;

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

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

import com.data.Bbs;
import com.db.DataProcess;

public class delInf extends HttpServlet {

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

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

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

		response.setContentType("text/xml;charset=utf-8");
		response.setHeader("Cache-Control","no-cache"); 
		PrintWriter out = response.getWriter();
		request.setCharacterEncoding("UTF-8"); 
		StringBuffer backInf=new StringBuffer();
		HttpSession sess=request.getSession(true);
		
		String del=request.getParameter("del");//讀要刪除的用戶類型
		
		if(del.equals("banz")){//刪除版主
		 System.out.println("刪除斑主要");
	     int board_id=Integer.parseInt(request.getParameter("board_id"));//讀取版面id
	     deleboard(board_id);//刪除斑竹信息
	     
	     //查詢版主帖子
	     String sql="select * from bbs where board_id="+board_id; 
		
	     Connection con=DataProcess.getConnection(); 
	        Statement pStmt=null;
	    	ResultSet rs=null;
	        Bbs bbs=new Bbs();
	        try{
	        	pStmt=con.createStatement();
	        	rs=pStmt.executeQuery(sql);
	        	if(rs.next()){
	        		int bbs_id=rs.getInt("bbs_id");
	        		delebbs(bbs_id);//刪除帖子信息
	        	}
	        	
	        	
	        }catch(Exception e){
	        	e.printStackTrace();
	        	
	        }finally{
	        	try {
					rs.close();
				    pStmt.close();
	        	    con.close();
	        	} catch (SQLException e) {
					
					e.printStackTrace();
				}
	        }
		}else{
			//刪除帖子
			int bbs_id=Integer.parseInt(request.getParameter("bbs_id"));//讀取bbs_id
			delebbs(bbs_id);//調用刪除函數
			
		    
		}
		
		out.print(backInf.toString());
		out.flush();
		out.close();
	}

	/**
	 * Initialization of the servlet. <br>
	 *
	 * @throws ServletException if an error occure
	 */
	public void deleboard(int board_id){//刪除斑竹
		String sql="delete from board where board_id="+board_id;
		DataProcess.ExeQuery(sql);
		
	}
	public void delebbs(int bbs_id){//刪除帖子
		String sql1="delete from bbs where bbs_id="+bbs_id;
		String sql2="delete from bbsub where bbs_id="+bbs_id;
		if(DataProcess.ExeQuery(sql1)){
			
			System.out.println("true");
		}
		DataProcess.ExeQuery(sql2);
		
		
	}
	public void init() throws ServletException {
		// Put your code here
	}

}