import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.DateFormat;
import java.util.Calendar;
import javax.swing.*;

public class LoginPanel {
	static JComboBox JCB = new JComboBox();

	static JTextField card_number_text = new JTextField(15);

	static JTextField password_text = new JTextField(15);

	static JTextField time_text = new JTextField(15);

	static Calendar beginTime = Calendar.getInstance();

	static Calendar endTime = Calendar.getInstance();

	public static Object getSelectedComputer() {// 獲得當前所選擇的機子號碼
		return JCB.getSelectedItem();
	}

	public static String getCard_Number() {// 獲得當前所輸入的卡號
		return card_number_text.getText();
	}

	public static String getPassword() {// 獲得當前所輸入的密碼
		return password_text.getText();
	}

	public static Calendar getBeginTime() {
		return beginTime;// 獲得開始上機的時間
	}
}

class Listener_subit implements ActionListener {
	public void actionPerformed(ActionEvent e) {
		ResultSet rs0, rs1, rs2, rs3;
		try {
			rs0 = DataBase.getInstance()
					.select(
							"select card_number from card where card_number='"
									+ LoginPanel.getCard_Number()
									+ "' and used = true");
			rs1 = DataBase.getInstance().select(
					"select card_number from card where card_number='"
							+ LoginPanel.getCard_Number() + "'");
			rs2 = DataBase.getInstance().select(
					"select * from card where card_number='"
							+ LoginPanel.getCard_Number() + "'"
							+ " and card_password='" + LoginPanel.getPassword()
							+ "'");
			rs3 = DataBase.getInstance().select(
					"select computer_number from computer where enable = true");
			if (rs0.next()) {
				JOptionPane.showMessageDialog(null, "很抱歉這樣的卡號已經有人在使用",
						"ERROR", JOptionPane.ERROR_MESSAGE);
				return;
			}
			if (!rs1.next() || !rs2.next()) {
				JOptionPane.showMessageDialog(null, "很抱歉沒有這樣的卡號或您的密碼輸入有誤",
						"ERROR", JOptionPane.ERROR_MESSAGE);

			}
			if (!rs3.next()) {
				JOptionPane.showMessageDialog(null, "很抱歉機子已經滿了,請過后使用", "ERROR",
						JOptionPane.ERROR_MESSAGE);

			}
			rs2.previous();
			rs3.previous();
			if (rs2.next() && rs3.next()) {
				try {
					JOptionPane.showMessageDialog(null, "登錄成功現在開始計時", "登錄成功",
							JOptionPane.PLAIN_MESSAGE);
					DataBase.getInstance().update(
							"UPDATE computer set enable=false where computer_number="
									+ LoginPanel.getSelectedComputer());
					LoginPanel.beginTime = Calendar.getInstance();
					DataBase.getInstance().update(
							"UPDATE card set used = true where card_number='"
									+ LoginPanel.getCard_Number() + "'");
					MainFrame.f.getContentPane().removeAll();
					MainFrame.f.getContentPane().add(new JLabel("現在正處于上機狀態",JLabel.CENTER));
					MainFrame.f.setVisible(true);
				} catch (SQLException e1) {
					e1.printStackTrace();
				}

			}

		} catch (SQLException e2) {
			e2.printStackTrace();
		}

	}
}

class Listener_reset implements ActionListener {
	public void actionPerformed(ActionEvent e_reset) {
		 LoginPanel.password_text.setText("");
		 LoginPanel.card_number_text.setText("");
		 LoginPanel.beginTime = Calendar.getInstance();
		 LoginPanel.time_text.setText(DateFormat.getDateTimeInstance().format(
		 LoginPanel.beginTime.getTime()));
	}
}