JavaWeb期末大作业——图书管理系统
目录
一、系统介绍
1.开发的环境
开发工具：eclipse 2022
JDK版本：1.8
数据库：MySQL 5.5
数据库管理软件：Navicat 15.0.27
服务器：apach-tomcat-9.0.68
2.本系统实现的功能
管理员功能：登陆系统、用户信息的增删改查、图书的增删改查、图书分类的增删改查、图书日志查询、图书归还。
用户功能：登陆系统、查阅图书、借阅和归还图书、查询借阅记录
3.数据库用到的表
admin、book、booktype、history
4.工程截图
二、系统展示
1.登录页面
2.注册页面
3.管理员主页面
4. 用户主页面
5.图书管理页面（管理员）
6.读者管理页面（管理员）
7.图书分类管理页面（管理员）
8.图书借阅管理页面（管理员）
9.图书归还信息页面（管理员）
10.图书日志查询（管理员）
11. 图书借阅页面（用户）
12.还书页面（用户）
13.借阅历史页面（用户）
三、部分代码展示
AdminDao.java
package com.hry.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import com.hry.bean.AdminBean;
import com.hry.dbUtils.DbUtil;
public class AdminDao {
/**
* 登录验证功能，传入用户名和密码，在数据库中查找，如果找到了，返回true，没找到则返回false
* username、password
*/
public boolean Login_verify(String username,String password){
//连接数据库
DbUtil dbUtil=new DbUtil();
Connection conn = dbUtil.getConn();
//sql语句
String sql = "select * from admin where username='"+username+"' and password='"+password+"'";
PreparedStatement stm = null;
ResultSet rs = null;
try {
//预编译SQL，减少sql执行
stm = conn.prepareStatement(sql);
rs = stm.executeQuery();
if(rs.next()){
return true;
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally {
DbUtil.CloseDB(rs, stm, conn);
}
return false;
}
/**
* 注册账号的函数，传入账号，密码，姓名，邮箱，手机号，借阅天数，可借阅数
* username, password, name, email, phone, lend_num, max_num
*/
public void Register(String username, String password, String name, String email, String phone,int lend_num,int max_num) {
// TODO Auto-generated method stub
//连接数据库
DbUtil dbUtil=new DbUtil();
Connection conn = dbUtil.getConn();
//sql语句
String sql = "insert into admin(status,username,password,name,email,phone,lend_num,max_num) values(?,?,?,?,?,?,?,?)";
int rs = 0;
PreparedStatement stm = null;
try {
//预编译SQL，减少sql执行
stm = conn.prepareStatement(sql);
//传参
stm.setInt(1, 1);
stm.setString(2, username);
stm.setString(3, password);
stm.setString(4, name);
stm.setString(5, email);
stm.setString(6, phone);
stm.setInt(7, lend_num);//借阅天数
stm.setInt(8, max_num);//可借阅数
//执行更新
rs = stm.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* 根据传入的账号，密码，来查找对应的读者信息，返回一个AdminBean类型，
*
*/
public AdminBean getAdminInfo(String username, String password) {
// TODO Auto-generated method stub
AdminBean adminbean = new AdminBean();
DbUtil dbUtil=new DbUtil();
Connection conn = dbUtil.getConn();
String sql = "select * from admin where username='"+username+"' and password='"+password+"'";
PreparedStatement stm = null;
ResultSet rs = null;
try {
//预编译SQL，减少sql执行
stm = conn.prepareStatement(sql);
//执行查询
rs = stm.executeQuery();
if(rs.next()){
//传参
adminbean.setAid(rs.getInt("aid"));
adminbean.setUsername(rs.getString("username"));
adminbean.setName(rs.getString("name"));
adminbean.setPassword(rs.getString("password"));
adminbean.setEmail(rs.getString("email"));
adminbean.setPhone(rs.getString("phone"));
adminbean.setStatus(rs.getInt("status"));
adminbean.setLend_num(rs.getInt("lend_num"));
adminbean.setMax_num(rs.getInt("max_num"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally {
DbUtil.CloseDB(rs, stm, conn);
}
return adminbean;
}
/**
* 获取全部用户的信息，其中sql语句中的status=1，表示只查找读者(1)，不显示管理员(2)的
*
*/
public ArrayList<AdminBean> get_ListInfo(){
ArrayList<AdminBean> tag_Array = new ArrayList<AdminBean>();
Connection conn = DbUtil.getConn();
String sql = "select * from admin where status=1";
PreparedStatement stm = null;
ResultSet rs = null;
try {
stm = conn.prepareStatement(sql);
rs = stm.executeQuery();
while(rs.next()){
AdminBean adminbean = new AdminBean();
adminbean.setAid(rs.getInt("aid"));
adminbean.setUsername(rs.getString("username"));
adminbean.setName(rs.getString("name"));
adminbean.setPassword(rs.getString("password"));
adminbean.setEmail(rs.getString("email"));
adminbean.setPhone(rs.getString("phone"));
adminbean.setStatus(rs.getInt("status"));
adminbean.setLend_num(rs.getInt("lend_num"));
adminbean.setMax_num(rs.getInt("max_num"));
tag_Array.add(adminbean);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally {
DbUtil.CloseDB(rs, stm, conn);
}
return tag_Array;
}
/**
* 根据传入的aid图书号，查找到对应的读者的全部信息，返回一个AdminBean类型的数据，与上一个相似，只是aid的类型为String，
*
*/
public AdminBean get_AidInfo2(String aid){
AdminBean adminbean = new AdminBean();
DbUtil dbUtil=new DbUtil();
Connection conn = dbUtil.getConn();
String sql = "select * from admin where aid="+aid;
PreparedStatement stm = null;
ResultSet rs = null;
try {
stm = conn.prepareStatement(sql);
rs = stm.executeQuery();
if(rs.next()){
adminbean.setAid(rs.getInt("aid"));
adminbean.setUsername(rs.getString("username"));
adminbean.setName(rs.getString("name"));
adminbean.setPassword(rs.getString("password"));
adminbean.setEmail(rs.getString("email"));
adminbean.setPhone(rs.getString("phone"));
adminbean.setStatus(rs.getInt("status"));
adminbean.setLend_num(rs.getInt("lend_num"));
adminbean.setMax_num(rs.getInt("max_num"));
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally {
DbUtil.CloseDB(rs, stm, conn);
}
return adminbean;
}
/**
* 修改读者的信息
*/
public void updateUser(int aid, String username, String password, String name, String email, String phone,
int lend_num, int max_num) {
// TODO Auto-generated method stub
DbUtil dbUtil=new DbUtil();
Connection conn = dbUtil.getConn();
String sql = "update admin set username=?,name=?,email=?,phone=?,password=?,lend_num=?,max_num=? where aid=?";
PreparedStatement stm = null;
try {
stm = conn.prepareStatement(sql);
stm.setString(1, username);
stm.setString(2, name);
stm.setString(3, email);
stm.setString(4, phone);
stm.setString(5, password);
stm.setInt(6, lend_num);
stm.setInt(7, max_num);
stm.setInt(8, aid);
stm.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
/**
* 删除用户的信息，根据传入的aid作为条件
*
*/
public void deleteUser(int aid) {
// TODO Auto-generated method stub
DbUtil dbUtil=new DbUtil();
Connection conn = dbUtil.getConn();
String sql = "delete from admin where aid=?";
PreparedStatement stm = null;
try {
stm = conn.prepareStatement(sql);
stm.setInt(1, aid);
stm.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
LoginServlet.java
package com.hry.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.hry.bean.AdminBean;
import com.hry.dao.AdminDao;
/**
* Servlet implementation class LoginServlet
*/
@WebServlet("/LoginServlet")
public class LoginServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
AdminDao userdao = new AdminDao();
AdminDao admindao = new AdminDao();
/**
* @see HttpServlet#HttpServlet()
*/
public LoginServlet() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//登录的判断
//编码格式
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
//获取账号和密码
// PrintWriter out = response.getWriter();
String username = request.getParameter("username");
String password = request.getParameter("password");
System.out.println(username);
//对账号和密码进行判断
boolean result = userdao.Login_verify(username, password);
System.out.println(result);
HttpSession session = request.getSession();
//判断输入正确
if(result){
AdminBean adminbean = new AdminBean();
//更加账号和密码查找出读者的信息
adminbean = admindao.getAdminInfo(username,password);
//将aid存入session中
session.setAttribute("aid", ""+adminbean.getAid());
//设置session的失效时间
session.setMaxInactiveInterval(6000);
//根据status的值来判断是管理员，还是读者，status=1为读者
System.out.println(adminbean.getStatus());
if(adminbean.getStatus()==1){
response.sendRedirect("index2.jsp");
}else{
response.sendRedirect("admin.jsp");
}
}else{
//没有找到对应的账号和密码，返回重新登录
session.setAttribute("state", "密码错误");
response.sendRedirect("login.jsp");
}
}
}
RegisterServlet.java
package com.hry.servlet;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.hry.bean.AdminBean;
import com.hry.dao.AdminDao;
/**
* Servlet implementation class RegisterServlet
*/
@WebServlet("/RegisterServlet")
public class RegisterServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public RegisterServlet() {
super();
// TODO Auto-generated constructor stub
}
/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
// doGet(request, response);
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
//获取注册信息
AdminDao userdao = new AdminDao();
String username = request.getParameter("username");
String password = request.getParameter("password");
String name = request.getParameter("name");
String email = request.getParameter("email");
String phone = request.getParameter("phone");
System.out.println(username);
//默认设置最大借阅数和借阅天数
int lend_num = 30;
int max_num = 5;
//将注册信息存入数据库，再返回登录
userdao.Register(username,password,name,email,phone,lend_num,max_num);
response.sendRedirect("login.jsp");
}
}
BookBean.java
package com.hry.bean;
public class BookBean {
/**
* 图书的数据表的bean
*/
private int bid;//图书id
private String name;//图书名称
private String card;//图书号
private String autho;//作者
private int num;//图书数量
private String type;//图书的分类
private String press;//出版社
public int getBid() {
return bid;
}
public void setBid(int bid) {
this.bid = bid;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getCard() {
return card;
}
public void setCard(String card) {
this.card = card;
}
public String getAutho() {
return autho;
}
public void setAutho(String autho) {
this.autho = autho;
}
public int getNum() {
return num;
}
public void setNum(int num) {
this.num = num;
}
public String getType() {
return type;
}
public void setType(String type) {
this.type = type;
}
public String getPress() {
return press;
}
public void setPress(String press) {
this.press = press;
}
}
AdminServlet.java
package com.hry.servlet;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import com.hry.bean.AdminBean;
import com.hry.dao.AdminDao;
import com.hry.dao.BookDao;
/**
* Servlet implementation class AdminServlet
*/
@WebServlet("/AdminServlet")
public class AdminServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public AdminServlet() {
super();
// TODO Auto-generated constructor stub
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//PrintWriter:输出流，为异常处理
PrintWriter out = response.getWriter();
//设置编码类型
request.setCharacterEncoding("UTF-8");
response.setContentType("text/html;charset=UTF-8");
BookDao bookdao = new BookDao();
//这里为了简单，设置了tip，用来区分是修改密码功能，还是修改个人资料的功能，tip=1为修改密码
int tip = Integer.parseInt(request.getParameter("tip"));
//获取发起请求页面的文件名称，这个在对应的jsp里面的表单填写，修改完成后就可以直接返回对应的页面
String url = request.getParameter("url");
System.out.println(url);
HttpSession session = request.getSession();
AdminBean adminbean = new AdminBean();
//获取存到session的aid
String aid = (String) session.getAttribute("aid");
AdminDao admindao = new AdminDao();
//通过aid获取到读者的信息
adminbean = admindao.get_AidInfo2(aid);
//修改密码
if (tip==1) {
//获取到输入的旧密码，新密码
String password = request.getParameter("password");
String password2 = request.getParameter("password2");
//获取读者数据表中的密码
String old_password = adminbean.getPassword();
//对旧密码进行比较，如果相同就修改，不相同就直接退出
if(old_password.equals(password)){
admindao.updateUser(adminbean.getAid(), adminbean.getUsername(), password2, adminbean.getName(),
adminbean.getEmail(), adminbean.getPhone(), adminbean.getLend_num(), adminbean.getMax_num());
response.sendRedirect(url+".jsp");
}else{
out.write("<script type='text/javascript'>alert('password error');location.href='"+url+".jsp'; </script>");
}
} else {
//修改个人资料
//获取输入的信息
String name = request.getParameter("name");
String email = request.getParameter("email");
String phone = request.getParameter("phone");
//修改输入的信息到数据表中
admindao.updateUser(adminbean.getAid(), adminbean.getUsername(), adminbean.getPassword(), name,
email, phone, adminbean.getLend_num(), adminbean.getMax_num());
response.sendRedirect(url+".jsp");
}
}
}
四、源码
点击以下链接（内含数据库文件——books.sql）：
链接：https://pan.baidu.com/s/1HN8CY281ctJWjSkynUgxag?pwd=5ugw
提取码：5ugw
五、备注
该项目是基于一位GitHub上的大佬的项目模板写的，我在上课时按照老师的要求给原项目增加和优化了一些功能，最后变成了现在这个样子。由于当时在GitHub参考了很多的项目，导致我现在已经不记得那位大佬的用户名了，只能说是非常抱歉了。
如有侵权，请联系我删除。
六、祝福
路虽远行则可至，未来一定可期！祝您生活愉快、工作顺心、学业有成！
本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
THE END
二维码