JAVA mysql web 图书管理系统

web版的图书管理系统,下载之后运行 sql文件,注意数据库名称,然后参考readme文件启动项目.

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个文件信息