資源簡介
對圖書增刪改查,增加管理員、讀者,借書還書功能。
代碼片段和文件信息
package?com.Dao;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?com.DB.DBfile;
import?com.DB.testsql;
/**???
*????
*?項目名稱:library???
*?類名稱:bookDao???
*?類描述:???書本數據導入
*?創建人:?
*?創建時間:2015-6-10?下午10:10:16???
*?修改人:?
*?修改時間:2015-6-10?下午10:10:16???
*?修改備注:???
*?@version????
*????
*/
public?class?bookDao?{
private?DBfile?db?=?new?DBfile();
private?testsql?test?=?new?testsql();
/**
?*?@return?所有圖書
?*?顯示所有圖書
?*/
public?ResultSet?getAllBook1()?{
String?sql?=?“select?*?from?book“;
ResultSet?rs?=?test.executeQuery(sql);
return?rs;
}
/**
?*?@return?沒有借出的書
?*?顯示沒有借出的圖書
?*/
public?ResultSet?getNotBorrow()?{
String?sql?=?“select?*?from?bookborrow?where?book.ISBN=borrow.ISBN?and?isBorrow=0“;
ResultSet?rs?=?db.execut
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2015-06-24?17:56??library\
?????文件?????????529??2015-06-04?20:00??library\.classpath
?????目錄???????????0??2015-06-04?20:00??library\.myeclipse\
?????文件?????????294??2015-06-04?20:00??library\.myme
?????文件????????1750??2015-06-04?20:59??library\.project
?????目錄???????????0??2015-06-24?17:56??library\.settings\
?????文件?????????500??2015-06-04?20:00??library\.settings\.jsdtscope
?????文件?????????364??2015-06-04?20:00??library\.settings\org.eclipse.jdt.core.prefs
?????文件?????????459??2015-06-04?20:00??library\.settings\org.eclipse.wst.common.component
?????文件?????????252??2015-06-04?20:00??library\.settings\org.eclipse.wst.common.project.facet.core.xm
?????文件??????????49??2015-06-04?20:00??library\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2015-06-04?20:00??library\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2015-06-24?17:56??library\src\
?????目錄???????????0??2015-06-24?17:56??library\src\com\
?????目錄???????????0??2015-06-24?17:58??library\src\com\Dao\
?????文件????????3918??2015-06-24?17:58??library\src\com\Dao\bookDao.java
?????文件????????2506??2015-06-24?17:57??library\src\com\Dao\useDao.java
?????目錄???????????0??2015-06-24?17:57??library\src\com\DB\
?????文件????????1880??2015-06-24?17:57??library\src\com\DB\DBfile.java
?????文件????????1815??2015-06-22?01:02??library\src\com\DB\testsql.java
?????目錄???????????0??2015-06-24?17:56??library\WebRoot\
?????文件????????3724??2015-06-24?11:41??library\WebRoot\addAdmin.jsp
?????文件????????5343??2015-06-24?11:52??library\WebRoot\addBook.jsp
?????文件????????4020??2015-06-24?11:44??library\WebRoot\borrow.jsp
?????文件????????3238??2015-06-24?11:51??library\WebRoot\changeBook.jsp
?????文件????????3241??2015-06-24?11:41??library\WebRoot\changePsw.jsp
?????目錄???????????0??2015-06-24?17:56??library\WebRoot\css\
?????文件????????1654??2015-06-06?01:17??library\WebRoot\css\admin.css
?????文件??????113226??2015-06-18?23:04??library\WebRoot\css\pintuer.css
?????文件?????????493??2015-06-22?23:02??library\WebRoot\deleteSuccess.jsp
?????目錄???????????0??2015-06-24?17:56??library\WebRoot\images\
............此處省略31個文件信息
評論
共有 條評論