/* Method to display all Questions from TEST_SET_TYPE
* Returns objData
*/
public objData getAnsCategories() {
objData objdata = new objData();
try {
MainClient mc = new MainClient(DBConn.getHost());
String query = "SELECT AC_REFID, AC_CATEGORY FROM ANS_CATEGORY";
String data[] = {};
objdata.setTableData(mc.getQuery(query, data));
} catch (Exception e) {
objdata.setErrorMessage(e.toString());
objdata.setFlag(1);
}
return objdata;
}
/* Method to display all Questions from TEST_DB
* Returns objData
*/
public objData getQuestions() {
objData objdata = new objData();
try {
MainClient mc = new MainClient(DBConn.getHost());
String query = "SELECT TBD_REFID, TSDB_REFID, TDB_QNO, TDB_QUEST FROM TEST_DB";
String data[] = {};
objdata.setTableData(mc.getQuery(query, data));
} catch (Exception e) {
objdata.setErrorMessage(e.toString());
objdata.setFlag(1);
}
return objdata;
}
/* Method to display all Questions from TEST_SET_TYPE
* Returns objData
*/
public objData getTestTypes() {
objData objdata = new objData();
try {
MainClient mc = new MainClient(DBConn.getHost());
String query = "SELECT TST_REFID, TST_TYPE FROM TEST_SET_TYPE";
String data[] = {};
objdata.setTableData(mc.getQuery(query, data));
} catch (Exception e) {
objdata.setErrorMessage(e.toString());
objdata.setFlag(1);
}
return objdata;
}
/* Method to display all Answers from ANSWER_DB
* Returns objData
*/
public objData getAnswers() {
objData objdata = new objData();
try {
MainClient mc = new MainClient(DBConn.getHost());
String query = "SELECT ADB_REFID, TDB_REFID, ADB_ANS, ADB_SET_SCORE, AC_REFID FROM ANSWER_DB";
String data[] = {};
objdata.setTableData(mc.getQuery(query, data));
} catch (Exception e) {
objdata.setErrorMessage(e.toString());
objdata.setFlag(1);
}
return objdata;
}