package fangsoft.testcenter.driver;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import dbconnect.DbConnect;
import fangsoft.testcenter.model.Customer;

import java.io.BufferedReader;
import java.io.IOException;
import java.io.InputStreamReader;

public class FindExactResult {

	/**
	 * @param args
	 * @throws IOException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws IOException, SQLException {
		// TODO 自動生成方法存根
		DbConnect dbcon=new DbConnect();
		dbcon.connect();
		BufferedReader reader = new BufferedReader(new InputStreamReader(
				System.in));
		String s = null;
		System.out.println("是否查詢你的詳細考試記錄?");
		System.out.println("1.是:y\n2.否:n");
		s = reader.readLine();
		if ("y".equalsIgnoreCase(s)) {
			Statement stmt;
			stmt = (dbcon.getConnction()).createStatement();
			BufferedReader br = new BufferedReader(new InputStreamReader(
					System.in));
			int count = 0;
			String userId = null, password;
			int MAX_RETRIES = 3;
			//String dt = null;
			for (count = 0; count < MAX_RETRIES; count++) {
				System.out.println("輸入用戶名稱：");
				userId = br.readLine();
				System.out.println("輸入用戶密碼：");
				password = br.readLine();

				if (Customer.login(userId, password, dbcon.getConnction())) {
					break;
				}
				System.out.println("用戶名或密碼錯誤不能登錄,重新登錄." + "登錄" + MAX_RETRIES
						+ "次不成功，系統將退出." + "這是" + (count + 1) + "次");
			}
			if (count == MAX_RETRIES) {
				System.out.println("登錄" + MAX_RETRIES + "次不成功，系統退出");
				System.exit(0);
			}
			//dt = getInput("請輸入考試時間：");
			ResultSet check = stmt
					.executeQuery("select * from EXACTRESULT where customer_name = '" + userId
							+ "'");// 執行查詢
			System.out.println("時間\t題號\t答案\t正確答案\t判斷");
			while (check.next()) {// 判斷是否存在查詢結構
				System.out.print(check.getString("date_time"));
				System.out.print("\t"+check.getString("question_no"));
				System.out.print("\t" + check.getString("answer"));
				System.out.print("\t" + check.getString("correct_answer"));
				System.out.println("\t" + check.getString("judge"));
				
			}
			check.close();
		} else {
			System.out.println("系統退出");
			System.exit(0);
		}
	}
	public static String getInput(String msg) {
		String result = null;
		try {
			// 創建用戶輸入流
			BufferedReader in = new BufferedReader(new InputStreamReader(
					System.in));
			System.out.print(msg);
			result = in.readLine();
		} catch (IOException e) {
			e.printStackTrace();
		}
		return result;
	}

}