基于Java的图书管理系统源码.zip

package SystemGui; import DataBase.DataBaseOperate; import java.awt.BorderLayout; import java.awt.EventQueue; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.awt.event.WindowAdapter; import java.awt.event.WindowEvent; import java.sql.ResultSet; import java.sql.SQLException; import java.util.function.ObjIntConsumer; import javax.swing.*; import javax.swing.border.EmptyBorder; import javax.swing.table.DefaultTableModel; public class AdminGui extends JFrame { private DataBaseOperate operateTest = new DataBaseOperate(); private JPanel contentPane; private JTextField searchUserTextField; private JTextField IDTextField; private JTextField bookInformationTextField; private JTextField bookNumberTextField; private JTextField competenceIDField; JPanel competencePanel = new JPanel(); JPanel bookBorrowPanel = new JPanel(); JPanel userBorrowPanel = new JPanel(); JPanel informationPanel = new JPanel(); JPanel bookInformationPanel = new JPanel(); private Object[][] userInformation; private Object[][] userBorrow; private Object[][] bookInformation; private Object[][] bookBorrow; private Object[][] competence; private int borrowNumber; private int bookNumber; private int userID; public JPanel imgPanel = new JPanel(); /** * Launch the application. */ /** * Create the frame. */ public AdminGui() { setTitle("图书管理系统管理员界面"); setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); setBounds(100, 100, 771, 483); JMenuBar menuBar = new JMenuBar(); setJMenuBar(menuBar); JMenu userInformationMenu = new JMenu("用户信息管理"); menuBar.add(userInformationMenu); JMenuItem informationMenuItem = new JMenuItem("个人信息管理"); userInformationMenu.add(informationMenuItem); informationMenuItem.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { imgPanel.setVisible(false); bookInformationPanel.setVisible(false); bookBorrowPanel.setVisible(false); informationPanel.setVisible(true); userBorrowPanel.setVisible(false); competencePanel.setVisible(false); } }); JMenuItem userBorrowMenuItem = new JMenuItem("用户借阅记录管理"); userInformationMenu.add(userBorrowMenuItem); userBorrowMenuItem.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { imgPanel.setVisible(false); bookInformationPanel.setVisible(false); bookBorrowPanel.setVisible(false); informationPanel.setVisible(false); userBorrowPanel.setVisible(true); competencePanel.setVisible(false); } }); JMenu bookInformationMenu = new JMenu("图书信息管理"); menuBar.add(bookInformationMenu); JMenuItem bookInformationMenuItem = new JMenuItem("图书信息管理"); bookInformationMenu.add(bookInformationMenuItem); bookInformationMenuItem.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { imgPanel.setVisible(false); bookInformationPanel.setVisible(true); bookBorrowPanel.setVisible(false); informationPanel.setVisible(false); userBorrowPanel.setVisible(false); competencePanel.setVisible(false); } }); JMenuItem bookBorrowMenuItem = new JMenuItem("图书借阅记录管理"); bookInformationMenu.add(bookBorrowMenuItem); bookBorrowMenuItem.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { imgPanel.setVisible(false); bookInformationPanel.setVisible(false); bookBorrowPanel.setVisible(true); informationPanel.setVisible(false); userBorrowPanel.setVisible(false); competencePanel.setVisible(false); } }); JMenu competenceMenu = new JMenu("角色权限管理"); menuBar.add(competenceMenu); JMenuItem compentenceMenuItem = new JMenuItem("角色权限管理"); competenceMenu.add(compentenceMenuItem); compentenceMenuItem.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { imgPanel.setVisible(false); bookInformationPanel.setVisible(false); bookBorrowPanel.setVisible(false); informationPanel.setVisible(false); userBorrowPanel.setVisible(false); competencePanel.setVisible(true); } }); JMenu aboutMenu = new JMenu("关于"); menuBar.add(aboutMenu); JMenuItem exitMenuItem = new JMenuItem("安全退出"); aboutMenu.add(exitMenuItem); exitMenuItem.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { dispose(); Login gui = new Login(); gui.setVisible(true); } }); JMenuItem authorMenuItem = new JMenuItem("关于作者"); aboutMenu.add(authorMenuItem); authorMenuItem.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { JOptionPane.showMessageDialog(null,"作者\n姓名：赵宏鹏\n班级：计科1403\n学号：1030414313","作者",JOptionPane.INFORMATION_MESSAGE); } }); contentPane = new JPanel(); contentPane.setBorder(new EmptyBorder(5, 5, 5, 5)); setContentPane(contentPane); contentPane.setLayout(null); imgPanel.setBounds(0, 0, 745, 413); imgPanel.setLayout(null); contentPane.add(imgPanel); imgPanel.setVisible(true); JLabel imgLabel = new JLabel(new ImageIcon("src/2.jpg")); imgLabel.setVisible(true); imgPanel.add(imgLabel); imgLabel.setBounds(0,0,755,493); setBookInformationPanel(); setBookBorrowPanel(); setInformationPanel(); setUserBorrowPanel(); setCompetencePanel(); bookInformationPanel.setVisible(false); bookBorrowPanel.setVisible(false); informationPanel.setVisible(false); userBorrowPanel.setVisible(false); competencePanel.setVisible(false); } public void setInformationPanel(){ informationPanel.setBounds(0, 0, 745, 413); contentPane.add(informationPanel); informationPanel.setLayout(null); JComboBox searchUserComboBox = new JComboBox(); searchUserComboBox.setModel(new DefaultComboBoxModel(new String[] {"用户ID", "用户名称", "证件号码"})); searchUserComboBox.setSelectedIndex(0); searchUserComboBox.setBounds(95, 10, 83, 21); informationPanel.add(searchUserComboBox); searchUserTextField = new JTextField(); searchUserTextField.setBounds(177, 10, 366, 21); informationPanel.add(searchUserTextField); searchUserTextField.setColumns(10); JButton searchUserButton = new JButton("搜索"); searchUserButton.setBounds(549, 8, 93, 23); searchUserTextField.addActionListener(new ActionListener() { @Override public void actionPerformed(ActionEvent e) { searchUserButton.doClick(); } }); JButton freshUserButton = new JButton("刷新"); freshUserButton.setBounds(649, 8, 93, 23);