数据库课设-基于Java+JavaSwing图形界面+SQLserver实现的图书馆管理系统（完整源代码和数据库）

import javax.swing.JFrame; import javax.swing.JPanel; import java.awt.BorderLayout; import java.awt.Dimension; import javax.swing.JTabbedPane; import java.awt.Rectangle; import java.awt.GridBagLayout; import java.awt.GridBagConstraints; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import java.sql.SQLException; import java.util.Calendar; import javax.swing.JOptionPane; import javax.swing.JScrollPane; import javax.swing.JTable; import javax.swing.JButton; import javax.swing.JLabel; import javax.swing.JTextField; import javax.swing.JComboBox; import javax.swing.JPasswordField; import javax.swing.JTextArea; public class Adminfrm extends JFrame implements ActionListener { // private JFrame jFrame = null; // @jve:decl-index=0:visual-constraint="53,6" private JPanel jContentPane = null; private JTabbedPane jTabbedPane = null; private JPanel jPanel = null; private JPanel jPanel1 = null; private JPanel jPanel2 = null; private JPanel jPanel3 = null; private JPanel jPanel4 = null; private JTabbedPane jTabbedPane1 = null; private JPanel jPanel6 = null; private JPanel jPanel7 = null; private JScrollPane jScrollPane = null; private JTable jTable = null; private JButton jButton = null; private JLabel jLabel = null; private JLabel jLabel1 = null; private JLabel jLabel2 = null; private JLabel jLabel3 = null; private JLabel jLabel4 = null; private JLabel jLabel5 = null; public static Object rowdata[][]; // @jve:decl-index=0: public static JTextField jTextField = null; public static JTextField jTextField1 = null; public static JTextField jTextField2 = null; public static JTextField jTextField3 = null; public static JTextField jTextField4 = null; private JComboBox jComboBox = null; private JButton jButton1 = null; private JButton jButton2 = null; private JTabbedPane jTabbedPane2 = null; private JPanel jPanel8 = null; private JPanel jPanel9 = null; private JScrollPane jScrollPane1 = null; private JTable jTable1 = null; private JButton jButton3 = null; private JLabel jLabel6 = null; private JLabel jLabel7 = null; private JLabel jLabel8 = null; private JLabel jLabel9 = null; private JComboBox jComboBox1 = null; private JLabel jLabel10 = null; public static JTextField jTextField5 = null; public static JTextField jTextField7 = null; public static JTextField jTextField8 = null; private JButton jButton4 = null; private JButton jButton5 = null; private JButton jButton6 = null; public static Object[] columnNames = {"�鼮���", "����", "����", "������", "����", "����ʱ��","��������","�ڹ���Ŀ","�ع�"}; public static Object rowdata1[][]; public static Object[] columnNames1 = {"����","Ȩ��", "����", "�Ա�", "������¼", "����"}; public static Object rowdata2[][]; public static Object[] columnNames2 = {"������","ѧ�����", "��������", "��������", "�Ƿ���Ч"}; public static Object rowdata3[][]; public static Object[] columnNames3 = {"Υ�±��","������", "Υ������"}; public static JPasswordField jPasswordField = null; private JLabel jLabel11 = null; public static JPasswordField jPasswordField1 = null; private JScrollPane jScrollPane2 = null; private JTable jTable2 = null; private JButton jButton7 = null; private JTabbedPane jTabbedPane3 = null; private JPanel jPanel10 = null; private JPanel jPanel11 = null; private JScrollPane jScrollPane3 = null; private JTable jTable3 = null; private JButton jButton8 = null; private JLabel jLabel12 = null; private JLabel jLabel13 = null; public static JTextField jTextField6 = null; public static JTextField jTextField9 = null; private JButton jButton9 = null; private JLabel jLabel14 = null; private JLabel jLabel15 = null; public static JTextField jTextField10 = null; public static JTextField jTextField11 = null; private JLabel jLabel16 = null; public static JTextArea jTextArea = null; private JButton jButton10 = null; /** * This is the default constructor */ public Adminfrm() { super(); initialize(); } /** * This method initializes this * * @return void */ private void initialize() { this.setSize(new Dimension(593, 424)); this.setContentPane(getJContentPane()); this.setTitle("����Ա����"); //this.setLocation(250,80); this.addWindowListener(new java.awt.event.WindowAdapter() { public void windowClosing(java.awt.event.WindowEvent e) { System.exit(0); } }); } /** * This method initializes jFrame * * @return javax.swing.JFrame */ private JFrame getJFrame() { if (jFrame == null) { jFrame = new JFrame(); jFrame.setSize(new Dimension(606, 425)); jFrame.setTitle("����Ա����"); jFrame.setContentPane(getJContentPane()); } return jFrame; } /** * This method initializes jContentPane * * @return javax.swing.JPanel */ private JPanel getJContentPane() { if (jContentPane == null) { GridBagConstraints gridBagConstraints = new GridBagConstraints(); gridBagConstraints.fill = GridBagConstraints.BOTH; gridBagConstraints.gridy = 0; gridBagConstraints.weightx = 1.0; gridBagConstraints.weighty = 1.0; gridBagConstraints.gridx = 0; jContentPane = new JPanel(); jContentPane.setLayout(new GridBagLayout()); jContentPane.add(getJTabbedPane(), gridBagConstraints); } return jContentPane; } /** * This method initializes jTabbedPane * * @return javax.swing.JTabbedPane */ private JTabbedPane getJTabbedPane() { if (jTabbedPane == null) { jTabbedPane = new JTabbedPane(); jTabbedPane.setBounds(new Rectangle(1, 0, 734, 461)); jTabbedPane.addTab("�鿯����", null, getJPanel(), null); jTabbedPane.addTab("�û�����", null, getJPanel1(), null); jTabbedPane.addTab("���Ĺ���", null, getJPanel2(), null); jTabbedPane.addTab("ԤԼ�б�", null, getJPanel3(), null); jTabbedPane.addTab("Υ���б�", null, getJPanel4(), null); } return jTabbedPane; } /** * This method initializes jPanel * * @return javax.swing.JPanel */ private JPanel getJPanel() { if (jPanel == null) { GridBagConstraints gridBagConstraints1 = new GridBagConstraints(); gridBagConstraints1.fill = GridBagConstraints.BOTH; gridBagConstraints1.gridy = 0; gridBagConstraints1.weightx = 1.0; gridBagConstraints1.weighty = 1.0; gridBagConstraints1.gridx = 0; jPanel = new JPanel(); jPanel.setLayout(new GridBagLayout()); jPanel.add(getJTabbedPane1(), gridBagConstraints1); } return jPanel; } /** * This method initializes jPanel1 * * @return javax.swing.JPanel */ private JPanel getJPanel1() { if (jPanel1 == null) { GridBagConstraints gridBagConstraints2 = new GridBagConstraints(); gridBagConstraints2.fill = GridBagConstraints.BOTH; gridBagConstraints2.gridy = 0; gridBagConstraints2.weightx = 1.0; gridBagConstraints2.weighty = 1.0; gridBagConstraints2.gridx = 0; jPanel1 = new JPanel(); jPanel1.setLayout(new GridBagLayout()); jPanel1.add(getJTabbedPane2(), gridBagConstraints2); } return jPanel1; } /** * This method initializes jPanel2 * * @return javax.swing.JPanel */ private JPanel getJPanel2() { if (jPanel2 == null) { GridBagConstraints gridBagConstraints3 = new GridBagConstraints(); gridBagConstraints3.fill = GridBagConstraints.BOTH; gridBagConstraints3.gridy = 0; gridBagConstraints3.weightx = 1.0; gridBagConstraints3.weighty = 1.0; gridBagConstraints3.gridx = 0; jPanel2 = new JPanel