package?Dao;

import?Model.admin;
import?Tools.JdbcUtil;
import?org.apache.commons.dbutils.QueryRunner;
import?org.apache.commons.dbutils.handlers.BeanHandler;
import?org.apache.commons.dbutils.handlers.BeanListHandler;
import?org.apache.commons.dbutils.handlers.ScalarHandler;

import?java.sql.SQLException;
import?java.util.List;

public?class?adminDao?{
????private?QueryRunner?runner?=?new?QueryRunner（JdbcUtil.getDataSource（））;
????private?admin?user=null;
????public?admin?searchAdminByuname（admin?u）?throws?Exception?{
????????String?sql=“select?*?from?admin?where?uname=??and?password=??and?type=?“;
????????user?=?runner.query（sql?new?BeanHandler（admin.class）?u.getUname（）?u.getPassword（）u.getType（））;
????????return?user;
????}
????public?admin?searchAdminByemail（admin?u）?throws?Exception?{
????????String?sql=“select?*?from?admin?where?email=??and?password=??and?type=?“;
????????user?=?runner.query（sql?new?BeanHandler（admin.class）?u.getEmail（）?u.getPassword（）u.getType（））;
????????return?user;
????}
????public?void?addAdmin（admin?u）?throws?SQLException?{
????????String?sql=“insert?into?admin（unamepasswordemailtype）?values（????）“;
????????runner.update（sql?u.getUname（）?u.getPassword（）?u.getEmail（）?u.getType（））;
????}
????//根據角標和特定數量要求查詢所有普通用戶
????public?List?SearchAllUser（int?indexint?count）?throws?SQLException?{
????????String?sql=“select?*?from?admin?where?type=0?order?by?id?desc?limit???“;
????????return?runner.query（sqlnew?BeanListHandler（admin.class）indexcount）;
????}
????//查詢普通用戶數量
????public?long?UserCount（）?throws?SQLException?{
????????String?sql=“select?count（*）?from?admin?where?type=0“;
????????long?count?=（long）runner.query（sqlnew?ScalarHandler（））;
????????return?count;
????}
????public?admin?searchByuname（String?uname）?throws?SQLException?{
????????String?sql=“select?*?from?admin?where?uname=??and?type=0“;
????????user?=?runner.query（sql?new?BeanHandler（admin.class）uname）;
????????return?user;
????}

????//根據Id更新用戶的狀態
????public?void?UpdateType（int?id）?throws?SQLException?{
????????String?sql=“update?admin?set?type=1?where?id=?“;
????????runner.update（sqlid）;
????}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-24?20:36??.idea\
?????目錄???????????0??2018-11-08?23:39??.idea\artifacts\
?????文件????????1164??2018-11-08?23:39??.idea\artifacts\BookManagement_war.xml
?????文件?????????578??2018-09-27?16:34??.idea\artifacts\BookManagement_war_exploded.xml
?????文件?????????254??2018-09-26?19:59??.idea\compiler.xml
?????目錄???????????0??2018-10-23?17:24??.idea\dictionaries\
?????文件??????????85??2018-09-29?01:26??.idea\dictionaries\asus.xml
?????文件?????????683??2018-12-02?16:41??.idea\encodings.xml
?????目錄???????????0??2018-10-23?17:25??.idea\libraries\
?????文件?????????256??2018-09-27?23:46??.idea\libraries\commons_beanutils_1_8_3.xml
?????文件?????????248??2018-09-27?23:46??.idea\libraries\commons_dbutils_1_4.xml
?????文件?????????252??2018-09-27?23:46??.idea\libraries\commons_logging_1_1_1.xml
?????文件?????????234??2018-09-27?23:46??.idea\libraries\druid_1_0_15.xml
?????文件?????????218??2018-09-27?21:13??.idea\libraries\jstl.xml
?????文件?????????286??2018-09-26?20:26??.idea\libraries\lib.xml
?????文件?????????222??2018-09-27?23:46??.idea\libraries\lombok.xml
?????文件?????????272??2018-09-27?23:46??.idea\libraries\mysql_connector_java_5_1_40_bin.xml
?????文件?????????226??2018-09-27?21:13??.idea\libraries\standard.xml
?????文件?????????278??2018-09-26?19:56??.idea\misc.xml
?????文件?????????275??2018-09-26?19:56??.idea\modules.xml
?????文件????????8915??2018-09-29?16:34??.idea\uiDesigner.xml
?????文件???????49263??2019-01-24?20:36??.idea\workspace.xml
?????文件????????2800??2019-01-24?20:35??BookManagement.iml
?????目錄???????????0??2018-09-26?20:19??out\
?????目錄???????????0??2018-11-08?23:35??out\artifacts\
?????目錄???????????0??2018-11-08?23:39??out\artifacts\BookManagement_war\
?????目錄???????????0??2018-10-23?17:25??out\artifacts\BookManagement_war_exploded\
?????文件????????4048??2019-01-24?20:35??out\artifacts\BookManagement_war_exploded\add_book.jsp
?????文件????????4505??2019-01-24?20:35??out\artifacts\BookManagement_war_exploded\admin_book.jsp
?????文件????????2087??2019-01-24?20:35??out\artifacts\BookManagement_war_exploded\admin_index.jsp
?????文件????????4241??2019-01-24?20:35??out\artifacts\BookManagement_war_exploded\admin_records.jsp
............此處省略207個文件信息