/*
?*?To?change?this?template?choose?Tools?|?Templates
?*?and?open?the?template?in?the?editor.
?*/

package?action;

/**
?*
?*?@author?Administrator
?*/
import?java.io.UnsupportedEncodingException;
import?java.sql.*;
import?java.util.ArrayList;
import?com.opensymphony.xwork2.Action;
import?javax.servlet.http.HttpServletRequest;
import?org.apache.struts2.ServletActionContext;
public?class?BookSearchAction?implements?Action{
????????private?ArrayList?list=new?ArrayList（）;
????????private?ArrayList?list1=new?ArrayList（）;
????????private?String?text_content;
????????private?String?radio;
????????private?String?search_ISBN;
????????private?String?alert;
????????private?String?prompt;

????????link?link=new?link（）;//調用link對象，用來完成對數據庫的操作
????????Statement?st?=?link.st;
????????ResultSet?rs?;
????????ResultSet?rs1?;
????????
????????String?sql=null;

????????HttpServletRequest?request?=?ServletActionContext.getRequest（）;

????public?String?execute（）?throws?Exception?{
????????System.out.println（text_content）;


????????if（radio.equals（“book_name“））
????????sql=“SELECT?*?FROM?books_information?where?書名?like“+“‘%“+text_content+“%‘“;

????????if（radio.equals（“book_author“））
????????sql=“SELECT?*?FROM?books_information?where?作者?like“+“‘%“+text_content+“%‘“;

????????if（radio.equals（“book_press“））
????????sql=“SELECT?*?FROM?books_information?where?出版社?like“+“‘%“+text_content+“%‘“;

????????rs=st.executeQuery（sql）;
????????????while（rs.next（））?{
????????????books_information_bean?bean=new?books_information_bean（）;
????????????bean.ISBN=rs.getString（“ISBN“）;
????????????bean.book_name=rs.getString（“書名“）;
????????????bean.author=rs.getString（“作者“）;
????????????bean.publishing_house=rs.getString（“出版社“）;
????????????bean.publishing_date=rs.getString（“出版日期“）.substring（0?4）;
????????????bean.price=rs.getString（“價格“）;
????????????bean.book_amount=rs.getString（“書籍總數量“）;
????????????bean.available_amount=rs.getString（“可借數量“）;

????????????list.add（bean）;
????????????}

????????????request.setAttribute（“search_list“?list）;
????????????return?SUCCESS;

??????

????}
????????public?String?see_details（）?throws?Exception?{
????????????
????????????sql=“SELECT?*?FROM?books?where?ISBN?=‘“+search_ISBN+“‘?and?（借閱狀態=‘可借‘?or??借閱狀態=‘預約到館‘）“??;
????????????rs=st.executeQuery（sql）;
????????????
????????????if（rs.isAfterLast（）==rs.isBeforeFirst（））{
????????????????alert=“order“;
????????????????prompt=“沒副本在館可以預約“;
????????????????request.setAttribute（“alert“?alert）;
????????????????request.setAttribute（“prompt“?prompt）;
????????????}
????????????else{
????????????????alert=“disable“;
????????????????prompt=“有副本在館不能預約“;
????????????????request.setAttribute（“alert“?alert）;
????????????????request.setAttribute（“prompt“?prompt）;
????????????}
????????????
????????????
????????????while（rs.next（））?{
????????????????
????????????????//if（rs.getString（“借閱狀態“）.equals（“可借“））{
????????????????books_information_bean?bean=new?books_informati

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????3511??2011-05-18?08:14??圖書館系統\build.xml

?????文件?????703265??2008-05-09?15:30??圖書館系統\mysql-connector-java-5.1.6-bin.jar

?????文件???????1445??2011-06-07?00:55??圖書館系統\web\administrator.jsp

?????文件???????4135??2011-06-22?00:19??圖書館系統\web\books_information_manage.jsp

?????文件???????2170??2011-06-22?00:19??圖書館系統\web\book_information.jsp

?????文件???????2590??2011-06-22?00:19??圖書館系統\web\borrow.jsp

?????文件????????463??2011-05-29?00:32??圖書館系統\web\error.jsp

?????文件???????2939??2011-09-14?15:37??圖書館系統\web\login.jsp

?????文件??????11019??2011-05-10?01:03??圖書館系統\web\logo[1].jpg

?????文件???????2176??2011-06-20?00:35??圖書館系統\web\order_book.jsp

?????文件???????2357??2011-06-22?00:19??圖書館系統\web\power_mange.jsp

?????文件???????1364??2011-06-15?17:03??圖書館系統\web\reader.jsp

?????文件???????3293??2011-09-14?15:37??圖書館系統\web\reders_information_manage.jsp

?????文件???????2436??2011-06-15?22:16??圖書館系統\web\renew.jsp

?????文件???????2588??2011-06-22?00:19??圖書館系統\web\return.jsp

?????文件???????2246??2011-06-22?00:19??圖書館系統\web\return_search.jsp

?????文件???????2275??2011-08-19?00:58??圖書館系統\web\search.jsp

?????文件????????783??2011-05-18?01:16??圖書館系統\web\WEB-INF\web.xml

?????文件???????4661??2011-09-07?15:01??圖書館系統\web\WEB-INF\classes\struts.xml

?????文件?????????86??2011-05-18?01:12??圖書館系統\web\meta-INF\context.xml

?????文件???????4745??2011-08-31?15:44??圖書館系統\src\java\action\BookSearchAction.java

?????文件???????5976??2011-06-11?01:02??圖書館系統\src\java\action\BooksInformationManageAction.java

?????文件???????3025??2011-06-11?00:30??圖書館系統\src\java\action\books_information_bean.java

?????文件??????12460??2011-06-21?00:07??圖書館系統\src\java\action\BorrowAction.java

?????文件????????403??2011-05-28?00:08??圖書館系統\src\java\action\borrow_books_bean.java

?????文件???????2810??2011-06-05?01:37??圖書館系統\src\java\action\ChangePowerAction.java

?????文件????????895??2011-05-18?01:33??圖書館系統\src\java\action\link.java

?????文件???????4976??2011-09-07?15:01??圖書館系統\src\java\action\LoginAction.java

?????文件???????8447??2011-06-21?21:57??圖書館系統\src\java\action\OrderAction.java

?????文件????????399??2011-06-15?14:04??圖書館系統\src\java\action\order_books_bean.java

............此處省略95個文件信息