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

import javax.swing.*;

class putong extends JFrame implements ActionListener {
	Object a[][];
	Object colname[] = { "編號", "用戶", "書名", "借書時間", "還書時間", "備注", "是否歸還" };
	JLabel l_name, l_password;
	JTextField t_name;
	JPasswordField t_pass;
	JTable table;
	Container container;
	JButton b_enter, b_back;
	JProgressBar p_bar;
	JPanel pan1, pan2, pan3;
	String a1, a2, a3, a4, sname, spass;
	int k;

	Statement s;
	ResultSet rs;
	int i,j;

	putong() {
		super("借書列表");
		l_name = new JLabel("用戶名：");
		l_password = new JLabel("密碼：");
		t_name = new JTextField("", 10);
		t_pass = new JPasswordField("", 10);
		t_pass.setEchoChar('*');
		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_password);
		pan1.add(t_pass);
		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) {
			for(i=0;i<30;i++)
				for(j=0;j<7;j++)
					table.setValueAt(null, i, j);
			try {
				int i = 0;
				a1 = t_name.getText();
				a2 = t_pass.getText();
				String temp = "select * from users,bookbrowse where bookbrowse.username="+"'"+a1+"'";
				rs = s.executeQuery(temp);
				while (rs.next()) {
					sname = rs.getString("username");
					spass = rs.getString("password");
					System.out.println("ussername is:" + sname);
					if (a1.equals(sname) && a2.equals(spass)) {						
							a[i][0] = rs.getString(4);
							a[i][1] = rs.getString(5);
							a[i][2] = rs.getString(6);
							a[i][3] = rs.getDate(7);
							a[i][4] = rs.getDate(8);
							a[i][5] = rs.getString(9);
							a[i][6] = rs.getString(10);
							i++;
							p_bar.setValue(i);
							;
							p_bar.setString("查詢到" + i + "條記錄");
							k=1;
						
					}
				}
				if(k!=1) 
					JOptionPane.showMessageDialog(this, "輸入密碼錯誤或該用戶不存在");
			} catch (SQLException ed) {

			}

		}
	}
}