基于Java与Oracle开发的图书馆管理系统设计（附完整Java源码及SQL文件）.rar
5星
- 浏览量: 0
- 大小:None
- 文件类型：None
简介：
本资源提供了一个基于Java和Oracle数据库的图书馆管理系统的详细设计与实现。包含完整的Java源代码和SQL脚本，适用于学习与参考。
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;
// 更改查询逻辑以适应实际需求
}
}
}
全部评论 (0)
