資源簡介
java大作業,附源碼,sqlserver數據庫,報告一條龍服務,包你滿意
管理員模塊功能介紹
1.查詢圖書
2.借閱圖書
3.歸還圖書
4.刪除圖書
5.添加圖書
6.刪除用戶
7.查詢用戶
用戶模塊功能介紹
1.查詢圖書
2.借閱圖書
3.歸還圖書
4.注冊

代碼片段和文件信息
package?com.java.dao;
/**
?*?管理員登錄驗證
?*?
?*/
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?com.java.model.Admin;
public?class?AdminDao{
public?Admin?login(Connection?conAdmin?admin)?throws?Exception{//登錄查找信息
Admin?resultUser?=?null;
String?sql?=?“select?*?from?admin?where?admin_name=??and?admin_password=?“;
PreparedStatement?pstmt?=?(PreparedStatement)con.prepareStatement(sql);
pstmt.setString(1admin.getAdmin_name());//將指定參數設置為給定?Java?String?值
pstmt.setString(2admin.getAdmin_password());
ResultSet?rs?=?pstmt.executeQuery();//在此?PreparedStatement?對象中執行?SQL?查詢,并返回該查詢生成的?ResultSet?對象。
if(rs.next())?{
resultUser?=?new?Admin();
resultUser.setAdmin_id(rs.getInt(“admin_id“));
resultUser.setAdmin_name(rs.getString(“admin_name“));
resultUser.setAdmin_phone(rs.getString(“admin_phone“));
resultUser.setAdmin_password(rs.getString(“admin_password“));
}
return?resultUser;?
}
}
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-06-20?12:25??圖書\
?????文件????????9002??2020-06-20?12:25??圖書\book.sql
?????目錄???????????0??2020-06-20?12:23??圖書\book源碼\
?????文件?????????402??2020-06-19?19:10??圖書\book源碼\.classpath
?????文件?????????381??2020-06-13?11:02??圖書\book源碼\.project
?????目錄???????????0??2020-06-20?12:23??圖書\book源碼\.settings\
?????文件??????????79??2020-06-19?20:11??圖書\book源碼\.settings\org.eclipse.core.resources.prefs
?????文件?????????598??2020-02-11?13:35??圖書\book源碼\.settings\org.eclipse.jdt.core.prefs
?????目錄???????????0??2020-06-20?12:23??圖書\book源碼\bin\
?????目錄???????????0??2020-06-20?12:23??圖書\book源碼\bin\com\
?????目錄???????????0??2020-06-20?12:23??圖書\book源碼\bin\com\java\
?????目錄???????????0??2020-06-20?12:23??圖書\book源碼\bin\com\java\dao\
?????文件????????1697??2020-06-19?19:10??圖書\book源碼\bin\com\java\dao\AdminDao.class
?????文件????????2976??2020-06-20?08:59??圖書\book源碼\bin\com\java\dao\BookDao.class
?????文件????????2011??2020-06-19?19:10??圖書\book源碼\bin\com\java\dao\BookInformationDao.class
?????文件?????????521??2020-06-19?19:10??圖書\book源碼\bin\com\java\dao\Main.class
?????文件????????2623??2020-06-20?08:59??圖書\book源碼\bin\com\java\dao\UserDao.class
?????目錄???????????0??2020-06-20?12:23??圖書\book源碼\bin\com\java\fr
?????文件?????????732??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件????????6768??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件?????????862??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件?????????862??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件?????????857??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件?????????745??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件?????????862??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件?????????749??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件?????????748??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件????????4931??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
?????文件????????1117??2020-06-20?09:38??圖書\book源碼\bin\com\java\fr
?????文件????????5522??2020-06-20?09:38??圖書\book源碼\bin\com\java\fr
?????文件????????1130??2020-06-19?19:10??圖書\book源碼\bin\com\java\fr
............此處省略110個文件信息
- 上一篇:sonarqube-sonar
- 下一篇:基于JSP開發的論壇系統
評論
共有 條評論