package?com.book.dao;

import?org.springframework.beans.factory.annotation.Autowired;
import?org.springframework.jdbc.core.JdbcTemplate;
import?org.springframework.stereotype.Repository;

@Repository
public?class?AdminDao?{

????private?JdbcTemplate?jdbcTemplate;

????@Autowired
????public?void?setJdbcTemplate（JdbcTemplate?jdbcTemplate）?{
????????this.jdbcTemplate?=?jdbcTemplate;
????}


????private?static?final?String?MATCH_ADMIN_SQL=“SELECT?COUNT（*）?FROM?admin?where?admin_id?=???and?password?=???“;
????private?static?final?String?RE_PASSWORD_SQL=“UPDATE?admin?set?password?=???where?admin_id?=???“;
????private?static?final?String?GET_PASSWD_SQL=“SELECT?password?from?admin?where?admin_id?=??“;

????public?int?getMatchCount（int?adminIdString?password）{
????????return?jdbcTemplate.queryForobject（MATCH_ADMIN_SQLnew?object[]{adminIdpassword}Integer.class）;
????}

????public?int?rePassword（int?adminIdString?newPasswd）{
????????return?jdbcTemplate.update（RE_PASSWORD_SQLnew?object[]{newPasswdadminId}）;
????}
????public?String?getPasswd（int?id）{
????????return?jdbcTemplate.queryForobject（GET_PASSWD_SQLnew?object[]{id}String.class）;
????}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????.......????????12??2018-06-13?01:09??Books-Management-System-master\.gitignore

?????文件??????????4??2018-10-11?10:32??Books-Management-System-master\.idea\.name

?????文件????????291??2018-10-11?10:33??Books-Management-System-master\.idea\artifacts\book_war.xml

?????文件???????2881??2018-10-11?10:33??Books-Management-System-master\.idea\artifacts\book_war_exploded.xml

?????文件???????1184??2018-10-11?10:33??Books-Management-System-master\.idea\compiler.xml

?????文件?????????76??2018-10-11?10:31??Books-Management-System-master\.idea\copyright\profiles_settings.xml

?????文件????????215??2018-10-11?10:33??Books-Management-System-master\.idea\encodings.xml

?????文件????????241??2018-10-11?10:32??Books-Management-System-master\.idea\inspectionProfiles\profiles_settings.xml

?????文件???????1601??2018-10-11?10:32??Books-Management-System-master\.idea\inspectionProfiles\Project_Default.xml

?????文件????????538??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__aopalliance_aopalliance_1_0.xml

?????文件????????549??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__commons_dbcp_commons_dbcp_1_4.xml

?????文件????????582??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__commons_logging_commons_logging_1_2.xml

?????文件????????563??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__commons_pool_commons_pool_1_5_4.xml

?????文件????????530??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__com_beust_jcommander_1_27.xml

?????文件????????668??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__com_fasterxml_jackson_core_jackson_annotations_2_8_8.xml

?????文件????????619??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__com_fasterxml_jackson_core_jackson_core_2_8_8.xml

?????文件????????647??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__com_fasterxml_jackson_core_jackson_databind_2_8_8.xml

?????文件????????497??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__javax_servlet_jstl_1_2.xml

?????文件????????602??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__javax_servlet_servlet_api_3_0_alpha_1.xml

?????文件????????479??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__junit_junit_4_10.xml

?????文件????????598??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__mysql_mysql_connector_java_5_1_29.xml

?????文件????????566??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_aspectj_aspectjweaver_1_8_1.xml

?????文件????????504??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_beanshell_bsh_2_0b4.xml

?????文件????????556??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_hamcrest_hamcrest_core_1_1.xml

?????文件????????633??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_springframework_spring_aop_4_2_2_RELEASE.xml

?????文件????????647??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_springframework_spring_beans_4_2_2_RELEASE.xml

?????文件????????661??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_springframework_spring_context_4_2_2_RELEASE.xml

?????文件????????717??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_springframework_spring_context_support_4_2_2_RELEASE.xml

?????文件????????640??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_springframework_spring_core_4_2_2_RELEASE.xml

?????文件????????682??2018-10-11?10:38??Books-Management-System-master\.idea\libraries\Maven__org_springframework_spring_expression_4_2_2_RELEASE.xml

............此處省略160個文件信息