borlistbookfrm.java

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

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

import javax.swing.*;

class Borlistbookfrm extends JFrame implements ActionListener {
	Object a[][];
	Object colname[] = { "编号","用户", "书名", "借书时间", "还书时间", "备注", "是否归还" };
	JLabel l_name, l_bookname;
	JTextField t_name, t_bookname;
	JTable table;
	Container container;
	JButton b_enter, b_back;
	JProgressBar p_bar;
	JPanel pan1, pan2, pan3;
	String a1, a2;

	Statement s;
	ResultSet rs;

	Borlistbookfrm() {
		super("借书列表");
		l_name = new JLabel("用户名：");
		l_bookname = new JLabel("书名：");
		t_name = new JTextField("", 10);
		t_bookname = new JTextField("", 10);
		a = new Object[30][7];
		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);
		pan1 = new JPanel();
		pan2 = new JPanel();
		pan3 = new JPanel();
		pan1.add(l_name);
		pan1.add(t_name);
		pan1.add(l_bookname);
		pan1.add(t_bookname);
		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, 650, 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();
		}
		if (eb.getSource() == b_enter) {
			try {
				int i = 0;
				a1 = "'" + "%" + t_name.getText().trim() + "%" + "'";
				a2 = "'" + "%" + t_bookname.getText().trim() + "%" + "'";
				String temp = "select * from bookbrowse"
						+ " where username like " + a1
						+ " and bookname 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.getDate(4);
					a[i][4] = rs.getString(5);
					a[i][5] = rs.getString(6);
					i++;
					p_bar.setValue(i);
					
					p_bar.setString("查询到" + i + "条记录");
				}
			} catch (SQLException ed) {

			}
		}
	}
}