基于Java和Oracle实现的图书馆管理系统设计含全部java源码和SQL文件.rar

import java.awt.*; import java.awt.event.*; import javax.swing.*; import java.sql.*; import javax.swing.table.*; import java.util.Vector; public class BorrowBookList extends JFrame implements ActionListener { DataBaseManager db=new DataBaseManager(); ResultSet rs; Container c; JPanel panel1,panel2; JLabel BookNameLabel,StudentNameLabel; JTextField BookNameTextField,StudentNameTextField; JButton SearchBtn,ExitBtn; JTable table=null; DefaultTableModel defaultModel=null; public BorrowBookList() { super("书籍借阅一览！"); c=getContentPane(); c.setLayout(new BorderLayout()); BookNameLabel=new JLabel("书名 ",JLabel.CENTER); StudentNameLabel=new JLabel("借阅者",JLabel.CENTER); BookNameTextField=new JTextField(15); StudentNameTextField=new JTextField(15); SearchBtn=new JButton("查询"); ExitBtn=new JButton("退出"); SearchBtn.addActionListener(this); ExitBtn.addActionListener(this); Box box1=Box.createHorizontalBox(); box1.add(StudentNameLabel); box1.add(StudentNameTextField); box1.add(SearchBtn); Box box2=Box.createHorizontalBox(); box2.add(BookNameLabel); box2.add(BookNameTextField); box2.add(ExitBtn); Box boxH=Box.createVerticalBox(); boxH.add(box1); boxH.add(box2); boxH.add(Box.createVerticalGlue()); panel1=new JPanel(); panel1.add(boxH); panel2=new JPanel(); String[] name={"借阅者","书名","借阅日期","还入日期","备注"}; String[][] data=new String[0][0]; defaultModel=new DefaultTableModel(data,name); table=new JTable(defaultModel); table.setPreferredScrollableViewportSize(new Dimension(400,80)); JScrollPane s=new JScrollPane(table); panel2.add(s); c.add(panel1,BorderLayout.NORTH); c.add(panel2,BorderLayout.SOUTH); } public void actionPerformed(ActionEvent e) { if(e.getSource()==ExitBtn) { db.closeConnection(); this.dispose(); } else if(e.getSource()==SearchBtn) { String strSQL="select studentname,bookname,borrowdate,returndate,com from bookbrowse";