booklistfrm.java

用Java实现的图书馆的管理系统

import java.awt.*;
import java.awt.event.*;
import java.sql.*;

import javax.swing.*;

class Booklistfrm extends JFrame implements ActionListener {
	Object a[][];
	Object colname[] = { "编号","书名", "出版社", "作者", "出版日期", "价格", "新书数量", "类型" };
	JLabel l_bookid,l_name, l_author, l_company;
	JTextField t_bookid,t_name, t_author, t_company;
	JTable table;
	Container container;
	JButton b_enter, b_back;
	JProgressBar p_bar;
	JPanel pan1;
	String a0,a1, a2, a3;

	Statement s;
	ResultSet rs;

	Booklistfrm() {
		super("书籍查询");
		l_bookid=new JLabel("编号：");
		l_name = new JLabel("书名：");
		l_author = new JLabel("作者：");
		l_company = new JLabel("出版社：");
		t_bookid=new JTextField("",10);
		t_name = new JTextField("", 10);
		t_author = new JTextField("", 10);
		t_company = new JTextField("", 10);
		a = new Object[30][8];
		table = new JTable(a, colname);
		setSize(300, 300);
		setVisible(true);
		b_enter = new JButton("确定");
		b_back = new JButton("返回");
		b_enter.addActionListener(this);
		b_back.addActionListener(this);
		b_enter.addActionListener(this);
		b_back.addActionListener(this);
		pan1 = new JPanel();
		pan1.add(l_bookid);
		pan1.add(t_bookid);
		pan1.add(l_name);
		pan1.add(t_name);
		pan1.add(l_author);
		pan1.add(t_author);
		pan1.add(l_company);
		pan1.add(t_company);
		pan1.add(b_enter);
		pan1.add(b_back);

		p_bar = new JProgressBar(JProgressBar.VERTICAL, 0, 50);
		p_bar.setStringPainted(true);
		container = getContentPane();
		container.add(pan1, BorderLayout.SOUTH);
		container.add(new JScrollPane(table), BorderLayout.CENTER);
		container.add(p_bar, BorderLayout.WEST);
		setBounds(230, 150, 850, 350);
	}

	public void actionPerformed(ActionEvent eb) {
		String JDriver = "sun.Jdbc.Odbc.JdbcOdbcDriver";
		String conURL = "jdbc:odbc:abc";
		try {
			Class.forName(JDriver);
		} catch (java.lang.ClassNotFoundException e1) {
			System.out.println("forname:" + e1.getMessage());
		}
		try {
			Connection con = DriverManager.getConnection(conURL);
			s = con.createStatement();
		} catch (SQLException e1) {
			System.out.println("SQLException:" + e1.getMessage());
		}
		if (eb.getSource() == b_back) {
			dispose();
		} else if (eb.getSource() == b_enter) {
			try {
				int i = 0;
				a0 = "'" + "%" + t_bookid.getText().trim() + "%" + "'";
				a1 = "'" + "%" + t_name.getText().trim() + "%" + "'";
				a2 = "'" + "%" + t_author.getText().trim() + "%" + "'";
				a3 = "'" + "%" + t_company.getText().trim() + "%" + "'";
				String temp = "select * from books" + " where bookid like " +a0+" and bookname like "
						+ a1 + " and company like " + a3 + " and author like "+ a2;
						
				rs = s.executeQuery(temp);
				while (rs.next()) {
					a[i][0] = rs.getString(1);
					a[i][1] = rs.getString(2);
					a[i][2] = rs.getString(3);
					a[i][3] = rs.getString(4);
					a[i][4] = rs.getString(5);
					a[i][5] = rs.getString(6);
					a[i][6] = rs.getString(7);
					a[i][7] = rs.getString(8);
					i++;
					p_bar.setValue(i);
					p_bar.setString("查询到" + i + "条记录");
				}
			} catch (SQLException ed) {

			}
		}
	}
}