findresult.java

远程电子考试系统

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);
		}
	}

}