import?java.sql.*;
public?class?BuyBook
{???long?id=0;
????String?order_number
???????????book_name;
????Connection?con;
????Statement?sql;?
????ResultSet?rs;
????public?BuyBook（）
????{??//加載橋接器：
???????try{Class.forName（“sun.jdbc.odbc.JdbcOdbcDriver“）;
??????????}
???????catch（ClassNotFoundException?e）{}
????}
??//設置屬性值、獲取屬性值的方法：
??public?void?setId（long?n）
????{id=n;
????}
??public?long?getId（）
????{return?id;
????}
??public?void?setBook_name（String?name）
????{??book_name=name;
????}
??public?String?getBook_name（）
????{return?book_name;
????}
??public?void?setOrder_number（String?number）
????{??order_number=number;
????}
??public?String?getOrder_number（）
????{return?order_number;
????}
??//通過書的id號查詢數據庫的book表：
???public?StringBuffer?getMessageBybook_id（）
????{
?????StringBuffer?buffer=new?StringBuffer（）;
?????try{
?????????con=DriverManager.getConnection（“jdbc:odbc:shop“““““）;
?????????sql=con.createStatement（）;
??????????String?condition=“SELECT?*?FROM?book?WHERE?id?=?“+id;
??????????rs=sql.executeQuery（condition）;
?????????buffer.append（“?“）;
????????????buffer.append（““）;
???????buffer.append（““+““+“id“+““）;
???????buffer.append（““+““+“訂購號“+““）;
???????buffer.append（““+““+“書名“+““）;
???????buffer.append（““+““+“作者“+““）;
???????buffer.append（““+““+“出版社“+““）;
???????buffer.append（““+““+“出版時間“+““）;
???????buffer.append（““+““+“價錢“+““）;
???????buffer.append（““+““+“分類“+““）;
???????buffer.append（““）;
???????????while（rs.next（））
???????????{?order_number=rs.getString（2）;
?????????????book_name=rs.getString（3）;
?????????????String?作者=rs.getString（4）;
?????????????String?出版社=rs.getString（5）;
?????????????Date?時間=rs.getDate（6）;
?????????????String?價格=rs.getString（“price“）;
?????????????String?分類=rs.getString（“category“）;?
?????????????buffer.append（““）;
?????????????buffer.append（““+““+rs.getLong（1）+““）;
?????????????buffer.append（““+““+order_number+““）;
?????????????buffer.append（““+““+book_name+““）;
?????????????buffer.append（““+““+作者+““）;
?????????????buffer.append（““+““+出版社+““）;
?????????????buffer.append（““+““+時間+““）;
?????????????buffer.append（““+““+價格+““）;
?????????????buffer.append（““+““+分類+““）;
?????????????buffer.append（““）;
??????????}?
????????buffer.append（““）;
????????buffer.append（““）;
????????con.close（）;
????????return?buffer;
???????}
?????catch（SQLException?e）
???????{?return?buffer;
???????}
????}
}

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

?????文件????????174??2008-05-05?16:16??網上書店\bookstore\bookmain.jsp

?????文件???????3032??2008-05-05?16:20??網上書店\bookstore\BuyBook.java

?????文件???????3481??2008-05-05?16:21??網上書店\bookstore\buybook.jsp

?????文件???????1691??2008-05-05?16:24??網上書店\bookstore\changeForm.jsp

?????文件???????1424??2008-05-05?16:24??網上書店\bookstore\deleteForm.jsp

?????文件????????933??2008-05-05?16:15??網上書店\bookstore\head.txt

?????文件???????2235??2008-05-05?16:19??網上書店\bookstore\Login.java

?????文件???????2983??2008-05-05?16:23??網上書店\bookstore\modifyForm.jsp

?????文件???????3597??2008-05-05?16:28??網上書店\bookstore\modifyMessage.jsp

?????文件???????3175??2008-05-05?16:27??網上書店\bookstore\modifyPassword.jsp

?????文件???????2088??2008-05-05?16:21??網上書店\bookstore\OrderForm.java

?????文件????????864??2008-05-05?16:25??網上書店\bookstore\PageNumber.java

?????文件???????1874??2008-05-05?16:16??網上書店\bookstore\Register.java

?????文件???????6921??2008-05-05?16:26??網上書店\bookstore\showBookList.jsp

?????文件???????2437??2008-05-05?16:22??網上書店\bookstore\showOrderForm.jsp

?????文件???????1836??2008-05-05?16:19??網上書店\bookstore\userLogin.jsp

?????文件???????2944??2008-05-05?16:18??網上書店\bookstore\userRegister.jsp

?????文件????????667??2006-02-06?15:50??網上書店\超雅致ASP書店商城網站管理系統源碼說明\51.xml

?????文件????????393??2006-01-31?16:29??網上書店\超雅致ASP書店商城網站管理系統源碼說明\ad.asp

?????文件???????8547??2006-02-03?18:40??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\addcat.asp

?????文件???????5452??2005-10-10?18:15??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\addgrp.asp

?????文件???????7763??2006-02-03?18:38??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\AddMark.asp

?????文件???????2156??2007-08-07?09:45??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\addnews.asp

?????文件???????2156??2007-08-07?09:45??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\addpro.asp

?????文件???????4913??2005-10-19?07:58??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\admin.asp

?????文件???????8844??2005-10-10?18:16??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\admincomment.asp

?????文件??????16171??2006-11-08?12:21??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\admindata.asp

?????文件???????8070??2005-10-10?18:16??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\adminuser.asp

?????文件???????2155??2007-08-07?09:45??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\bclass.asp

?????文件???????3200??2005-10-10?18:16??網上書店\超雅致ASP書店商城網站管理系統源碼說明\admin\body.fix

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