bookbrowselist.java

用java写的一个图书馆管理系统,应该说功能相当全面.包含所有源代码,从数据库的建立到客户端.

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import javax.swing.table.*;
import java.util.Vector;

public class BookbrowseList
    extends JFrame {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  Container c;
  JTable table = null;
  DefaultTableModel defaultModel = null;
  public BookbrowseList() {
    super("历史借阅一览！");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    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);
    c.add(s);
    try {
      String strSql = "select studentname,bookname,borrowdate,returndate,is_returned from bookbrowse";
      rs = db.getResult(strSql);
      while (rs.next()) {
        Vector insertRow = new Vector();
        insertRow.addElement(rs.getString(1));
        insertRow.addElement(rs.getString(2));
        insertRow.addElement(rs.getString(3));
        insertRow.addElement(rs.getString(4));
        insertRow.addElement(rs.getString(5));

        defaultModel.addRow(insertRow);
      }
      table.revalidate();
    }
    catch (SQLException sqle) {
      System.out.println(sqle.toString());
    }
    catch (Exception ex) {
      System.out.println(ex.toString());
    }
  }
}