package?bookshop.utils;

import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.logging.Level;
import?java.util.logging.Logger;

public?class?Books?extends?Execute_DB?{
????//定義類成員變量

????private?int?bookID;???//圖書編號(hào)
????private?String?bookName;??//圖書名稱
????private?String?author;?//圖書作者
????private?String?pub;??//出版社
????private?float?price;??//單價(jià)
????private?int?sortID;???//圖書分類號(hào)
????private?String?intro;??//圖書簡(jiǎn)介
????private?int?recommendNumber;??//推薦圖書編號(hào)
????private?String?sql;??//要執(zhí)行的sql語句

????//初始化類成員變量
????public?Books（）?{
????????this.bookID?=?0;
????????this.bookName?=?““;
????????this.author?=?““;
????????this.sortID?=?0;
????????this.price?=?0;
????????this.pub?=?““;
????????this.intro?=?““;
????????this.recommendNumber?=?0;
????????this.sql?=?““;
????}
????//向books表中插入一條新記錄

????public?boolean?add_book（）?{
????????this.sql?+=?“insert?into?books?（bookNameauthorsortIDpricepubintrorecommendNumber）?values（‘“?+?this.getBookName（）?+?“‘“;
????????this.sql?+=?“‘“?+?this.getAuthor（）?+?“‘“?+?this.getSortID（）?+?““?+?this.getPrice（）?+?““?+?“‘“?+?this.getPub（）?+?“‘“?+?“‘“?+?this.getIntro（）?+?“‘“;
????????this.sql?+=?this.getRecommendNumber（）?+?“）“;
????????boolean?isAdd?=?super.exeSql（sql）;
????????return?isAdd;
????}
????//修改類成員變量bookID對(duì)應(yīng)的圖書信息

????public?boolean?modify_info（）?{
????????this.sql?=?“update?books?set?bookName=?author=?sortID=?price=?pub=?intro=??where?bookID=?“;
????????PreparedStatement?pstmt?=?null;
????????try?{
????????????pstmt?=?Execute_DB.getConn（）.prepareStatement（this.sql）;
????????}?catch?（SQLException?ex）?{
????????????Logger.getLogger（Books.class.getName（））.log（Level.SEVERE?null?ex）;
????????}
????????try?{
????????????pstmt.setString（1?this.bookName）;
????????????pstmt.setString（2?this.author）;
????????????pstmt.setString（3?String.valueOf（this.sortID））;
????????????pstmt.setString（4?String.valueOf（this.price））;
????????????pstmt.setString（5?this.pub）;
????????????pstmt.setString（6?this.intro）;
????????????pstmt.setString（7?String.valueOf（this.bookID））;
????????????int?count?=?pstmt.executeUpdate（）;
????????????if?（count?==?0）?{
????????????????return?false;???//更新失敗
????????????}?else?{
????????????????return?true;???//更新成功
????????????}
????????}?catch?（Exception?e）?{
????????????System.out.println（e.toString（））;
????????????return?false;???//數(shù)據(jù)庫操作異常
????????}
????}

????//刪除表books中bookID對(duì)應(yīng)的圖書記錄信息
????public?boolean?delete_book（int?deleteBookID）?{
????????this.sql?=?“delete?from?books?where?bookID?in?（“;
????????this.sql?+=?deleteBookID?+?“）“;

????????boolean?isDelete?=?super.exeSql（sql）;
????????return?isDelete;
????}
????//刪除該書
????public?boolean?delete_book（）?{
????????this.sql?=?“delete?from?books?where?bookID=“?+?this.bookID;
????????boolean?isDelete?=?super.exeSql（sql）;
????????return?isDelete;
????}
????//初始化bookID和bookName對(duì)應(yīng)的圖書信息

????public?boolean?init（String?bookName?String?author）?{
????????this.sql?=?“select?*?from?books?wher

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????3743??2010-07-01?02:12??OBBS\build\web\admin\add_book_form.jsp

?????文件???????3484??2010-07-01?02:12??OBBS\build\web\admin\add_book_save.jsp

?????文件???????1093??2010-07-01?02:12??OBBS\build\web\admin\add_sort_form.jsp

?????文件???????2380??2010-07-01?02:12??OBBS\build\web\admin\add_sort_save.jsp

?????文件???????3502??2010-07-01?02:12??OBBS\build\web\admin\books_management.jsp

?????文件???????2228??2010-07-01?02:12??OBBS\build\web\admin\delete_book.jsp

?????文件???????1592??2010-07-01?02:12??OBBS\build\web\admin\delete_goods.jsp

?????文件???????1620??2010-07-01?02:12??OBBS\build\web\admin\delete_sorts.jsp

?????文件???????5756??2010-07-01?02:12??OBBS\build\web\admin\goods_management.jsp

?????文件???????1149??2010-07-01?02:12??OBBS\build\web\admin\index.jsp

?????文件???????4366??2010-07-01?02:12??OBBS\build\web\admin\modify_book_form.jsp

?????文件???????2297??2010-07-01?02:12??OBBS\build\web\admin\modify_book_save.jsp

?????文件???????1103??2010-07-01?02:12??OBBS\build\web\admin\modify_sort_form.jsp

?????文件???????2217??2010-07-01?02:12??OBBS\build\web\admin\modify_sort_from_sorts.jsp

?????文件???????1995??2010-07-01?02:12??OBBS\build\web\admin\modify_sort_save.jsp

?????文件???????2705??2010-07-01?02:12??OBBS\build\web\admin\sorts_management.jsp

?????文件????????776??2010-07-01?02:12??OBBS\build\web\admin\top.jsp

?????文件???????4065??2010-07-01?02:12??OBBS\build\web\admin\user_detail.jsp

?????文件???????1378??2010-07-01?02:12??OBBS\build\web\get_userpassword_form.jsp

?????文件???????1513??2010-07-01?02:12??OBBS\build\web\index.jsp

?????文件????????305??2010-07-01?02:12??OBBS\build\web\loginOrNot.jsp

?????文件????????136??2010-07-01?02:12??OBBS\build\web\logout.jsp

?????文件?????????85??2010-07-01?02:12??OBBS\build\web\meta-INF\context.xml

?????文件?????????25??2010-07-01?02:12??OBBS\build\web\meta-INF\MANIFEST.MF

?????文件???????2595??2010-07-01?02:12??OBBS\build\web\normal\add_goods_form.jsp

?????文件???????1747??2010-07-01?02:12??OBBS\build\web\normal\add_goods_save.jsp

?????文件???????3538??2010-07-01?02:12??OBBS\build\web\normal\book_detail.jsp

?????文件???????3702??2010-07-01?02:12??OBBS\build\web\normal\book_list.jsp

?????文件???????1706??2010-07-01?02:12??OBBS\build\web\normal\delete_goods.jsp

?????文件???????2664??2010-07-01?02:12??OBBS\build\web\normal\index.jsp

............此處省略142個(gè)文件信息