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）{

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2014-03-28?23:06??圖書管理系統\Database\
?????目錄???????????0??2014-03-28?23:06??圖書管理系統\Database\db_librarySys\
?????文件??????????65??2007-11-21?13:56??圖書管理系統\Database\db_librarySys\db.opt
?????文件????????8624??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_bookcase.frm
?????文件??????????40??2007-12-29?13:29??圖書管理系統\Database\db_librarySys\tb_bookcase.MYD
?????文件????????2048??2007-12-29?13:29??圖書管理系統\Database\db_librarySys\tb_bookcase.MYI
?????文件????????8970??2007-12-18?16:47??圖書管理系統\Database\db_librarySys\tb_bookinfo.frm
?????文件?????????412??2008-01-10?15:51??圖書管理系統\Database\db_librarySys\tb_bookinfo.MYD
?????文件????????2048??2007-12-29?13:29??圖書管理系統\Database\db_librarySys\tb_bookinfo.MYI
?????文件????????8624??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_booktype.frm
?????文件??????????64??2007-12-29?11:03??圖書管理系統\Database\db_librarySys\tb_booktype.MYD
?????文件????????2048??2007-01-08?11:29??圖書管理系統\Database\db_librarySys\tb_booktype.MYI
?????文件????????8780??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_borrow.frm
?????文件?????????192??2007-01-08?11:29??圖書管理系統\Database\db_librarySys\tb_borrow.MYD
?????文件????????2048??2007-01-08?11:29??圖書管理系統\Database\db_librarySys\tb_borrow.MYI
?????文件????????8704??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_giveback.frm
?????文件??????????56??2007-01-03?11:12??圖書管理系統\Database\db_librarySys\tb_giveback.MYD
?????文件????????2048??2007-01-08?11:29??圖書管理系統\Database\db_librarySys\tb_giveback.MYI
?????文件????????8842??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_library.frm
?????文件??????????84??2007-12-29?10:58??圖書管理系統\Database\db_librarySys\tb_library.MYD
?????文件????????2048??2007-12-29?10:59??圖書管理系統\Database\db_librarySys\tb_library.MYI
?????文件????????8614??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_manager.frm
?????文件??????????40??2007-12-29?11:59??圖書管理系統\Database\db_librarySys\tb_manager.MYD
?????文件????????2048??2007-12-29?11:59??圖書管理系統\Database\db_librarySys\tb_manager.MYI
?????文件????????8624??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_parameter.frm
?????文件??????????13??2007-01-08?11:29??圖書管理系統\Database\db_librarySys\tb_parameter.MYD
?????文件????????2048??2007-01-08?11:29??圖書管理系統\Database\db_librarySys\tb_parameter.MYI
?????文件????????8596??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_publishing.frm
?????文件??????????56??2007-11-23?15:52??圖書管理系統\Database\db_librarySys\tb_publishing.MYD
?????文件????????1024??2007-11-23?16:14??圖書管理系統\Database\db_librarySys\tb_publishing.MYI
?????文件????????8746??2007-11-21?13:59??圖書管理系統\Database\db_librarySys\tb_purview.frm
............此處省略229個文件信息