userlistfrm.java

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

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

import javax.swing.*;

class Userlistfrm extends JFrame implements ActionListener {
	Object a[][];
	Object colname[] = { "用户名", "密码", "级别" };
	JTable table;
	Container container;
	JButton b_enter, b_back;
	JProgressBar p_bar;
	JPanel pan1;

	Statement s;
	ResultSet rs;

	Userlistfrm() {
		super("用户列表");
		a = new Object[30][3];
		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();
		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(250, 150, 600, 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;
				rs = s.executeQuery("select * from users");
				while (rs.next()) {
					a[i][0] = rs.getString(1);
					a[i][1] = rs.getString(2);
					a[i][2] = rs.getString(3);
					i++;
					p_bar.setValue(i);
					;
					p_bar.setString("查询到" + i + "条记录");
				}
			} catch (SQLException ed) {

			}
		}
	}
}