?? practicetest.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 fangsoft.testcenter.model.Test;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.io.IOException;
public class PracticeTest extends Test implements java.io.Serializable {
/**
*
*/
public PracticeTest() {
// TODO 自動生成構造函數存根
super();
System.out.println("java 知識測試開始!");
}
public PracticeTest(String aText) throws SQLException {
super(aText);
// TODO Auto-generated constructor stub
}
/**
* @param args
*/
public boolean generate(Connection con) throws SQLException {
PreparedStatement ps = null;
ResultSet result;
String sqlString = "select *"
+ "from question_choice where test_name='java 知識測試'";
setTest_name("java 知識測試");
ps = con.prepareStatement(sqlString);
result = ps.executeQuery(sqlString);
String QuestionText = null;
String ChoiceText = null;
String Answer;
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;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -