import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
public class UserLogin extends JFrame implements ActionListener
{
	DataBaseManager db=new DataBaseManager();
	MainWindow mainFrame;
	JPanel panel1,panel2;
	JLabel UserLabel,PasswordLabel;
	JTextField UserTextField;
	JPasswordField PasswordTextField;
	JButton YesBtn,CancelBtn;
	Container c;
	ResultSet rs;
	public UserLogin(MainWindow mainFrame)
	{
		super("用戶登錄");
		this.mainFrame=mainFrame;
		UserLabel=new JLabel("用戶名",JLabel.CENTER);
		PasswordLabel=new JLabel("密碼",JLabel.CENTER);
		UserTextField=new JTextField(10);
		PasswordTextField=new JPasswordField(10);
		YesBtn=new JButton("確定");
		CancelBtn=new JButton("取消");
		YesBtn.addActionListener(this);
		CancelBtn.addActionListener(this);
		panel1=new JPanel();
                panel1.setLayout(new GridLayout(2,2));
		panel2=new JPanel();
		c=getContentPane();
		c.setLayout(new BorderLayout());
                panel1.add(UserLabel);
                panel1.add(UserTextField);
                panel1.add(PasswordLabel);
                panel1.add(PasswordTextField);
		c.add(panel1,BorderLayout.CENTER);
		panel2.add(YesBtn);
		panel2.add(CancelBtn);
		c.add(panel2,BorderLayout.SOUTH);
		setSize(300,300);
	}
	public void actionPerformed(ActionEvent e)
	{
		if(e.getSource()==CancelBtn)
		{
			mainFrame.setEnable("else");
			this.dispose();
		}
		else
		{
			char[] password=PasswordTextField.getPassword();
			String passwordSTR=new String(password);
			if(UserTextField.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"用戶名不可為空!");
				return;
			}
			if(passwordSTR.getText().trim().equals(""))
			{
				JOptionPane.showMessageDialog(null,"密碼不可為空!");
				return;
			}
			String strSQL;
			strSQL="select * from usertable where UserName='"+
			       UserTextField.getText().trim()+"'and Password='"+
			       passwordSTR+"'";
			rs=db.getResult(strSQL);
			boolean isExist=false;
			try
			{
				isExist=rs.first();
			}
			catch(SQLException sqle)
			{
				System.out.println(sqle.toString());
			}
			if(!isExist)
			{
				JOptionPane.showMessageDialog(null,"用戶名不存在或者密碼不正確!");
				mainFrame.setEnable("else");
			}
			else
			{
				try
				{
					rs.first();
					mainFrame.setEnable(rs.getString("power").trim());
					db.closeConnection();
					this.dispose();
				}
				catch(SQLException sqle2)
				{
					System.out.println(sqle2.toString());
				}
			}
			
		}
	}
}