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

import javax.swing.*;

class Userlistfrm extends JFrame implements ActionListener
{
	Object a[][]; 
	Object colname[]={"id","用戶名","密碼"};
	JTable table;
	Container container;
	JButton b_enter,b_back;
	JProgressBar p_bar;
	JPanel pan1;
	
	NetConn  sql;
	Statement sqll;
	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);
		//建立數(shù)據(jù)庫(kù)連接
		sql=new NetConn();
		//設(shè)置窗體大小
		setBounds(250,150,600,350);
	}
	public void  actionPerformed(ActionEvent eb)
	{
		//單擊返回按鈕的事件處理程序
		if(eb.getSource()==b_back)
		{
			dispose();
		}
		//單擊確定按鈕的事件處理程序
		else if(eb.getSource()==b_enter)
		{
			try
			{
				int i=0;
				sqll=sql.connect();
				//查詢所有用戶
				rs=sqll.executeQuery("select * from users");
				//循環(huán)顯示所有用戶列表
				while(rs.next())
				{
					a[i][0]=rs.getString(2);a[i][1]=rs.getString(3);a[i][2]=rs.getString(4);		
					i++;
					p_bar.setValue(i);;p_bar.setString("查詢了"+i+"條記錄");
				}
			}
			catch(SQLException ed)
			{
				
			}
		}
	}
}