資源簡(jiǎn)介
期末,數(shù)據(jù)庫(kù)老師讓做一個(gè)用數(shù)據(jù)庫(kù)結(jié)合任何一門語(yǔ)言做個(gè)小作品。剛好最近在學(xué)一點(diǎn)html/css,又會(huì)看了一點(diǎn)點(diǎn)jsp的視頻,做出了個(gè)小東西,在此記錄,共同進(jìn)步。用到的軟件:sql server,servlet,myEclipse
具體的要求如下:
①讀者基本信息的輸入,包括借書證編號(hào)、讀者姓名、讀者性別,讀者年級(jí),系別等。
②讀者基本信息的查詢、修改,包括讀者借書證編號(hào)、讀者姓名、讀者性別,讀者已借出的圖書相關(guān)信息,讀者可借出圖書數(shù)本(假設(shè)讀者借書數(shù)目的上限為5)等。
③書籍類別標(biāo)準(zhǔn)的制定、類別信息的輸入,包括類別編號(hào)、類別名稱。
④書籍類別信息的查詢、修改,包括類別編號(hào)、類別名稱。
⑤書籍庫(kù)存信息的輸入,包括書籍編號(hào)、書籍名稱、書籍類別、作者姓名、出版社名稱,剩余可借出的書籍?dāng)?shù)目。
⑥書籍庫(kù)存信息的查詢,修改,包括書籍編號(hào)、書籍名稱、書籍類別、作者姓名、出版社名稱,剩余可借出的書籍?dāng)?shù)目等。
⑦借書信息的輸入,包括讀者借書證編號(hào)、書籍編號(hào)。
⑧借書信息的查詢、修改,包括借書證編號(hào)、讀者姓名、書籍編號(hào)、書籍名稱等。
⑨還書信息的輸入,包括借書證編號(hào)、書籍編號(hào)。
⑩還書信息的查詢和修改,包括還書讀者借書證編號(hào)、讀者姓名、書籍編號(hào)、書籍名稱等。

代碼片段和文件信息
package?com.bean;
/**
?*?書籍庫(kù)存類
?*?@author?Administrator
?*
?*/
public?class?booksBean?{
private?String?book_no;
private?String?book_name;
private?String?book_author;
private?String?book_press;
private?int?book_rest_num;
private?String?book_type_no;
private?String?book_details;
private?String?picture;
public?booksBean()?{
}
public?String?getBook_no()?{
return?book_no;
}
public?void?setBook_no(String?book_no)?{
this.book_no?=?book_no;
}
public?String?getBook_name()?{
return?book_name;
}
public?void?setBook_name(String?book_name)?{
this.book_name?=?book_name;
}
public?String?getBook_author()?{
return?book_author;
}
public?void?setBook_author(String?book_author)?{
this.book_author?=?book_author;
}
public?String?getBook_press()?{
return?book_press;
}
public?void?setBook_press(String?book_press)?{
this.book_press?=?book_press;
}
public?int?getBook_rest_num()?{
return?book_rest_num;
}
public?void?setBook_rest_num(int?book_rest_num)?{
this.book_rest_num?=?book_rest_num;
}
public?String?getBook_type_no()?{
return?book_type_no;
}
public?void?setBook_type_no(String?book_type_no)?{
this.book_type_no?=?book_type_no;
}
public?String?getBook_details()?{
return?book_details;
}
public?void?setBook_details(String?book_details)?{
this.book_details?=?book_details;
}
public?String?getPicture()?{
return?picture;
}
public?void?setPicture(String?picture)?{
this.picture?=?picture;
}
}
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件???????1126??2016-11-22?16:43??數(shù)據(jù)庫(kù)\sql\createtable.sql
?????文件????????326??2016-11-12?11:24??數(shù)據(jù)庫(kù)\sql\create_stu_liibrary.sql
?????文件????????612??2016-11-12?10:05??數(shù)據(jù)庫(kù)\stu_library\.classpath
?????文件????????306??2016-11-12?09:58??數(shù)據(jù)庫(kù)\stu_library\.myme
?????文件???????1754??2016-11-13?12:49??數(shù)據(jù)庫(kù)\stu_library\.project
?????文件????????658??2016-11-12?09:58??數(shù)據(jù)庫(kù)\stu_library\.settings\.jsdtscope
?????文件???????1009??2016-11-15?20:17??數(shù)據(jù)庫(kù)\stu_library\.settings\com.genuitec.eclipse.j2eedt.core.prefs
?????文件?????????76??2016-11-19?14:21??數(shù)據(jù)庫(kù)\stu_library\.settings\org.eclipse.core.resources.prefs
?????文件????????364??2016-11-12?09:58??數(shù)據(jù)庫(kù)\stu_library\.settings\org.eclipse.jdt.core.prefs
?????文件????????471??2016-11-12?09:58??數(shù)據(jù)庫(kù)\stu_library\.settings\org.eclipse.wst.common.component
?????文件????????252??2016-11-12?09:58??數(shù)據(jù)庫(kù)\stu_library\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件?????????49??2016-11-12?09:58??數(shù)據(jù)庫(kù)\stu_library\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件??????????6??2016-11-12?09:58??數(shù)據(jù)庫(kù)\stu_library\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件???????1570??2016-11-18?16:52??數(shù)據(jù)庫(kù)\stu_library\src\com\bean\booksBean.java
?????文件????????551??2016-12-02?23:29??數(shù)據(jù)庫(kù)\stu_library\src\com\bean\Book_type.java
?????文件????????924??2016-11-30?10:59??數(shù)據(jù)庫(kù)\stu_library\src\com\bean\Borrowed_book.java
?????文件????????894??2016-11-30?11:45??數(shù)據(jù)庫(kù)\stu_library\src\com\bean\Return_book.java
?????文件???????1034??2016-11-18?16:23??數(shù)據(jù)庫(kù)\stu_library\src\com\bean\StudentsBean.java
?????文件???????2397??2016-11-29?16:52??數(shù)據(jù)庫(kù)\stu_library\src\com\db\DBUtil.java
?????文件???????9587??2016-11-30?11:48??數(shù)據(jù)庫(kù)\stu_library\src\DAO\BookDAO.java
?????文件????????818??2016-11-29?20:32??數(shù)據(jù)庫(kù)\stu_library\src\DAO\StudentDAO.java
?????文件???????1100??2016-06-06?20:12??數(shù)據(jù)庫(kù)\stu_library\src\Filter\EncodingFilter.java
?????文件???????1416??2016-12-02?23:56??數(shù)據(jù)庫(kù)\stu_library\src\servlet\doLogin.java
?????文件???????1765??2016-11-29?16:53??數(shù)據(jù)庫(kù)\stu_library\src\servlet\doRegister.java
?????文件???????1768??2016-11-29?16:52??數(shù)據(jù)庫(kù)\stu_library\src\servlet\do_add_book.java
?????文件???????1324??2016-11-29?16:52??數(shù)據(jù)庫(kù)\stu_library\src\servlet\do_add_booktype.java
?????文件???????2647??2016-11-29?16:52??數(shù)據(jù)庫(kù)\stu_library\src\servlet\do_borrow_book.java
?????文件???????1401??2016-11-29?21:30??數(shù)據(jù)庫(kù)\stu_library\src\servlet\do_modify_personMsg.java
?????文件???????2703??2016-12-02?22:33??數(shù)據(jù)庫(kù)\stu_library\src\servlet\do_return_book.java
?????文件???????1608??2016-11-29?19:35??數(shù)據(jù)庫(kù)\stu_library\src\servlet\do_update_book.java
............此處省略92個(gè)文件信息
評(píng)論
共有 條評(píng)論