图书管理系统Java实现

package libraryPackage; import java.awt.BorderLayout; import java.awt.Dimension; import javax.swing.JFrame; import javax.swing.JPanel; import javax.swing.JTabbedPane; import java.awt.*; import javax.swing.*; import javax.swing.border.TitledBorder; import java.util.Vector; import jxl.Sheet; import java.io.File; import jxl.Cell; import java.io.FileInputStream; import jxl.Workbook; import javax.swing.table.DefaultTableModel; import libraryPackage.libraryinfo; import java.awt.event.MouseEvent; import java.awt.event.MouseAdapter; import java.awt.event.ActionEvent; import java.awt.event.ActionListener; import jxl.write.WritableWorkbook; import jxl.write.WritableSheet; import jxl.write.WritableCellFormat; import jxl.write.Label; import jxl.write.DateFormat; import jxl.write.DateTime; import java.util.Date; import java.io.FileOutputStream; import java.util.*; import java.util.TimerTask; import java.util.Timer; public class LibraryFrame extends JFrame { JPanel contentPane; //声明一个默认表格模式 DefaultTableModel dtm=new DefaultTableModel(); JTable tbltable = new JTable(dtm); JScrollPane scp = new JScrollPane(); JButton btnsave = new JButton(); JButton btnedit = new JButton(); JButton btnadd = new JButton(); JButton btncancel = new JButton(); JButton btndele = new JButton(); JTextField txtisbn = new JTextField(); JTextField txtname = new JTextField(); JTextField txteditor = new JTextField(); JTextField txtout = new JTextField(); JTextField txtouttime = new JTextField(); JTextField txtbrotime = new JTextField(); JTextField txtaddtime = new JTextField(); JTextField txtbrobacktime = new JTextField(); JTextField txtbroname = new JTextField(); JTextField txtsearch = new JTextField(); JButton btnsearch = new JButton(); JComboBox cbosearch = new JComboBox(); JButton btnborrow = new JButton(); JButton btnkeepon = new JButton(); JButton btnback = new JButton(); JButton btnsearch2 = new JButton(); JComboBox cbolanguage = new JComboBox(); JComboBox cbokind = new JComboBox(); JComboBox cbostate = new JComboBox(); JButton btnq = new JButton(); JPanel pnldoorup = new JPanel(); JPanel pnldoordown = new JPanel(); JTextField txtuser = new JTextField(); JPasswordField txtpsw = new JPasswordField(); JLabel lbldoorup = new JLabel(new ImageIcon(".\\image\\inone.jpg")); JLabel lbldoordown = new JLabel(new ImageIcon(".\\image\\intwo.jpg")); JLabel lblindex = new JLabel(new ImageIcon(".\\image\\index.jpg")); //声明需要的vector JButton btnlogin = new JButton(); Vector vTitle=new Vector(); Vector vData=new Vector(); Vector vSearchID=new Vector(); Vector vKind=new Vector(); Vector vState=new Vector(); Vector vLanguage=new Vector(); Vector vUser=new Vector();//记录用户名 Vector vPwd=new Vector();//记录密码 Vector vSearch=new Vector();//记录搜索到的结果 Vector vGetSearch=new Vector();//辅助记录搜索到的结果 int type=0,row=0,m=0,n=0,x=0,typex=0; int[][] getnum=new int[50][150];//用来记录搜索到的行的位置 public LibraryFrame() { try { setDefaultCloseOperation(EXIT_ON_CLOSE); jbInit(); } catch (Exception exception) { exception.printStackTrace(); } } private void jbInit() throws Exception { contentPane = (JPanel) getContentPane(); setSize(new Dimension(808, 650)); setTitle("图书管理系统"); contentPane.setLayout(null); cbosearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); cbosearch.setBounds(new Rectangle(865, 15, 71, 35)); txtsearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtsearch.setText(""); txtsearch.setBounds(new Rectangle(950, 15, 410, 35)); btnsearch.setBounds(new Rectangle(1379, 15, 117, 35)); btnsearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btnsearch.setText("查找"); btnsearch.addActionListener(new LibraryFrame_btnsearch_actionAdapter(this)); btnsearch2.setBounds(new Rectangle(1516, 15, 60, 35)); btnsearch2.setEnabled(false); btnsearch2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btnsearch2.setSelectedIcon(null); btnsearch2.setText("返回"); btnsearch2.addActionListener(new LibraryFrame_btnsearch2_actionAdapter(this)); scp.getViewport().setBackground(Color.white); scp.setEnabled(false); scp.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); scp.setBounds(new Rectangle(40, 85, 719, 218)); tbltable.setBackground(Color.white); tbltable.setEnabled(false); tbltable.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); tbltable.setOpaque(false); tbltable.setVerifyInputWhenFocusTarget(false); tbltable.setAutoCreateColumnsFromModel(false); tbltable.setShowHorizontalLines(false); tbltable.setShowVerticalLines(false); tbltable.addMouseListener(new LibraryFrame_tbltable_mouseAdapter(this)); btnsave.setBounds(new Rectangle(-291, 546, 67, 59)); btnsave.setEnabled(false); btnsave.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btnsave.setText("确定"); btnsave.addActionListener(new LibraryFrame_btnsave_actionAdapter(this)); btnedit.setBounds(new Rectangle(-455, 546, 67, 59)); btnedit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btnedit.setText("修改"); btnedit.addActionListener(new LibraryFrame_btnedit_actionAdapter(this)); btnadd.setBounds(new Rectangle(-537, 546, 67, 59)); btnadd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btnadd.setText("添加"); btnadd.addActionListener(new LibraryFrame_btnadd_actionAdapter(this)); btncancel.setBounds(new Rectangle(-210, 546, 67, 59)); btncancel.setEnabled(false); btncancel.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btncancel.setText("取消"); btncancel.addActionListener(new LibraryFrame_btncancel_actionAdapter(this)); btndele.setBounds(new Rectangle(-373, 546, 67, 59)); btndele.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btndele.setText("删除"); btndele.addActionListener(new LibraryFrame_btndele_actionAdapter(this)); txtisbn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtisbn.setText(""); txtisbn.setBounds(new Rectangle(-715, 329, 251, 23)); txtname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtname.setText(""); txtname.setBounds(new Rectangle(925, 362, 251, 23)); txteditor.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txteditor.setText(""); txteditor.setBounds(new Rectangle(-715, 395, 251, 23)); txtout.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtout.setText(""); txtout.setBounds(new Rectangle(925, 428, 251, 23)); txtouttime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtouttime.setText(""); txtouttime.setBounds(new Rectangle(-715, 461, 251, 23)); txtbrotime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtbrotime.setBounds(new Rectangle(-312, 461, 251, 23)); txtaddtime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtaddtime.setBounds(new Rectangle(1328, 362, 251, 23)); txtbroname.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); txtbroname.setBounds(new Rectangle(1328, 428, 251, 23)); btnborrow.setBounds(new Rectangle(-782, 546, 67, 59)); btnborrow.setFont(new java.awt.Font("Dialog", Font.PLAIN, 12)); btnborrow.setText("借书");