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