public static Vector<FinancialPredictionTask> getAllFinancialPredictionTaskItems(
String script_name) throws SQLException, NamingException {
DBConnection dbConn = new DBConnection();
String SQL = "SELECT * FROM prediction_tasks ORDER BY date_run DESC";
dbConn.executeGetResultSetSQL(SQL);
Vector<FinancialPredictionTask> resultList = null;
if (dbConn.rs != null) resultList = convertRStoFinancialPredictionTaskItems(dbConn.rs);
dbConn.closeConnection();
return resultList;
}
public static Vector<FinancialPredictionPerformanceItem>
convertRStoFinancialPredictionPerformanceItemsForTask(int prediction_task_id)
throws SQLException, NamingException {
DBConnection dbConn = new DBConnection();
String SQL =
"SELECT * FROM prediction_performance_data WHERE prediction_task_id = '"
+ prediction_task_id
+ "' ORDER BY date DESC";
dbConn.executeGetResultSetSQL(SQL);
Vector<FinancialPredictionPerformanceItem> resultList = null;
if (dbConn.rs != null) resultList = convertRStoFinancialPredictionPerformanceItems(dbConn.rs);
dbConn.closeConnection();
return resultList;
}