package fangsoft.testcenter.driver;

import java.sql.PreparedStatement;
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 FindResult {

	/**
	 * @param args
	 * @throws SQLException 
	 * @throws IOException 
	 */
	public static void main(String[] args) throws SQLException, IOException {
		// 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;
			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);
			}
			ResultSet check = stmt
					.executeQuery("select * from RESULT where Name = '" + userId
							+ "'");// 執行查詢
			System.out.println("用戶名\t\t\t時間\t\t分數\t試卷名稱\t\t\t錯\t對");
			while (check.next()) {// 判斷是否存在查詢結構
				System.out.print(check.getString("Name"));
				System.out.print("\t" + check.getString("DateTime"));
				System.out.print("\t" + check.getString("Mark"));
				System.out.print("\t" + check.getString("TEST_NAME"));
				System.out.print("\t" + check.getString("Right"));
				System.out.println("\t" + check.getString("Wrong"));
				
			}
			check.close();
		} else {
			System.out.println("系統退出");
			System.exit(0);
		}
	}

}