jsp实现图书管理系统源码（附mysql数据库脚本）

java实现图书管理系统 源码

登陆账号：20170001 密码 111111

调试步骤：

1.在mysql 创建 library数据库

2.执行 library.sql脚本

3.修改如下数据库连接串为你本机信息 即可

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.queryForO

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       8196  2018-05-21 14:42  Books-Management-System\.DS_Store

     文件        287  2018-05-20 21:02  Books-Management-System\.git\config

     文件         73  2018-05-20 21:02  Books-Management-System\.git\description

     文件         23  2018-05-20 21:02  Books-Management-System\.git\HEAD

     文件        478  2018-05-20 21:02  Books-Management-System\.git\hooks\applypatch-msg.sample

     文件        896  2018-05-20 21:02  Books-Management-System\.git\hooks\commit-msg.sample

     文件        189  2018-05-20 21:02  Books-Management-System\.git\hooks\post-update.sample

     文件        424  2018-05-20 21:02  Books-Management-System\.git\hooks\pre-applypatch.sample

     文件       1642  2018-05-20 21:02  Books-Management-System\.git\hooks\pre-commit.sample

     文件       1348  2018-05-20 21:02  Books-Management-System\.git\hooks\pre-push.sample

     文件       4898  2018-05-20 21:02  Books-Management-System\.git\hooks\pre-rebase.sample

     文件       1239  2018-05-20 21:02  Books-Management-System\.git\hooks\prepare-commit-msg.sample

     文件       3610  2018-05-20 21:02  Books-Management-System\.git\hooks\update.sample

     文件       7450  2018-05-21 15:22  Books-Management-System\.git\index

     文件        240  2018-05-20 21:02  Books-Management-System\.git\info\exclude

     文件        202  2018-05-20 21:02  Books-Management-System\.git\logs\HEAD

     文件        202  2018-05-20 21:02  Books-Management-System\.git\logs\refs\heads\master

     文件        202  2018-05-20 21:02  Books-Management-System\.git\logs\refs\remotes\origin\HEAD

     文件         46  2018-05-20 21:02  Books-Management-System\.git\objects\00\9e48c7e761e575cd942260168e1f73145cf3f6

     文件        148  2018-05-20 21:02  Books-Management-System\.git\objects\02\d76080ab11f55e8a1a86fb24eeb6311c34380d

     文件       1355  2018-05-20 21:02  Books-Management-System\.git\objects\03\0a47528f89385242678925767ed4e740647653

     文件        322  2018-05-20 21:02  Books-Management-System\.git\objects\07\3e91d066530ddb6e0f0aa53a6ce8b2f269b54c

     文件        552  2018-05-20 21:02  Books-Management-System\.git\objects\07\bbe480bf5dfe40a97ba7e1ac346a93e8267b73

     文件        745  2018-05-20 21:02  Books-Management-System\.git\objects\08\4a7e72b1b90783994c37c489f287b3d6db8c9f

     文件        253  2018-05-20 21:02  Books-Management-System\.git\objects\0a\33e3d87ebe2f69e0f15e87ff363d29a6767fb6

     文件        997  2018-05-20 21:02  Books-Management-System\.git\objects\0c\39f9fee46133ca0f136750ad5a0e8a3375f6c0

     文件     340882  2018-05-20 21:02  Books-Management-System\.git\objects\0d\15c1b58f8f2add63401098c7459d61604560d0

     文件        181  2018-05-20 21:02  Books-Management-System\.git\objects\18\61cdc0339e9b02dc6386def3f65372af16d04b

     文件     914265  2018-05-20 21:02  Books-Management-System\.git\objects\19\b45ea9a8a95da7679a5b7aa22047e4b04bd7d2

     文件       2058  2018-05-20 21:02  Books-Management-System\.git\objects\1e\f0d30cbc74eef8cd804dc140146fedb4b14895

............此处省略462个文件信息