基于java+swring+数据库实现的图书管理系统

说明
一、角色：管理员、普通用户
二、功能划分
（1）管理员：图书查询（查询全部、按类别查询、按书名查询、按书号查询）、图书管理（新增、删除、修改）、用户查询（查询全部、按用户名查询、按学号查询）、用户管理（新增、删除）、账户管理（修改密码、退出登录）
（2）普通用户：图书查询（查询全部、按类别查询、按书名查询、按书号查询）、图书借还（借书、还书）、账户管理（修改密码、借书记录、退出登录）
三、说明：含有数据库、源码、视频、截图、数据库驱动、部分说明
四、该系统功能完善，可实现借书、还书的过程，代码简洁明了~
源码链接点击下载
创作不易，提供部分核心代码
运行截图

部分代码
UserDao

package Dao;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Arrays;
import java.util.Vector;

public class UserDao {
   
    public UserDao() {
   
    }

    // 登录
    public static void login(String user,String password) {
   
        Connection con = DB.getConnection();
        PreparedStatement preSql;
        ResultSet rs;
        String sqlStr = "select * from usertable where `name` = ? and password =?";
        try {
   
            preSql = con.prepareStatement(sqlStr);
            preSql.setString(1, user);
            preSql.setString(2, password);
            rs = preSql.executeQuery();
            boolean flag = false;
            while (rs.next()) {
   
                flag = true;
                String admin = rs.getString(5);
                System.out.println(admin);
            }
            if (!flag) {
   
                JOptionPane.showMessageDialog(null, "用户不存在", "警告", JOptionPane.WARNING_MESSAGE);
            }
            con.close();
        } catch (SQLException e) {
   
        }
    }


    //添加用户
    public static void adduser(String user,String id,String name,String password) {
   
        try {
   
            Connection con = DB.getConnection();
            //新增语句
            String sql = "INSERT into usertable(user,studentid,name,password) VALUES(?,?,?,?)";
            PreparedStatement ps = con.prepareStatement(sql);
            ps.setString(1, user);
            ps.setString(2, id);
            ps.setString(3, name);
            ps.setString(4, password);
            ps.executeUpdate();
            DB.close(null,ps,con);
        } catch (SQLException e) {
   
            e.printStackTrace();
        }
    }

    // 显示所有用户
    public static void alluser(DefaultTableModel model) {
   
        Connection con = DB.getConnection();
        PreparedStatement preSql;
        ResultSet rs;
        String sqlStr = "select * from usertable";
        try {
   
            preSql = con.prepareStatement(sqlStr);
            rs = preSql.executeQuery();
            while (rs.next()) {
   
                String user = rs.getString(1);
                String id = rs.getString(2);
                String name = rs.getString(3);
                String password = rs.getString(4);
                model.addRow(new Vector<>(Arrays.asList(user, id, name, password)));
            }
            con.close();
        } catch (SQLException e) {
   
        }}

    // 用户名按查找用户
    public static void finduser(DefaultTableModel model, String user) {
   
        Connection con = DB.getConnection();
        PreparedStatement preSql;
        ResultSet rs;
        String sqlStr = "select * from usertable where user = ?";
        try {
   
            preSql = con.prepareStatement(sqlStr);
            preSql.setString(1, user);
            rs = preSql.executeQuery();
            boolean flag = false;
            while (rs.next()) {
   
                flag = true;
                String us = rs.getString(1);
                String id = rs.getString(2);
                String name = rs.getString(3);
                String password = rs.getString(4);
                model.addRow(new Vector<>(Arrays.asList(us, id, name, password)));
            }
            if (!flag) {
   
                JOptionPane.showMessageDialog(null, "用户不存在", "警告", JOptionPane.WARNING_MESSAGE);
            }
            con.close();
        } catch (SQLException e) {
   
        }
    }
    // 学号按查找用户
    public static void finduserid(DefaultTableModel model, String user) {
   
        Connection con = DB.getConnection();
        PreparedStatement preSql;
        ResultSet rs;
        String sqlStr = "select * from usertable where studentid = ?";
        try {
   
            preSql = con.prepareStatement(sqlStr);
            preSql.setString(1, user);
            rs = preSql.executeQuery();
            boolean flag = false;
            while (rs.next()) {
   
                flag = true;
                String us = rs.getString(1);
                String id = rs.getString(2);
                String name = rs.getString(3);
                String password = rs.getString(4);
                model.addRow(new Vector<>(Arrays.asList(us, id, name, password)));
            }
            if (!flag) {
   
                JOptionPane.showMessageDialog(null, "用户不存在", "警告", JOptionPane.WARNING_MESSAGE);
            }
            con.close();
        } catch (SQLException e) {
   
        }
    }
    //删除用户
    public static void deleteuser(