package bookservlets;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import bookutil.BookTools;
import bookutil.DataDo;
public class ManageServlet extends HttpServlet {
  private static final String CONTENT_TYPE = "text/html; charset=Big5";

  //Initialize global variables
  public void init() throws ServletException {
  }

  //Process the HTTP Get request
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    response.setContentType(CONTENT_TYPE);
    PrintWriter out = response.getWriter();
    //--------right check
    BookTools bt = new BookTools();
    String name = bt.elicitCookie(request,"master").toString();
    if(name == null || name.length() == 0){
      out.println("<script>window.location=\"manage/masterlogin.jsp\"</script>");
      return;
    }
    DataDo db = new DataDo();
    int status = 0;
    //----------process delete request
    if(request.getParameter("smdelete") != null)
    {
       String id = request.getParameter("id").trim();
      try {
        status = db.dataUpdate("delete from book where g_id in (" + id + ")");
        out.println("<script>window.alert(\""+status+" Records Victory ! \");</script>");
      }
      catch (Exception ex) {
        out.println("<script>window.alert(\" Execute SQL Error ! \");</script>");
      }
    }
    //----------process reply request
    if(request.getParameter("smreply") != null)
    {
      String id = request.getParameter("id").trim();
      String content = request.getParameter("reply").trim();
      content = new String(content.getBytes("ISO-8859-1"));
      try {
        status = db.dataUpdate("update book set g_reply='" + content +
                               "' where g_id='" + id + "'");
        out.println("<script>window.alert(\"" + status +
                    " Records Victory ! \");</script>");
      }
      catch (Exception ex) {
        out.println("<script>window.alert(\" Execute SQL Error ! \");</script>");
      }
    }
      //----------process master modify request
    if(request.getParameter("smmodify") != null)
    {
       String ms_name = request.getParameter("master_name").trim();
       String ms_psw = request.getParameter("master_psw").trim();
       ms_name = new String(ms_name.getBytes("ISO-8859-1"));
      try {
        status = db.dataUpdate("update masterlg set master_name='"+ms_name+"',master_psw='"+ms_psw+"' where master_id=1");
        out.println("<script>window.alert(\""+status+" Records Victory ! \");</script>");
      }
      catch (Exception ex) {
        out.println("<script>window.alert(\" Execute SQL Error ! \");</script>");
      }
    }
    db.dataClose();
    out.println("<script>window.location=\"manage/manage.jsp\";</script>");
  }

  //Process the HTTP Post request
  public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
    doGet(request, response);
  }

  //Clean up resources
  public void destroy() {
  }
}