package com.webtier;

import javax.servlet.*;
import javax.servlet.http.*;
import java.io.*;
import java.util.*;
import com.domain.AccountsVO;
import com.dao.AccountsDao;

public class AccountsServlet
    extends HttpServlet {
  private int method;
  private AccountsVO vo;
  private AccountsDao dao;
  public void doGet(HttpServletRequest request, HttpServletResponse response) throws
      ServletException, IOException {
    request.setCharacterEncoding("gb2312");
    method = Integer.parseInt(request.getParameter("method"));
    vo = new AccountsVO();
    dao = new AccountsDao();
    switch (method) {
      case 0: {
        this.accountsSelect(request, response); //全部查詢
        break;
      }
      case 1: {
        this.accountsInsert(request, response); //添加
        break;
      }
      case 2: {
        this.accountsDelete(request, response); //刪除操作
        break;
      }
      case 4:{
        this.accountsSelectOne(request,response);//條件查詢
                break;
      }
      case 5:{
        this.accountsUpdate(request,response);//修改操作
              break;
      }
    }
  }

  //條件查詢的操作
  public void accountsSelectOne(HttpServletRequest request,
                                HttpServletResponse response) throws
      ServletException, IOException {
    AccountsVO accounts = dao.accountsSelectOne(request.getParameter("number"));
    System.out.println("vo="+accounts);
    request.setAttribute("accounts", accounts);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher("dataAccounts/accountsUpdate.jsp");
    requestDispatcher.forward(request, response);
  }

  //修改操作
  public void accountsUpdate(HttpServletRequest request,
                             HttpServletResponse response) throws
      ServletException, IOException {
    String name = request.getParameter("name");
    vo.setId(Integer.valueOf(request.getParameter("id")));
    vo.setAccounts_name(name);
    vo.setAccounts_remark(request.getParameter("remark"));
    dao.accountsUpdate(vo);
    request.setAttribute("success", "修改信息成功！！！");

    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "dataAccounts/success.jsp");
    requestDispatcher.forward(request, response);
  }

  //刪除的操作
  public void accountsDelete(HttpServletRequest request,
                             HttpServletResponse response) throws
      ServletException, IOException {
    dao.accountsDelete(Integer.valueOf(request.getParameter("id")));
    request.setAttribute("success", "刪除信息成功");
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "dataAccounts/success.jsp");
    requestDispatcher.forward(request, response);
  }

//全部查詢
  public void accountsSelect(HttpServletRequest request,
                             HttpServletResponse response) throws
      ServletException, IOException {
    List list = dao.accountsSelect();
    int pageNumber = list.size(); //計算出有多少條記錄
    int maxPage = pageNumber; //計算有多少頁數
    String number = request.getParameter("i");
    if (maxPage % 5 == 0) {
      maxPage = maxPage / 5;
    }
    else {
      maxPage = maxPage / 5 + 1;
    }
    if (number == null) {
      number = "0";
    }
    request.setAttribute("number", String.valueOf(number));
    request.setAttribute("maxPage", String.valueOf(maxPage));
    request.setAttribute("pageNumber", String.valueOf(pageNumber));
    request.setAttribute("list", list);
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(
        "dataAccounts/accountSelect.jsp");
    requestDispatcher.forward(request, response);
  }

  //添加信息的操作
  public void accountsInsert(HttpServletRequest request,
                             HttpServletResponse response) throws
      ServletException, IOException {
    String url = null;
    String operate = request.getParameter("operate");
    if (operate == null) {
      url = "dataAccounts/accountsInsert.jsp";
    }
    else {
      String number = "noNumber";
      String name = request.getParameter("name");
      if (dao.accountsSelectName(name) != null) {
        request.setAttribute("success", "該名稱已經存在！！！");
      }
      else {
        vo.setAccounts_number(number);
        vo.setAccounts_name(name);
        vo.setAccounts_remark(request.getParameter("remark"));
        dao.accountsInsert(vo);

        AccountsVO accounts = dao.accountsSelectOne(number);
        System.out.println("vo=" + accounts);
        System.out.println("數據庫流水號=" + accounts.getId());
        dao.accountsUpdateNumber("accounts-" + accounts.getId(), accounts.getId());
        request.setAttribute("success", "添加信息成功！！！");
      }
      url = "dataAccounts/success.jsp";
    }
    RequestDispatcher requestDispatcher = request.getRequestDispatcher(url);
    requestDispatcher.forward(request, response);
  }

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