brbookinfo.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 BrBookinfo  extends JFrame
{
	String strurl;
	Connection conn;
	Statement stmt;
  	ResultSet rs;
  	Object  data[][]= new Object[60][9];
        Object  columnName[]={"书号","系别","出版社","书名","借出","出版日期","作者","图书分类","备注"};
  	private JPanel ContentPane;
	private JButton exit = new JButton("关闭");
	private JTable  table = new JTable(data, columnName);
	public  BrBookinfo()
    {
	 Container con = getContentPane();
	 con.setLayout(new FlowLayout());
	 this.setBounds(250,50,490,500);
	 this.setTitle("浏览所有图书信息");

	 exit.addActionListener(new ActionListener(){
            public void actionPerformed(ActionEvent e) {
                dispose();
            }
         });
	 exit.setBounds(800,500,80,30);
	 con.add(exit);
	 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 {
             Statement stmt = ConnDataBase.getConnection().createStatement();
             rs=stmt.executeQuery("Select * From Book");//显示表中的全部记录
             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){
			}
      }

}