readerlist.java

采用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 ReaderList
    extends JFrame
    implements ActionListener {
  DataBaseManager db = new DataBaseManager();
  ResultSet rs;
  Container c;
  JPanel panel1;
  JLabel ReadernoLabel;
  JTextField ReadernoTextField;
  JButton searchBtn, exitBtn;
  JTable table = null;//显示和编辑常规二维单元空表
  DefaultTableModel defaultModel = null;
  public ReaderList() {
    super("读者信息查询！");
    c = getContentPane();
    c.setLayout(new BorderLayout());
    ReadernoLabel = new JLabel("学号", JLabel.CENTER);
    ReadernoTextField = new JTextField(15);
    searchBtn = new JButton("查询");
    searchBtn.addActionListener(this);
    exitBtn = new JButton("退出");
    exitBtn.addActionListener(this);
    panel1 = new JPanel();//创建两个面板
    panel1.add(ReadernoLabel);//增加到面板
    panel1.add(ReadernoTextField);
    String[] name = {
        "学号","姓名", "读者种类","性别", "工作单位", "家庭住址", "电话号码", "电子邮件","登记日期","备注"};
    String[][] data = new String[0][0];
    defaultModel = new DefaultTableModel(data, name);
    table = new JTable(defaultModel);
    table.setPreferredScrollableViewportSize(new Dimension(900, 100));
    //新增一个JScrollPane对象，并将panels放入JScrollPane中，若pane1的组件大小在于窗口大小
    //大于窗口大小则会自动显示出ScrollBar.
    JScrollPane s = new JScrollPane(table);
    c.add(panel1, BorderLayout.NORTH);
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getSource() == searchBtn) {
      String strSQL =
          "select Readerno,ReaderName,ReaderType,sex,Part,Address,Telephone,Email,Intime,Com from readers";
      String strSql = null;
      if (ReadernoTextField.getText().trim().equals("") ) {
        strSql = strSQL;
      }
      try {
        //首先要删除table中的数据先：
        int rowCount = defaultModel.getRowCount() - 1; //取得table中的数据行；
        int j = rowCount;
        for (int i = 0; i <= rowCount; i++) {
          defaultModel.removeRow(j); //删除rowCount行的数据；
          defaultModel.setRowCount(j); //重新设置行数；
          j = j - 1;
        }
        rs = db.getResult(strSql);
        while (rs.next()) {
          Vector data = new Vector();
          data.addElement(rs.getString(1));
          data.addElement(rs.getString(2));
          data.addElement(rs.getString(3));
          data.addElement(rs.getString(4));
          data.addElement(rs.getString(5));
          data.addElement(rs.getString(6));
          data.addElement(rs.getString(7));
          data.addElement(rs.getString(8));
          data.addElement(rs.getString(9));
          data.addElement(rs.getString(10));
          defaultModel.addRow(data);
        }
        table.revalidate();
      }
      catch (SQLException sqle) {
        System.out.println(sqle.toString());
      }
      catch (Exception ex) {
        System.out.println(ex.toString());
      }
    }
    else if (e.getSource() == exitBtn) {
      db.closeConnection();
      this.dispose();
    }
  }
}