brreaderinfo.java

基于目前许多中小型公司, 机关,中小学校,大学院系等都有自己的图书库, 供内部人员借阅。传统的手工登记办法

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package libsystem;

/**
 *  浏览所有读者信息
 * @author admin
 */
import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;

public class BrReaderInfo  extends JFrame
{
	private Statement stmt;
  	private ResultSet rs;
  	private Object  data[][]= new Object[60][9];//表数据
        private Object  columnName[]={"学号","系别","专业","姓名","性别","出生日期","籍贯","政治面貌","备注"};
  	private JPanel panel;
	private JButton closebut = new JButton("关闭");
	private JTable  table = new JTable(data, columnName);//构造一个显示二维表数据,及一维列名的表格
	public  BrReaderInfo()
    {
	 Container con = getContentPane();
	 con.setLayout(new FlowLayout());
	 this.setBounds(250,50,490,500);
	 this.setTitle("浏览所有读者信息");

	 closebut.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e) {
                dispose();
            }
         });
	 closebut.setBounds(800,500,80,30);
	 con.add(closebut);
	 con.add(table);
	 Container container = getContentPane(); //创建一个面板
     container.add(new JScrollPane(table),FlowLayout.LEFT); //添加滚动窗口到面板上
     this.setVisible(true); //设里窗体可见
     this.validate();

     //显示全部信息
      int i = 0;
        while(i>=0) {   //清空上次查询结果
          data[i][0] = "";
          data[i][1] = "";
          data[i][2] = "";
          data[i][3] = "";
          data[i][4] = "";
          data[i][5] = "";
          data[i][6] = "";
          data[i][7] = "";
          data[i][8] = "";
          i--;
        }
        repaint();
        i = 0;
        try {
             stmt = ConnDataBase.getConnection().createStatement();
             rs=stmt.executeQuery("Select * From Reader");//显示表中的全部记录
             while(rs.next())
             {  //处理查询过程
             data[i][0] = rs.getString("学号");//从数据库表中取出一个记录的学号字段
             data[i][1] = rs.getString("系别");
             data[i][2] = rs.getString("专业");
             data[i][3] = rs.getString("姓名");
             data[i][4] = rs.getString("性别");
             data[i][5] = rs.getString("出生日期");
             data[i][6] = rs.getString("籍贯");
             data[i][7] = rs.getString("政治面貌");
             data[i][8] = rs.getString("备注");
             i++;//统计
             }
	        }
        catch(Exception e1){
			}
      }

}