图书管理系统(BMS) 1.0.0

BookManagementSystem.java

package cn.cleverer;

import cn.cleverer.tablemodel.*;
import cn.cleverer.model.*;
import cn.cleverer.service.*;
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;

public class BookManagementSystem {
    // 框架
    private JFrame frame;
    private JLabel imageLabel;
    private ImageIcon background;
    private JPanel imagePanel;
    // 顶部
    private JPanel headPanel = new JPanel();
    private JButton button_0;
    private JButton button_1;
    private JButton button_2;
    private JButton button_3;
    private JButton button_4;
    private JLabel adminLabel;
    // 主页
    private JPanel homePanel = new JPanel();
    private int homePanelVis = 0;
    private JTextField textField;
    // 搜索后显示图书页面
    private JTable searchTable = new JTable();
    private JScrollPane searchScrollPane = new JScrollPane();
    private int searchTableVis = 0;
    private BookTable bookTable;
    private SearchBookTable searchBookTable;
    // 预览页面
    private JTable previewTable = new JTable();
    private JScrollPane previewScrollPane = new JScrollPane();
    private int previewTableVis = 0;
    // 归还界面
    private JPanel returnBookPanel = new JPanel();
    private int returnBookPanelVis = 0;
    // 登录页面
    private JPanel loginPanel = new JPanel();
    private int loginPanelVis = 0;
    // 注册界面
    private JPanel registerPanel = new JPanel();
    private int registerPanelVis = 0;
    // 借阅
    private JPopupMenu borrowPopup;

    // 以下为管理界面--------------------------------------------------------------------------------
    // 管理
    private JPopupMenu adminPopup;
    JMenuItem updateAdmin;
    // 显示借阅信息
    private BorrowBookTable borrowBookTable;
    private JTable borrowTable = new JTable();
    private JScrollPane borrowScrollPane = new JScrollPane();
    private int borrowTableVis = 0;
    // 显示读者信息
    private ReaderTable readerTable;
    private JTable allReaderTable = new JTable();
    private JScrollPane allReaderScrollPane = new JScrollPane();
    private int allReaderTableVis = 0;
    private JPopupMenu readerPopup;
    // 添加图书界面
    private JPanel insertBookPanel = new JPanel();
    private int insertBookPanelVis = 0;
    // 删除图书界面
    private JPanel deleteBookPanel = new JPanel();
    private int deleteBookPanelVis = 0;
    // 更新管理员界面
    private JPanel updateAdminPanel = new JPanel();
    private int updateAdminPanelVis = 0;

    public static void main(String[] args) {
        BookManagementSystem window = new BookManagementSystem();
        window.frame.setVisible(true);
    }

    public BookManagementSystem() {
        frame = new JFrame();
        frame.setTitle("图书管理系统");
        frame.setResizable(false);
        frame.setSize(1280, 720);
        frame.setLocationRelativeTo(null);
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.getContentPane().setLayout(null);

        background = new ImageIcon("background.jpg");
        imageLabel = new JLabel(background);
        imageLabel.setBounds(0, 0, 1280, 720);
        imagePanel = (JPanel) frame.getContentPane();
        imagePanel.setOpaque(false);
        // 把背景图片添加到分层窗格的最底层作为背景
        frame.getLayeredPane().add(imageLabel, new Integer(Integer.MIN_VALUE));

        // 每次启动系统，重新计算是否超期
        BorrowService.refreshBorrow();
        // 显示顶部
        showHead();
        // 显示主业
        showHome();
    }

    // 隐藏所有面板
    private void hideAll() {
        homePanel.setVisible(false);
        searchTable.setVisible(false);
        searchScrollPane.setVisible(false);
        previewTable.setVisible(false);
        previewScrollPane.setVisible(false);
        returnBookPanel.setVisible(false);
        loginPanel.setVisible(false);
        registerPanel.setVisible(false);

        allReaderTable.setVisible(false);
        allReaderScrollPane.setVisible(false);
        borrowTable.setVisible(false);
        borrowScrollPane.setVisible(false);
        insertBookPanel.setVisible(false);
        deleteBookPanel.setVisible(false);
        updateAdminPanel.setVisible(false);
    }

    // 主页搜索图书 && 借阅图书
    private void search() {
        hideAll();
        searchTable.setVisible(true);
        searchScrollPane.setVisible(true);
        if (searchTableVis == 0) {
            searchTable.setBackground(UIManager.getColor("Button.background"));
            searchTable.getTableHeader().setBackground(Color.PINK);
            searchTable.setRowHeight(30);
            searchTable.setFont(new Font("宋体", Font.PLAIN, 20));
            searchScrollPane = new JScrollPane(searchTable);
            searchScrollPane.setBounds(150, 100, 1000, 500);
            frame.getContentPane().add(searchScrollPane);
            searchTableVis = 1;

            borrowPopup = new JPopupMenu();
            JMenuItem item = new JMenuItem("借阅");
            item.addActionListener(new ActionListener() {
                public void actionPerformed(ActionEvent e) {
                    int row = searchTable.getSelectedRow();
                    if (row == -1)
                        return;
                    String bookISBN = (String) searchTable.getValueAt(row, 0);
                    String readerAccount = button_1.getText();
                    if (readerAccount.equals("登录")) {
                        JOptionPane.showMessageDialog(null, "请先登录账号", "出错啦", 0);
                        return;
                    }
                    int flag = BorrowService.checkBorrow(readerAccount);
                    if (flag == 2)
                        JOptionPane.showMessageDialog(null, "借阅失败，实际借阅的数量超过图书额定的借阅数量。", "出错啦", 0);
                    else if (flag == 1)
                        JOptionPane.showMessageDialog(null, "借阅失败，您有超期未归还的图书。", "出错啦", 0);
                    else {
                        String bookCode = BorrowService.borrowBook(bookISBN, readerAccount);
                        JOptionPane.showMessageDialog(null, "借阅成功，图书编号为" + bookCode, "提示", 0);
                    }
                }
            });
            borrowPopup.add(item);
            searchTable.add(borrowPopup);

            searchTable.addMouseListener(new MouseListener() {
                public void mouseClicked(MouseEvent e) {
                    if (e.getButton() == MouseEvent.BUTTON3) {
                        borrowPopup.show(e.getComponent(), e.getX(), e.getY());
                    }
                }

                public void mouseEntered(MouseEvent e) {
                }

                public void mouseExited(MouseEvent e) {
                }

                public void mousePressed(MouseEvent e) {
                }

                public void mouseReleased(MouseEvent e) {
                }
            });
        }

        String bookInfo = new String(textField.getText());

        searchBookTable = new SearchBookTable(BookService.showBook(bookInfo));
        searchTable.setModel(searchBookTable);
    }

    // 显示顶部
    private void showHead() {
        headPanel.setBounds(10, 0, 1244, 61);
        frame.getContentPane().add(headPanel);
        headPanel.setLayout(null);
        headPanel.setOpaque(false);

        button_0 = new JButton("注册");
        button_0.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (button_0.getText() == "注册") {
                    register();
                } else {
                    logout();
                }
            }
        });
        button_0.setBounds(1163, 10, 71, 41);
        headPanel.add(button_0);

        button_1 = new JButton("登录");
        button_1.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                if (button_1.getText() == "登录") {
                    login();
                } else {
                    showReaderBorrow(button_1.getText());
                }
            }
        });
        button_1.setBounds(1094, 10, 71, 41);
        headPanel.add(button_1);

        button_2 = new JButton("还书");
        button_2.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                returnBook();
            }
        });
        button_2.setBounds(1025, 10, 71, 41);
        headPanel.add(button_2);

        button_3 = new JButton("预览");
        button_3.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                preview();
            }
        });
        button_3.setBounds(956, 10, 71, 41);
        headPanel.add(button_3);

        button_4 = new JButton("主页");
        button_4.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                showHome();
            }
        });
        button_4.setBounds(887, 10, 71, 41);
        headPanel.add(button_4);

        adminPopup = new JPopupMenu();
        JMenu showReader = new JMenu("查询读者");
        adminPopup.add(showReader);

        JMenuItem showAllReader = new JMenuItem("查询所有读者信息");
        showAllReader.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                showReader();
            }
        });
        showReader.add(showAllReader);

        JMenu showBorrow = new JMenu("查询借阅记录");
        adminPopup.add(showBorrow);

        JMenuItem showAllBorrow = new JMenuItem("查询所有借阅记录");
        showAllBorrow.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                showBorrow();
            }
        });
        showBorrow.add(showAllBorrow);

        JMenuItem insertBook = new JMenuItem("添加图书");
        insertBook.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                insertBook();
            }
        });
        adminPopup.add(insertBook);

        JMenuItem deleteBook = new JMenuItem("删除图书");
        deleteBook.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                deleteBook();
            }
        });
        adminPopup.add(deleteBook);

        updateAdmin = new JMenuItem("更新管理员");
        updateAdmin.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                updateAdmin();
            }
        });
        adminPopup.add(updateAdmin);
        updateAdmin.setVisible(false);

        adminLabel = new JLabel("管理");
        adminLabel.add(adminPopup);
        adminLabel.addMouseListener(new MouseListener() {
            public void mouseClicked(MouseEvent e) {
                if (e.getButton() == MouseEvent.BUTTON1) {
                    adminPopup.show(e.getComponent(), e.getX(), e.getY());
                }
            }

            public void mouseEntered(MouseEvent e) {
            }

            public void mouseExited(MouseEvent e) {
            }

            public void mousePressed(MouseEvent e) {
            }

            public void mouseReleased(MouseEvent e) {
            }
        });
        adminLabel.setBounds(20, 10, 71, 41);
        adminLabel.setFont(new Font("宋体", Font.BOLD, 20));
        headPanel.add(adminLabel);
        adminLabel.setVisible(false);

        button_0.setContentAreaFilled(false);
        button_1.setContentAreaFilled(false);
        button_2.setContentAreaFilled(false);
        button_3.setContentAreaFilled(false);
        button_4.setContentAreaFilled(false);
    }

    // 显示主页
    private void showHome() {
        hideAll();
        homePanel.setVisible(true);
        if (homePanelVis == 1)
            return;
        homePanelVis = 1;

        homePanel.setBounds(10, 60, 1244, 611);
        frame.getContentPane().add(homePanel);
        homePanel.setLayout(null);
        homePanel.setOpaque(false);

        textField = new JTextField();
        textField.setBounds(200, 150, 720, 50);
        textField.setText("请输入图书名或作者");
        textField.setFont(new Font("宋体", Font.PLAIN, 20));
        textField.addKeyListener(new KeyListener() {
            public void keyTyped(KeyEvent e) {
            }

            public void keyReleased(KeyEvent e) {
                if (e.getKeyChar() == KeyEvent.VK_ENTER)
                    search();
            }

            public void keyPressed(KeyEvent e) {
            }
        });
        homePanel.add(textField);

        JButton btnNewButton = new JButton("搜索");
        btnNewButton.setFont(new Font("宋体", Font.BOLD, 25));
        btnNewButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                search();
            }
        });
        btnNewButton.setBackground(Color.PINK);
        btnNewButton.setBounds(920, 149, 100, 50);
        homePanel.add(btnNewButton);
    }

    // 预览（显示所有图书信息）
    private void preview() {
        hideAll();
        previewTable.setVisible(true);
        previewScrollPane.setVisible(true);
        if (previewTableVis == 0) {
            previewTable.setBackground(UIManager.getColor("Button.background"));
            previewTable.getTableHeader().setBackground(Color.PINK);
            previewTable.setRowHeight(30);
            previewTable.setFont(new Font("宋体", Font.PLAIN, 20));
            previewScrollPane = new JScrollPane(previewTable);
            previewScrollPane.setBounds(150, 100, 1000, 500);
            frame.getContentPane().add(previewScrollPane);
            previewTableVis = 1;
        }

        bookTable = new BookTable(BookService.showBook());
        previewTable.setModel(bookTable);
    }

    // 还书
    private void returnBook() {
        hideAll();
        returnBookPanel.setVisible(true);
        if (returnBookPanelVis == 1)
            return;
        returnBookPanelVis = 1;

        returnBookPanel.setBackground(UIManager.getColor("Button.background"));
        returnBookPanel.setBounds(10, 60, 1244, 611);
        frame.getContentPane().add(returnBookPanel);
        returnBookPanel.setLayout(null);
        returnBookPanel.setOpaque(false);

        JLabel label_0 = new JLabel("图书号：", JLabel.RIGHT);
        label_0.setBounds(400, 100, 100, 50);
        returnBookPanel.add(label_0);

        JTextField text_0 = new JTextField();
        text_0.setBounds(500, 110, 250, 30);
        returnBookPanel.add(text_0);

        JButton confirmButton = new JButton("确定");
        confirmButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                String bookCode = text_0.getText();

                double fine = BorrowService.returnBook(bookCode);
                if (fine == -1) {
                    JOptionPane.showMessageDialog(null, "还书失败,图书不存在或图书已归还", "提示", 0);
                } else {
                    JOptionPane.showMessageDialog(null, "归还成功，罚金：" + fine + "元", "提示", 0);
                }

            }
        });
        confirmButton.setBounds(500, 420, 80, 40);
        returnBookPanel.add(confirmButton);
        JButton cancelButton = new JButton("取消");
        cancelButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                hideAll();
                homePanel.setVisible(true);
                showHome();
            }
        });
        cancelButton.setBounds(670, 420, 80, 40);
        returnBookPanel.add(cancelButton);
        confirmButton.setBackground(Color.PINK);
        cancelButton.setBackground(Color.PINK);
    }

    // 登录
    private void login() {
        hideAll();
        loginPanel.setVisible(true);
        if (loginPanelVis == 1)
            return;
        loginPanelVis = 1;

        loginPanel.setBackground(UIManager.getColor("Button.background"));
        loginPanel.setBounds(10, 60, 1244, 611);
        frame.getContentPane().add(loginPanel);
        loginPanel.setLayout(null);
        loginPanel.setOpaque(false);

        JLabel accountLabel = new JLabel("账号：", JLabel.RIGHT);
        accountLabel.setBounds(400, 100, 100, 50);
        loginPanel.add(accountLabel);

        JTextField loginAccount = new JTextField();
        loginAccount.setBounds(500, 110, 250, 30);
        loginPanel.add(loginAccount);

        JLabel passwordLabel = new JLabel("密码：", JLabel.RIGHT);
        passwordLabel.setBounds(400, 150, 100, 50);
        loginPanel.add(passwordLabel);

        JPasswordField loginPassword = new JPasswordField();
        loginPassword.setBounds(500, 160, 250, 30);
        loginPanel.add(loginPassword);
        
        /*
        loginAccount.setText("admin");
        loginPassword.setText("admin");
        */

        JButton confirmButton = new JButton("确定");
        confirmButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                String account = loginAccount.getText();
                char[] str = loginPassword.getPassword();
                String password = String.valueOf(str);

                int identity = ReaderService.checkReader(account, password);
                if (identity == -1)
                    JOptionPane.showMessageDialog(null, "账号不存在或密码错误", "出错啦", 0);
                else {
                    button_1.setText(account);
                    button_0.setText("退出");
                    showHome();
                    if (identity > 0) {
                        adminLabel.setVisible(true);
                        if (account.equals("admin"))
                            updateAdmin.setVisible(true);
                        else
                            updateAdmin.setVisible(false);
                    } else
                        adminLabel.setVisible(false);
                }
            }
        });
        confirmButton.setBounds(500, 420, 80, 40);
        loginPanel.add(confirmButton);

        JButton cancelButton = new JButton("取消");
        cancelButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                hideAll();
                homePanel.setVisible(true);
                showHome();
            }
        });
        cancelButton.setBounds(670, 420, 80, 40);
        loginPanel.add(cancelButton);
        confirmButton.setBackground(Color.PINK);
        cancelButton.setBackground(Color.PINK);
    }

    // 退出
    private void logout() {
        button_0.setText("注册");
        button_1.setText("登录");
        adminLabel.setVisible(false);
        showHome();
    }

    // 注册
    private void register() {
        hideAll();
        registerPanel.setVisible(true);
        if (registerPanelVis == 1)
            return;
        registerPanelVis = 1;

        registerPanel.setBackground(UIManager.getColor("Button.background"));
        registerPanel.setBounds(10, 60, 1244, 611);
        frame.getContentPane().add(registerPanel);
        registerPanel.setLayout(null);
        registerPanel.setOpaque(false);

        JLabel label_0 = new JLabel("账号：", JLabel.RIGHT);
        label_0.setBounds(400, 100, 100, 50);
        registerPanel.add(label_0);
        JLabel label_1 = new JLabel("密码：", JLabel.RIGHT);
        label_1.setBounds(400, 150, 100, 50);
        registerPanel.add(label_1);
        JLabel label_2 = new JLabel("确认密码：", JLabel.RIGHT);
        label_2.setBounds(400, 200, 100, 50);
        registerPanel.add(label_2);
        JLabel label_3 = new JLabel("姓名：", JLabel.RIGHT);
        label_3.setBounds(400, 250, 100, 50);
        registerPanel.add(label_3);
        JLabel label_4 = new JLabel("性别：", JLabel.RIGHT);
        label_4.setBounds(400, 300, 100, 50);
        registerPanel.add(label_4);
        JLabel label_5 = new JLabel("手机号：", JLabel.RIGHT);
        label_5.setBounds(400, 350, 100, 50);
        registerPanel.add(label_5);
        JLabel label_wrong1 = new JLabel("账号已存在", JLabel.LEFT);
        label_wrong1.setBounds(800, 100, 100, 50);
        label_wrong1.setForeground(Color.RED);
        registerPanel.add(label_wrong1);
        label_wrong1.setVisible(false);
        JLabel label_wrong2 = new JLabel("两次密码不一样", JLabel.LEFT);
        label_wrong2.setBounds(800, 200, 100, 50);
        label_wrong2.setForeground(Color.RED);
        registerPanel.add(label_wrong2);
        label_wrong2.setVisible(false);
        JLabel label_wrong3 = new JLabel("性别反人类", JLabel.LEFT);
        label_wrong3.setBounds(800, 300, 100, 50);
        label_wrong3.setForeground(Color.RED);
        registerPanel.add(label_wrong3);
        label_wrong3.setVisible(false);

        JTextField text_0 = new JTextField();
        text_0.setBounds(500, 110, 250, 30);
        registerPanel.add(text_0);
        JPasswordField text_1 = new JPasswordField();
        text_1.setBounds(500, 160, 250, 30);
        registerPanel.add(text_1);
        JPasswordField text_2 = new JPasswordField();
        text_2.setBounds(500, 210, 250, 30);
        registerPanel.add(text_2);
        JTextField text_3 = new JTextField();
        text_3.setBounds(500, 260, 250, 30);
        registerPanel.add(text_3);
        JTextField text_4 = new JTextField();
        text_4.setBounds(500, 310, 250, 30);
        registerPanel.add(text_4);
        JTextField text_5 = new JTextField();
        text_5.setBounds(500, 360, 250, 30);
        registerPanel.add(text_5);
        /*
         * text_0.setText("Flowersea"); text_1.setText("12345678");
         * text_2.setText("12345678"); text_3.setText("花海");
         * text_4.setText("男"); text_5.setText("110");
         */
        JButton confirmButton = new JButton("确定");
        confirmButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                String s0 = text_0.getText();
                char[] str = text_1.getPassword();
                String s1 = String.valueOf(str);
                str = text_2.getPassword();
                String s2 = String.valueOf(str);
                String s3 = text_3.getText();
                String s4 = text_4.getText();
                String s5 = text_5.getText();

                int ret = ReaderService.register(s0, s1, s2, s3, s4, s5);
                if (ret == 1)
                    label_wrong1.setVisible(true);
                else
                    label_wrong1.setVisible(false);
                if (ret == 2)
                    label_wrong2.setVisible(true);
                else
                    label_wrong2.setVisible(false);
                if (ret == 3)
                    label_wrong3.setVisible(true);
                else
                    label_wrong3.setVisible(false);
                if (ret == 0) {
                    JOptionPane.showMessageDialog(null, "注册成功", "提示", 0);
                    login();
                }
            }
        });
        confirmButton.setBounds(500, 420, 80, 40);
        registerPanel.add(confirmButton);
        JButton cancelButton = new JButton("取消");
        cancelButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                hideAll();
                homePanel.setVisible(true);
                showHome();
            }
        });
        cancelButton.setBounds(670, 420, 80, 40);
        registerPanel.add(cancelButton);
        confirmButton.setBackground(Color.PINK);
        cancelButton.setBackground(Color.PINK);
    }

    // 显示个人信息
    private void showReaderBorrow(String readerAccount) {
        hideAll();
        borrowTable.setVisible(true);
        borrowScrollPane.setVisible(true);
        if (borrowTableVis == 0) {
            borrowTable.setBackground(UIManager.getColor("Button.background"));
            borrowScrollPane = new JScrollPane(borrowTable);
            borrowScrollPane.setBounds(150, 100, 1000, 500);
            frame.getContentPane().add(borrowScrollPane);
            borrowTableVis = 1;
        }

        borrowBookTable = new BorrowBookTable(BorrowService.showReaderBorrow(readerAccount));
        borrowTable.setModel(borrowBookTable);
    }

    // 以下为管理界面
    // 查询所有读者信息
    private void showReader() {
        hideAll();
        allReaderTable.setVisible(true);
        allReaderScrollPane.setVisible(true);
        if (allReaderTableVis == 0) {
            allReaderTable.setBackground(UIManager.getColor("Button.background"));
            allReaderTable.getTableHeader().setBackground(Color.PINK);
            allReaderTable.setRowHeight(30);
            allReaderTable.setFont(new Font("宋体", Font.PLAIN, 20));
            allReaderScrollPane = new JScrollPane(allReaderTable);
            allReaderScrollPane.setBounds(150, 100, 1000, 500);
            frame.getContentPane().add(allReaderScrollPane);
            allReaderTableVis = 1;
        }

        readerPopup = new JPopupMenu();
        JMenuItem item = new JMenuItem("查询详细信息");
        item.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                int row = allReaderTable.getSelectedRow();
                if (row == -1)
                    return;
                String readerAccount = (String) allReaderTable.getValueAt(row, 0);
                showReaderBorrow(readerAccount);
            }
        });
        readerPopup.add(item);
        allReaderTable.add(readerPopup);

        allReaderTable.addMouseListener(new MouseListener() {
            public void mouseClicked(MouseEvent e) {
                if (e.getButton() == MouseEvent.BUTTON3) {
                    readerPopup.show(e.getComponent(), e.getX(), e.getY());
                }
            }

            public void mouseEntered(MouseEvent e) {
            }

            public void mouseExited(MouseEvent e) {
            }

            public void mousePressed(MouseEvent e) {
            }

            public void mouseReleased(MouseEvent e) {
            }
        });

        readerTable = new ReaderTable(ReaderService.showReader());
        allReaderTable.setModel(readerTable);
    }

    // 查询所有借阅信息
    private void showBorrow() {
        hideAll();
        borrowTable.setVisible(true);
        borrowScrollPane.setVisible(true);
        if (borrowTableVis == 0) {
            borrowTable.setBackground(UIManager.getColor("Button.background"));
            borrowTable.getTableHeader().setBackground(Color.PINK);
            borrowTable.setRowHeight(30);
            borrowTable.setFont(new Font("宋体", Font.PLAIN, 20));
            borrowScrollPane = new JScrollPane(borrowTable);
            borrowScrollPane.setBounds(150, 100, 1000, 500);
            frame.getContentPane().add(borrowScrollPane);
            borrowTableVis = 1;
        }

        borrowBookTable = new BorrowBookTable(BorrowService.showBorrow());
        borrowTable.setModel(borrowBookTable);
    }

    // 添加图书
    private void insertBook() {
        hideAll();
        insertBookPanel.setVisible(true);
        if (insertBookPanelVis == 1)
            return;
        insertBookPanelVis = 1;

        insertBookPanel.setBackground(UIManager.getColor("Button.background"));
        insertBookPanel.setBounds(10, 60, 1244, 611);
        frame.getContentPane().add(insertBookPanel);
        insertBookPanel.setLayout(null);
        insertBookPanel.setOpaque(false);

        JLabel label_0 = new JLabel("图书号：", JLabel.RIGHT);
        label_0.setBounds(400, 100, 100, 50);
        insertBookPanel.add(label_0);
        JLabel label_1 = new JLabel("ISBN：", JLabel.RIGHT);
        label_1.setBounds(400, 150, 100, 50);
        insertBookPanel.add(label_1);
        JLabel label_2 = new JLabel("图书名：", JLabel.RIGHT);
        label_2.setBounds(400, 200, 100, 50);
        insertBookPanel.add(label_2);
        JLabel label_3 = new JLabel("作者：", JLabel.RIGHT);
        label_3.setBounds(400, 250, 100, 50);
        insertBookPanel.add(label_3);
        JLabel label_4 = new JLabel("出版社：", JLabel.RIGHT);
        label_4.setBounds(400, 300, 100, 50);
        insertBookPanel.add(label_4);

        JTextField text_0 = new JTextField();
        text_0.setBounds(500, 110, 250, 30);
        insertBookPanel.add(text_0);
        JTextField text_1 = new JTextField();
        text_1.setBounds(500, 160, 250, 30);
        insertBookPanel.add(text_1);
        JTextField text_2 = new JTextField();
        text_2.setBounds(500, 210, 250, 30);
        insertBookPanel.add(text_2);
        JTextField text_3 = new JTextField();
        text_3.setBounds(500, 260, 250, 30);
        insertBookPanel.add(text_3);
        JTextField text_4 = new JTextField();
        text_4.setBounds(500, 310, 250, 30);
        insertBookPanel.add(text_4);

        JButton confirmButton = new JButton("确定");
        confirmButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                Book book = new Book(text_0.getText(), text_1.getText(), text_2.getText(), text_3.getText(),
                        text_4.getText(), 1);

                int ret = BookService.insertBook(book);
                if (ret == 1) {
                    JOptionPane.showMessageDialog(null, "添加失败,图书号已存在", "提示", 0);
                } else {
                    JOptionPane.showMessageDialog(null, "添加成功", "提示", 0);
                }
            }
        });
        confirmButton.setBounds(500, 420, 80, 40);
        insertBookPanel.add(confirmButton);
        JButton cancelButton = new JButton("取消");
        cancelButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                hideAll();
                homePanel.setVisible(true);
                showHome();
            }
        });
        cancelButton.setBounds(670, 420, 80, 40);
        insertBookPanel.add(cancelButton);
        confirmButton.setBackground(Color.PINK);
        cancelButton.setBackground(Color.PINK);
    }

    // 删除图书
    private void deleteBook() {
        hideAll();
        deleteBookPanel.setVisible(true);
        if (deleteBookPanelVis == 1)
            return;
        deleteBookPanelVis = 1;

        deleteBookPanel.setBackground(UIManager.getColor("Button.background"));
        deleteBookPanel.setBounds(10, 60, 1244, 611);
        frame.getContentPane().add(deleteBookPanel);
        deleteBookPanel.setLayout(null);
        deleteBookPanel.setOpaque(false);

        JLabel label_0 = new JLabel("图书号：", JLabel.RIGHT);
        label_0.setBounds(400, 100, 100, 50);
        deleteBookPanel.add(label_0);

        JTextField text_0 = new JTextField();
        text_0.setBounds(500, 110, 250, 30);
        deleteBookPanel.add(text_0);

        JButton confirmButton = new JButton("确定");
        confirmButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                String bookCode = text_0.getText();

                int ret = BookService.deleteBook(bookCode);
                if (ret == 1) {
                    JOptionPane.showMessageDialog(null, "删除失败,图书号不存在", "提示", 0);
                } else {
                    JOptionPane.showMessageDialog(null, "删除成功", "提示", 0);
                }
            }
        });
        confirmButton.setBounds(500, 420, 80, 40);
        deleteBookPanel.add(confirmButton);
        JButton cancelButton = new JButton("取消");
        cancelButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                hideAll();
                homePanel.setVisible(true);
                showHome();
            }
        });
        cancelButton.setBounds(670, 420, 80, 40);
        deleteBookPanel.add(cancelButton);
        confirmButton.setBackground(Color.PINK);
        cancelButton.setBackground(Color.PINK);
    }

    private void updateAdmin() {
        hideAll();
        updateAdminPanel.setVisible(true);
        if (updateAdminPanelVis == 1)
            return;
        updateAdminPanelVis = 1;

        updateAdminPanel.setBounds(10, 60, 1244, 611);
        frame.getContentPane().add(updateAdminPanel);
        updateAdminPanel.setLayout(null);
        updateAdminPanel.setOpaque(false);

        JLabel accountLabel = new JLabel("账号：", JLabel.RIGHT);
        accountLabel.setBounds(400, 100, 100, 50);
        updateAdminPanel.add(accountLabel);

        JTextField readerAccount = new JTextField();
        readerAccount.setBounds(500, 110, 250, 30);
        updateAdminPanel.add(readerAccount);

        JLabel identityLabel = new JLabel("权限：", JLabel.RIGHT);
        identityLabel.setBounds(400, 150, 100, 50);
        updateAdminPanel.add(identityLabel);

        JTextField readerIdentity = new JTextField();
        readerIdentity.setBounds(500, 160, 250, 30);
        updateAdminPanel.add(readerIdentity);

        JButton confirmButton = new JButton("确定");
        confirmButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                String account = readerAccount.getText();
                String identity = readerIdentity.getText();
                int exist = ReaderService.checkReader(account);
                if (exist == 0) {
                    JOptionPane.showMessageDialog(null, "账号不存在", "出错啦", 0);
                    return;
                }
                if (!identity.equals("0") && !identity.equals("1")) {
                    JOptionPane.showMessageDialog(null, "权限格式不正确，0代表普通读者，1代表管理员", "出错啦", 0);
                    return;
                }
                int id = Integer.parseInt(identity);
                ReaderService.updateIdentity(account, id);
                JOptionPane.showMessageDialog(null, "更新成功", "提示", 0);
            }
        });
        confirmButton.setBounds(500, 420, 80, 40);
        updateAdminPanel.add(confirmButton);

        JButton cancelButton = new JButton("取消");
        cancelButton.addActionListener(new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                hideAll();
                homePanel.setVisible(true);
                showHome();
            }
        });
        cancelButton.setBounds(670, 420, 80, 40);
        updateAdminPanel.add(cancelButton);
        confirmButton.setBackground(Color.PINK);
        cancelButton.setBackground(Color.PINK);
    }
}

DataBaseConnection.java

package cn.cleverer.databaseconnection;

import java.sql.*;

public class DataBaseConnection {

    public static Connection getConnection() {
        Connection con;

        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (Exception e) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
            return null;
        }

        try {
            con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/bms", "root", "root");
            return con;
        } catch (Exception e) {
            System.err.print("Connection failed! ");
            System.err.println(e.getMessage());
            return null;
        }
    }
}

Book.java

package cn.cleverer.model;

public class Book {
    private String bookCode;
    private String bookISBN;
    private String bookName;
    private String bookPress;
    private String bookAuther;
    private int bookState;

    public String getBookCode() {
        return bookCode;
    }

    public void setBookCode(String bookCode) {
        this.bookCode = bookCode;
    }

    public String getBookISBN() {
        return bookISBN;
    }

    public void setBookISBN(String bookISBN) {
        this.bookISBN = bookISBN;
    }

    public String getBookName() {
        return bookName;
    }

    public void setBookName(String bookName) {
        this.bookName = bookName;
    }

    public String getBookPress() {
        return bookPress;
    }

    public void setBookPress(String bookPress) {
        this.bookPress = bookPress;
    }

    public String getBookAuther() {
        return bookAuther;
    }

    public void setBookAuther(String bookAuther) {
        this.bookAuther = bookAuther;
    }

    public int isBookState() {
        return bookState;
    }

    public void setBookState(int bookState) {
        this.bookState = bookState;
    }

    public Book(String bookCode, String bookISBN, String bookName, String bookPress, String bookAuther, int bookState) {
        super();
        this.bookCode = bookCode;
        this.bookISBN = bookISBN;
        this.bookName = bookName;
        this.bookPress = bookPress;
        this.bookAuther = bookAuther;
        this.bookState = bookState;
    }
}

Reader.java

package cn.cleverer.model;

public class Reader {
    private String readerAccount;
    private String readerPassword;
    private String readerName;
    private String readerSex;
    private String readerPhoneNumber;
    private int readerIdentity;

    public String getReaderAccount() {
        return readerAccount;
    }

    public void setReaderAccount(String readerAccount) {
        this.readerAccount = readerAccount;
    }

    public String getReaderPassword() {
        return readerPassword;
    }

    public void setReaderPassword(String readerPassword) {
        this.readerPassword = readerPassword;
    }

    public String getReaderName() {
        return readerName;
    }

    public void setReaderName(String readerName) {
        this.readerName = readerName;
    }

    public String getReaderSex() {
        return readerSex;
    }

    public void setReaderSex(String readerSex) {
        this.readerSex = readerSex;
    }

    public String getReaderPhoneNumber() {
        return readerPhoneNumber;
    }

    public void setReaderPhoneNumber(String readerPhoneNumber) {
        this.readerPhoneNumber = readerPhoneNumber;
    }

    public int getReaderIdentity() {
        return readerIdentity;
    }

    public void setReaderIdentity(int readerIdentity) {
        this.readerIdentity = readerIdentity;
    }

    public Reader(String readerAccount, String readerPassword, String readerName, String readerSex,
            String readerPhoneNumber, int readerIdentity) {
        super();
        this.readerAccount = readerAccount;
        this.readerPassword = readerPassword;
        this.readerName = readerName;
        this.readerSex = readerSex;
        this.readerPhoneNumber = readerPhoneNumber;
        this.readerIdentity = readerIdentity;
    }
}

BookTable.java

package cn.cleverer.tablemodel;

import javax.swing.table.AbstractTableModel;
import java.sql.*;

public class BookTable extends AbstractTableModel {
    final String[] columnNames = { "书号", "ISBN", "书名", "作者", "出版社", "状态" };

    Object[][] data;

    public BookTable(ResultSet rs) {
        int i = 0;
        try {
            while (rs.next()) {
                i++;
            }
            data = new Object[i][];
            rs.beforeFirst();
            i = 0;

            while (rs.next()) {
                data[i] = new Object[6];
                data[i][0] = new Object();
                data[i][0] = rs.getString("bookCode");
                data[i][1] = new Object();
                data[i][1] = rs.getString("bookISBN");
                data[i][2] = new Object();
                data[i][2] = rs.getString("bookName");
                data[i][3] = new Object();
                data[i][3] = rs.getString("bookAuther");
                data[i][4] = new Object();
                data[i][4] = rs.getString("bookPress");
                data[i][5] = new Object();
                data[i][5] = rs.getInt("bookState");
                i++;
            }

        } catch (Exception e) {
        }
    }

    public int getColumnCount() {
        return columnNames.length;
    }

    public int getRowCount() {
        return data.length;
    }

    public String getColumnName(int col) {
        return columnNames[col];
    }

    public Object getValueAt(int row, int col) {
        return data[row][col];
    }

    public boolean isCellEditable(int row, int col) {
        return false;
    }

    // 获取列的数据类型，JTable使用该方法确定数据的显示格式。
    public Class getColumnClass(int c) {
        return getValueAt(0, c).getClass();
    }

    // 改变网格单元的值。
    public void setValueAt(Object value, int row, int col) {
        data[row][col] = value;
        fireTableCellUpdated(row, col);
    }
}

BorrowBookTable.java

package cn.cleverer.tablemodel;

import javax.swing.table.AbstractTableModel;
import java.sql.*;

public class BorrowBookTable extends AbstractTableModel {
    final String[] columnNames = { "借阅号", "书号", "读者号", "借阅日期", "归还日期", "罚款" };

    Object[][] data;

    public BorrowBookTable(ResultSet rs) {
        int i = 0;
        try {
            while (rs.next()) {
                i++;
            }
            data = new Object[i][];
            rs.beforeFirst();
            i = 0;

            while (rs.next()) {
                data[i] = new Object[6];
                data[i][0] = new Object();
                data[i][0] = rs.getString("borrowNumber");
                data[i][1] = new Object();
                data[i][1] = rs.getString("bookCode");
                data[i][2] = new Object();
                data[i][2] = rs.getString("readerAccount");
                data[i][3] = new Object();
                data[i][3] = rs.getString("borrowDate");
                data[i][4] = new Object();
                data[i][4] = rs.getString("returnDate");
                data[i][5] = new Object();
                data[i][5] = rs.getDouble("fine");
                i++;
            }

        } catch (Exception e) {
        }
    }

    public int getColumnCount() {
        return columnNames.length;
    }

    public int getRowCount() {
        return data.length;
    }

    public String getColumnName(int col) {
        return columnNames[col];
    }

    public Object getValueAt(int row, int col) {
        return data[row][col];
    }

    public boolean isCellEditable(int row, int col) {
        return false;
    }

    // 获取列的数据类型，JTable使用该方法确定数据的显示格式。
    public Class getColumnClass(int c) {
        return getValueAt(0, c).getClass();
    }

    // 改变网格单元的值。
    public void setValueAt(Object value, int row, int col) {
        data[row][col] = value;
        fireTableCellUpdated(row, col);
    }
}

ReaderTable.java

package cn.cleverer.tablemodel;

import javax.swing.table.AbstractTableModel;
import java.sql.*;

public class ReaderTable extends AbstractTableModel {
    final String[] columnNames = { "账号", "密码", "姓名", "性别", "手机号", "身份" };

    Object[][] data;

    public ReaderTable(ResultSet rs) {
        int i = 0;
        try {
            while (rs.next()) {
                i++;
            }
            data = new Object[i][];
            rs.beforeFirst();
            i = 0;

            while (rs.next()) {
                data[i] = new Object[6];
                data[i][0] = new Object();
                data[i][0] = rs.getString("readerAccount");
                data[i][1] = new Object();
                data[i][1] = rs.getString("readerPassword");
                data[i][2] = new Object();
                data[i][2] = rs.getString("readerName");
                data[i][3] = new Object();
                data[i][3] = rs.getString("readerSex");
                data[i][4] = new Object();
                data[i][4] = rs.getString("readerPhoneNumber");
                data[i][5] = new Object();
                data[i][5] = rs.getInt("readerIdentity");
                i++;
            }

        } catch (Exception e) {
        }
    }

    public int getColumnCount() {
        return columnNames.length;
    }

    public int getRowCount() {
        return data.length;
    }

    public String getColumnName(int col) {
        return columnNames[col];
    }

    public Object getValueAt(int row, int col) {
        return data[row][col];
    }

    public boolean isCellEditable(int row, int col) {
        return false;
    }

    // 获取列的数据类型，JTable使用该方法确定数据的显示格式。
    public Class getColumnClass(int c) {
        return getValueAt(0, c).getClass();
    }

    // 改变网格单元的值。
    public void setValueAt(Object value, int row, int col) {
        data[row][col] = value;
        fireTableCellUpdated(row, col);

    }

}

SearchBookTable.java

package cn.cleverer.tablemodel;

import javax.swing.table.AbstractTableModel;
import java.sql.*;

public class SearchBookTable extends AbstractTableModel {
    final String[] columnNames = { "ISBN", "书名", "作者", "出版社", "剩余数量" };

    Object[][] data;

    public SearchBookTable(ResultSet rs) {
        int i = 0;
        try {
            while (rs.next()) {
                i++;
            }
            data = new Object[i][];
            rs.beforeFirst();
            i = 0;

            while (rs.next()) {
                data[i] = new Object[5];
                data[i][0] = new Object();
                data[i][0] = rs.getString("bookISBN");
                data[i][1] = new Object();
                data[i][1] = rs.getString("bookName");
                data[i][2] = new Object();
                data[i][2] = rs.getString("bookAuther");
                data[i][3] = new Object();
                data[i][3] = rs.getString("bookPress");
                data[i][4] = new Object();
                data[i][4] = rs.getInt("sum(bookState)");
                i++;
            }

        } catch (Exception e) {
        }
    }

    public int getColumnCount() {
        return columnNames.length;
    }

    public int getRowCount() {
        return data.length;
    }

    public String getColumnName(int col) {
        return columnNames[col];
    }

    public Object getValueAt(int row, int col) {
        return data[row][col];
    }

    public boolean isCellEditable(int row, int col) {
        return false;
    }

    // 获取列的数据类型，JTable使用该方法确定数据的显示格式。
    public Class getColumnClass(int c) {
        return getValueAt(0, c).getClass();
    }

    // 改变网格单元的值。
    public void setValueAt(Object value, int row, int col) {
        data[row][col] = value;
        fireTableCellUpdated(row, col);

    }

}

BookService.java

package cn.cleverer.service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import cn.cleverer.databaseconnection.DataBaseConnection;
import cn.cleverer.model.Book;

public class BookService {
    public static ResultSet showBook() {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select * from book";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        return rs;
    }

    public static ResultSet showBook(String bookInfo) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select bookISBN,bookName,bookAuther,bookPress,sum(bookState) " + "from book " + "where bookName = " + "'"
                + bookInfo + "'" + "or bookAuther = " + "'" + bookInfo + "'" + "group by bookISBN";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        return rs;
    }

    public static int insertBook(Book book) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        String bookCode = book.getBookCode();
        sql = "select count(bookCode) from book where bookCode = " + "'" + bookCode + "'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        int exist = 0;
        try {
            rs.next();
            exist = rs.getInt("count(bookCode)");

        } catch (Exception ee) {
        }
        if (exist == 1)
            return 1;

        con = DataBaseConnection.getConnection();
        sql = "insert into book values('" + book.getBookCode() + "','" + book.getBookISBN() + "','" + book.getBookName()
                + "','" + book.getBookAuther() + "','" + book.getBookAuther() + "',1)";
        rs = null;
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception ee) {
        }

        return 0;
    }

    public static int deleteBook(String bookCode) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select count(bookCode) from book where bookCode = " + "'" + bookCode + "'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        int exist = 0;
        try {
            rs.next();
            exist = rs.getInt("count(bookCode)");

        } catch (Exception e) {
        }
        if (exist == 0)
            return 1;

        con = DataBaseConnection.getConnection();
        sql = "delete from book where bookCode = " + "'" + bookCode + "'";
        rs = null;
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception ee) {
        }

        return 0;
    }
}

BorrowService.java

package cn.cleverer.service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import cn.cleverer.databaseconnection.DataBaseConnection;
import java.util.*;
import java.text.SimpleDateFormat;

public class BorrowService {
    public static ResultSet showBorrow() {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select * from borrowrecord";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        return rs;
    }

    public static ResultSet showReaderBorrow(String readerAccount) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select * from borrowrecord where readerAccount = " + "'" + readerAccount + "'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        return rs;
    }

    public static int checkBorrow(String readerAccount) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        // 找出这个人已经借了多少本书
        sql = "select count(*) from borrowrecord where readerAccount = " + "'" + readerAccount + "'"
                + "and returnDate = '未归还'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        int number = 0;
        try {
            rs.next();
            number = rs.getInt("count(*)");
        } catch (Exception e) {
        }
        // 这里假设最多只能借3本
        if (number >= 3)
            return 2;

        // 获得这个人的罚款
        con = DataBaseConnection.getConnection();
        sql = "select fine from borrowrecord where readerAccount = " + "'" + readerAccount + "'";
        rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        double fine = 0;
        try {
            rs.next();
            fine = rs.getDouble("fine");
        } catch (Exception e) {
        }
        if (fine != 0)
            return 1;
        return 0;
    }

    public static String borrowBook(String bookISBN, String readerAccount) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();

        // 获得ISBN的这种书所有没有被借的
        sql = "select bookCode from book where bookISBN = '" + bookISBN + "' and bookState = 1";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }

        String bookCode = "";
        try {
            rs.next();
            bookCode = rs.getString("bookCode");
        } catch (Exception e) {
        }

        // 把book表中这本书的状态置为0
        sql = "update book set bookState = 0 where bookcode =" + "'" + bookCode + "'";
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception e) {
        }

        // 获得当前最大的借阅号，+1即为本次借阅的借阅号
        sql = "select max(borrowNumber) from borrowrecord";
        rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }

        String borrowNumber = "";
        try {
            rs.next();
            borrowNumber = rs.getString("max(borrowNumber)");
        } catch (Exception e) {
        }
        int num = Integer.parseInt(borrowNumber);
        num++;
        borrowNumber = String.valueOf(num);
        while (borrowNumber.length() < 5)
            borrowNumber = 0 + borrowNumber; // 不够前面补0

        // 插入借阅信息
        Date now = new Date();
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
        String borrowTime = dateFormat.format(now);
        sql = "insert into borrowrecord values('" + borrowNumber + "','" + bookCode + "','" + readerAccount + "','"
                + borrowTime + "','未归还',0)";
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception e) {
        }

        return bookCode;
    }

    public static double returnBook(String bookCode) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        // 判断这本书是否被借，如果没有被借，fine = -1，如果有罚款，fine = 罚款
        sql = "select fine from borrowrecord where bookcode = " + "'" + bookCode + "'" + " and returndate = '未归还'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        double fine = -1;
        try {
            rs.next();
            fine = rs.getDouble("fine");

        } catch (Exception e) {
        }
        if (fine == -1)
            return -1;

        Date now = new Date();
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
        String returnTime = dateFormat.format(now);

        // 更新borrowrecord表
        sql = "update borrowrecord set returndate = " + "'" + returnTime + "'" + ",fine = 0.0 where bookcode =" + "'"
                + bookCode + "'" + "and returndate = '未归还'";
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception e) {
        }

        // 把book表中这本书的状态置为1
        sql = "update book set bookState = 1 where bookcode =" + "'" + bookCode + "'";
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception e) {
        }
        return fine;
    }

    // 重新计算所有在借的书是否超期，如果超期就更新罚款，罚款的计算规则为最长借一个月，超期罚款100元，设定在每次启动系统的时候执行
    public static Date dateAdd(int days) {
        // 日期处理模块 (将日期加上某些天或减去天数)返回字符串
        Calendar canlendar = Calendar.getInstance(); // java.util包
        canlendar.add(Calendar.DATE, days); // 日期减 如果不够减会将月变动
        return canlendar.getTime();
    }

    public static void refreshBorrow() {
        Date date = BorrowService.dateAdd(-30);
        SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd");
        // 计算今天的前30天是哪一天
        String extendedTime = dateFormat.format(date);
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        // 如果借阅的时间比前30天还早，就说明超期了
        sql = "update borrowrecord set fine = 100 where borrowDate < '" + extendedTime + "'";
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception e) {
        }
    }
}

ReaderService.java

package cn.cleverer.service;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import cn.cleverer.databaseconnection.DataBaseConnection;

public class ReaderService {
    public static int checkReader(String account) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select count(*) from reader where readerAccount = " + "'" + account + "'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception ee) {
        }
        int number = 0;
        try {
            rs.next();
            number = rs.getInt("count(*)");
        } catch (Exception e) {
        }
        return number;
    }

    public static int checkReader(String account, String password) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select readerAccount,readerPassword,readerIdentity from reader where readerAccount = " + "'" + account
                + "'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception ee) {
        }

        try {
            rs.next();
            String readerPassword = rs.getString("readerPassword");
            if (password.equals(readerPassword))
                return rs.getInt("readerIdentity");
        } catch (Exception ee) {
        }
        return -1;
    }

    public static void updateIdentity(String account, int identity) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "update reader set readerIdentity = " + identity + " where readerAccount = '" + account + "'";
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception e) {
        }
    }

    public static int register(String s0, String s1, String s2, String s3, String s4, String s5) {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select count(readerAccount) from reader where readerAccount = " + "'" + s0 + "'";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception ee) {
        }
        int exist = 0;
        try {
            rs.next();
            exist = rs.getInt("count(readerAccount)");

        } catch (Exception e) {
        }

        if (exist == 1)
            return 1;
        if (!s1.equals(s2))
            return 2;
        if (!s4.equals("男") && !s4.equals("女"))
            return 3;

        con = DataBaseConnection.getConnection();
        sql = "insert into reader values('" + s0 + "','" + s1 + "','" + s3 + "','" + s4 + "','" + s5 + "',0)";
        rs = null;
        try {
            stmt = con.createStatement();
            stmt.execute(sql);
        } catch (Exception ee) {
        }
        return 0;
    }

    public static ResultSet showReader() {
        Connection con;
        String sql;
        Statement stmt;
        con = DataBaseConnection.getConnection();
        sql = "select * from reader";
        ResultSet rs = null;
        try {
            stmt = con.createStatement();
            rs = stmt.executeQuery(sql);
        } catch (Exception e) {
        }
        return rs;
    }
}