package login;

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

public class MainFrame extends JFrame implements ActionListener{
	public JPanel namePwdPanel;
	public JPanel actionPanel;
	public JLabel labWelcome, labName, labPwd;
	public JTextField tfName, tfPwd;
	public JButton btnSure, btnDel, btnCancel;
	
	public static void main(String[] agrs)
	{
		System.out.println("Staring MainFrame");
		MainFrame mFrame = new MainFrame();
		mFrame.setTitle("用戶登錄");
		mFrame.setSize(200, 120);
		mFrame.setVisible(true);
	}
	
	public MainFrame(){
		labWelcome = new JLabel("歡迎使用", SwingConstants.CENTER);
		labName = new JLabel("用戶名：");
		labPwd = new JLabel("密  碼：");
		tfName = new JTextField();
		tfPwd = new JTextField();
		namePwdPanel = new JPanel();
		namePwdPanel.setLayout(new GridLayout(2, 2));
		namePwdPanel.add(labName);
		namePwdPanel.add(tfName);
		namePwdPanel.add(labPwd);
		namePwdPanel.add(tfPwd);
		
		btnSure = new JButton("確定");
		btnDel = new JButton("清除");
		btnCancel = new JButton("取消");
		actionPanel = new JPanel();
		actionPanel.setLayout(new GridLayout(1, 3));
		actionPanel.add(btnSure);
		actionPanel.add(btnDel);
		actionPanel.add(btnCancel);
		
		btnSure.addActionListener(this);
		btnDel.addActionListener(this);
		btnCancel.addActionListener(this);
		
		getContentPane().add(labWelcome, BorderLayout.NORTH);
		getContentPane().add(namePwdPanel, BorderLayout.CENTER);
		getContentPane().add(actionPanel, BorderLayout.SOUTH);
		
	}
	
	public void actionPerformed(ActionEvent e) {
		// TODO Auto-generated method stub
		if(e.getSource() == btnSure){
			try{
				String tfname = tfName.getText();
				String tfpwd = tfPwd.getText();
				String password = "";
				
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
				String url="jdbc:odbc:login"; 
				Connection connection=DriverManager.getConnection(url); 
				Statement statement = connection.createStatement(); 
				String sql = "SELECT * FROM user where name = '"+tfname+"'"; 
				ResultSet rs = statement.executeQuery(sql); 
				if(rs.next())
					password = rs.getString("password");
				if(tfpwd.equals(password)){
					ShowData dlg = new ShowData(MainFrame.this, "modelless dialog", false);
					//JOptionPane.showMessageDialog(null, "密碼正確", "Welcome", JOptionPane.YES_NO_OPTION);
				}
				else
					JOptionPane.showMessageDialog(null, "密碼不正確", "NoneWelcome", JOptionPane.YES_NO_OPTION);
				tfName.setText("");
				tfPwd.setText("");
				rs.close();
				connection.close();
			}
			catch(SQLException ex){
				System.out.println("Error Code: " + ex.getErrorCode());
				System.out.println("Message: " + ex.getMessage());
				System.exit(0);
			}
			catch(Exception ep){
				ep.printStackTrace();
			}
			
		}
		if(e.getSource() == btnDel){
			tfName.setText("");
			tfPwd.setText("");
		}
		
		if(e.getSource() == btnCancel){
			tfName.setText("");
			tfPwd.setText("");
			System.exit(0);
		}
	}
}