certtest.java

远程电子考试系统

package fangsoft.testcenter.model;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
import java.io.InputStreamReader;

import fangsoft.testcenter.model.Choice;
import fangsoft.testcenter.model.Constants;
import fangsoft.testcenter.model.Question;

public class CertTest extends Test implements java.io.Serializable {

	public CertTest() {
		// TODO Auto-generated constructor stub
		super();
		System.out.println("java web知识测试开始！");

	}

	public CertTest(String aText) throws SQLException {
		super(aText);
		// TODO Auto-generated constructor stub
	}

	public boolean generate(Connection con) throws SQLException {
		PreparedStatement ps = null;
		ResultSet result;
		String sqlString = "select *"
				+ "from question_choice where test_name='java web知识测试'";
		setTest_name("java web知识测试");
		ps = con.prepareStatement(sqlString);
		result = ps.executeQuery(sqlString);
		String QuestionText = null;
		String ChoiceText = null;
		String Answer = null;

		while (result.next()) {
			QuestionText = result.getString("question");
			Question question = new Question();
			question.setText(QuestionText);
			Choice choicea = new Choice();
			ChoiceText = result.getString("choiceA");
			choicea.setText(ChoiceText);
			question.addChoice(choicea);
			Choice choiceb = new Choice();
			ChoiceText = result.getString("choiceB");
			choiceb.setText(ChoiceText);
			question.addChoice(choiceb);
			Choice choicec = new Choice();
			ChoiceText = result.getString("choiceC");
			choicec.setText(ChoiceText);
			question.addChoice(choicec);
			Choice choiced = new Choice();
			ChoiceText = result.getString("choiceD");
			choiced.setText(ChoiceText);
			question.addChoice(choiced);
			Answer = result.getString("answer");
			question.setAnswer(Answer);
			addQuestion(question);
		}

		return true;
	}

}