package?com.action;

import?org.apache.struts.action.ActionMapping;
import?org.apache.struts.action.ActionForm;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;
import?org.apache.struts.action.ActionForward;
import?com.actionForm.BookForm;
import?org.apache.struts.action.Action;
import?com.dao.BookDAO;
import?java.util.Date;

public?class?Book?extends?Action?{
????private?BookDAO?bookDAO?=?null;
????public?Book（）?{
????????this.bookDAO?=?new?BookDAO（）;
????}

????public?ActionForward?execute（ActionMapping?mapping?ActionForm?form
?????????????????????????????????HttpServletRequest?request
?????????????????????????????????HttpServletResponse?response）?{
????????String?action?=request.getParameter（“action“）;
????????System.out.println（“\nbook*********************action=“+action）;
????????if（action==null||““.equals（action））{
????????????request.setAttribute（“error““您的操作有誤！“）;
????????????return?mapping.findForward（“error“）;
????????}else?if（“bookAdd“.equals（action））{
????????????return?bookAdd（mappingformrequestresponse）;
????????}else?if（“bookQuery“.equals（action））{
????????????return?bookQuery（mappingformrequestresponse）;
????????}else?if（“bookModifyQuery“.equals（action））{
????????????return?bookModifyQuery（mappingformrequestresponse）;
????????}else?if（“bookModify“.equals（action））{
????????????return?bookModify（mappingformrequestresponse）;
????????}else?if（“bookDel“.equals（action））{
????????????return?bookDel（mappingformrequestresponse）;
????????}else?if（“bookDetail“.equals（action））{
????????????return?bookDetail（mappingformrequestresponse）;
????????}else?if（“bookifQuery“.equals（action））{
????????????return?bookifQuery（mappingformrequestresponse）;
????????}
????????request.setAttribute（“error““操作失敗！“）;
????????return?mapping.findForward（“error“）;
????}
????/***********************添加圖書信息**************************/
????private?ActionForward?bookAdd（ActionMapping?mapping?ActionForm?form
??????????????????????????????HttpServletRequest?request
??????????????????????????????HttpServletResponse?response）{
???????????BookForm?bookForm?=?（BookForm）?form;
???????????bookForm.setBarcode（bookForm.getBarcode（））;
???????????bookForm.setBookName（bookForm.getBookName（））;
???????????bookForm.setTypeId（bookForm.getTypeId（））;
???????????bookForm.setAuthor（bookForm.getAuthor（））;
???????????bookForm.setTranslator（bookForm.getTranslator（））;
???????????bookForm.setIsbn（bookForm.getIsbn（））;
???????????bookForm.setPrice（bookForm.getPrice（））;
???????????bookForm.setPage（bookForm.getPage（））;
???????????bookForm.setBookcaseid（bookForm.getBookcaseid（））;????
???????????//獲取系統日期
???????????Date?date1=new?Date（）;
???????????java.sql.Date?date=new?java.sql.Date（date1.getTime（））;
???????????bookForm.setInTime（date.toString（））;
???????????bookForm.setOperator（bookForm.getOperator（））;
???????????int?a=bookDAO.insert（bookForm）;
???????????if（a==1）{