2 3 5 6 9 12 13 15 17 18 20 22 23 24 25 26 27 28 29 30 33 36 37 38 1
(ISBN) (reg_no) (ISBN) 2
Dreamweaver (SQL) 1.? 2.? 3.? 4.? 5.? 6.? 3
( ) (reg_no) (ISBN) 4
10 11 5
(library) 6
(library) (library) (library) 4 f7m_2008 book borrow booked 7
8
(mydb) 5 D4 Login Name, password Name F7m_2008 Reg_no, class, clsno, ename, dob, bk_quota, Reg_no number Book ISBN, book_name, author, subject, state, ISBN number Booked Reg_no, ISBN, booked_day, get_day Reg_no, ISBN Borrow Reg_no, ISBN, borrow_day, return_day Reg_no, ISBN login login (name) (password) Name f7m_2008 f7m_2008 (reg_no) (class) (clsno) (ename) (dob) (bk_quota) (number) reg_no book book (ISBN) (book_name) (author) (subject) (state) (number) ISBN 9
booked booked (reg_no) (ISBN) (booked_day) (get_day) reg_no ISBN borrow borrow (reg_no) (ISBN) (borrow_day) (return_day) reg_no ISBN
name password login ename return_day borrow_day class number dob bk_quota reg_no ISBN f7m_2008 N M borrow clsno 1 reg_no clsno 1 M number M booked ISBN book reg_no ISBN author subject get_day booked_day book_name state 11
12
! 4! 4 login library 999 13
14
borrow 6 6 7 15
' ISBN= ' borrow f7m_2008 7 bk_quota number book state 'in' 'out' number ' ' 16
' ISBN= ' borrow f7m_2008 bk_quota book state 'out' 'in' ' 17
borrow 18
' ISBN= ' f7m_2008 number borrow book number 7 19
booked $2.5 ' ISBN=, ' 7 ' 20
booked 7 book state 'out' 'out+booked' ' f7m_2008 21
$1 ISBN borrow 3 $3 22
ISBN ' ' ISBN 'in' ' 'out' ' ' 'out+booked' ' 23
borrow ISBN ISBN 24
D4 最佳讀者 學生可以在最佳讀者頁面中 顯示的結果是由借閱圖書數量最多的讀者排至借閱圖 書數量最少的讀者 這樣可以讓學生知道自己及其他學生在借書數量上的分別 以鼓勵 學生借更多圖書 下降 25
26
27
28
Microsoft Outlook : enquiry@library.com 29
:library :999 :abc :library :123! 4!! 4! :20021634 :1 20021634 ISBN=1 :20021111,! :20021111 :222 :20021634 :1 6,! :1 ISBN=1 :1 ISBN=1 :222, 30
31! :20021505 :2 20021634 ISBN=1 :20021122,! :20021122 :233,! :20021634 :3 20021634,! :20021618 :2 ISBN=1, '2008XXXX'' :20021144,! :20021618 :299,! :20021618 : 7 : 6
: 888 : china : haha : ben lam : goods : 3 : maths : 4 : cuba : china : chinese : china : comp : ben lam : england : ben lam : art :20021415 :20028888 32
1. 10 11 2. 2GB 15 33
3. 4. 6 6 7 5. 7 34
6. $1 7 7. $1 $2 8. 35
9. 10. Microsoft Outlook SMTP POP3 11. ISBN ( ) (RAM) (RAM) UNIX RAID5 36
37
1. PHP MYSQL 2. SQL SERVER 2005 3. DREAMWEAVER MX 2004 PHP 4. http://kmserv.com/php3/index/ 5. DREAMWEAVER 8 38