com.ge.research.cmdemo.actions
Class CMDemoDataManager

java.lang.Object
  com.ge.research.cmdemo.actions.CMDemoDataManager

public class CMDemoDataManager

extends java.lang.Object

Class that manages the interface to the legacy V1 code -must be created for each user session and must persist, -is managed by the Acuity Controller for the complete session. - will maintain the v1 data structures as necessary

Version:

$Revision: 1.1 $ $Date: 2006/09/11 22:14:33 $

Author:

parkn

Created on:

Oct. 13, 2005

Field Summary

protected java.lang.String	dateFormat
protected java.lang.String	dateFormatMySql
protected java.lang.String	dateFormatYearMonth
protected java.text.DateFormat	sdf Date format object to apply to the values of the xLabelColumn (if one exists) if the datatype of the column is a date type.
protected java.text.DateFormat	sdfMySql
protected java.text.DateFormat	sdfYearMonth

Constructor Summary

CMDemoDataManager(java.lang.String userId, java.lang.String dbMySqlDriver, java.lang.String dbMySqlUrl, java.lang.String dbMySqlUser, java.lang.String dbMySqlPassword)

CMDemoDataManager(java.lang.String userId, java.lang.String year, java.lang.String semester, java.lang.String dbMySqlDriver, java.lang.String dbMySqlUrl, java.lang.String dbMySqlUser, java.lang.String dbMySqlPassword)

Method Summary

java.util.List[]	getGradeDetailsTableData(java.lang.String role, java.lang.String name, java.lang.String course, java.lang.String newYear, java.lang.String newSemester)
java.util.List[]	getRoomAssignmentTableData(java.lang.String newYear, java.lang.String newSemester)
java.util.List[]	getRoomAssignmentTableDataWithDecorator(java.lang.String newYear, java.lang.String newSemester)
java.util.List[]	getWeeklyPlannerTableData(java.lang.String role, java.lang.String name, java.lang.String newYear, java.lang.String newSemester)
void	initializeForTest(java.lang.String professor, java.lang.String studentId, java.lang.String courseId)
java.lang.String	insertCourseEnroll(java.lang.String courseInfo, java.lang.String enrollType, java.lang.String studentId)
java.lang.String	insertRoomAssignment(java.lang.String day, java.lang.String time, java.lang.String room, java.lang.String courseInfo)
java.util.ArrayList	retrieveRoomassignmentData(java.lang.String newYear, java.lang.String newSemester)
java.util.ArrayList	retrieveStudentDetailsData(java.lang.String role, java.lang.String curName, java.lang.String curCourse, java.lang.String newYear, java.lang.String newSemester)
java.util.Map	retrieveStudentGradesData(java.lang.String role, java.lang.String curName, java.lang.String curCourse)
java.util.ArrayList	retrieveWeeklyPlannerData(java.lang.String role, java.lang.String curName, java.lang.String newYear, java.lang.String newSemester)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

dateFormat

protected java.lang.String dateFormat

dateFormatMySql

protected java.lang.String dateFormatMySql

dateFormatYearMonth

protected java.lang.String dateFormatYearMonth

sdf

protected java.text.DateFormat sdf

Date format object to apply to the values of the xLabelColumn (if one exists) if the datatype of the column is a date type.

sdfMySql

protected java.text.DateFormat sdfMySql

sdfYearMonth

protected java.text.DateFormat sdfYearMonth

Constructor Detail

CMDemoDataManager

public CMDemoDataManager(java.lang.String userId,
                         java.lang.String year,
                         java.lang.String semester,
                         java.lang.String dbMySqlDriver,
                         java.lang.String dbMySqlUrl,
                         java.lang.String dbMySqlUser,
                         java.lang.String dbMySqlPassword)
                  throws java.lang.Exception

CMDemoDataManager

public CMDemoDataManager(java.lang.String userId,
                         java.lang.String dbMySqlDriver,
                         java.lang.String dbMySqlUrl,
                         java.lang.String dbMySqlUser,
                         java.lang.String dbMySqlPassword)
                  throws java.lang.Exception

Method Detail

getWeeklyPlannerTableData

public java.util.List[] getWeeklyPlannerTableData(java.lang.String role,
                                                  java.lang.String name,
                                                  java.lang.String newYear,
                                                  java.lang.String newSemester)
                                           throws java.lang.Exception

Throws:

java.lang.Exception

retrieveWeeklyPlannerData

public java.util.ArrayList retrieveWeeklyPlannerData(java.lang.String role,
                                                     java.lang.String curName,
                                                     java.lang.String newYear,
                                                     java.lang.String newSemester)
                                              throws java.lang.Exception

Throws:

java.lang.Exception

getGradeDetailsTableData

public java.util.List[] getGradeDetailsTableData(java.lang.String role,
                                                 java.lang.String name,
                                                 java.lang.String course,
                                                 java.lang.String newYear,
                                                 java.lang.String newSemester)
                                          throws java.lang.Exception

Throws:

java.lang.Exception

retrieveStudentDetailsData

public java.util.ArrayList retrieveStudentDetailsData(java.lang.String role,
                                                      java.lang.String curName,
                                                      java.lang.String curCourse,
                                                      java.lang.String newYear,
                                                      java.lang.String newSemester)
                                               throws java.lang.Exception

Throws:

java.lang.Exception

retrieveStudentGradesData

public java.util.Map retrieveStudentGradesData(java.lang.String role,
                                               java.lang.String curName,
                                               java.lang.String curCourse)
                                        throws java.lang.Exception

Throws:

java.lang.Exception

getRoomAssignmentTableData

public java.util.List[] getRoomAssignmentTableData(java.lang.String newYear,
                                                   java.lang.String newSemester)
                                            throws java.lang.Exception

Throws:

java.lang.Exception

getRoomAssignmentTableDataWithDecorator

public java.util.List[] getRoomAssignmentTableDataWithDecorator(java.lang.String newYear,
                                                                java.lang.String newSemester)
                                                         throws java.lang.Exception

Throws:

java.lang.Exception

retrieveRoomassignmentData

public java.util.ArrayList retrieveRoomassignmentData(java.lang.String newYear,
                                                      java.lang.String newSemester)
                                               throws java.lang.Exception

Throws:

java.lang.Exception

insertRoomAssignment

public java.lang.String insertRoomAssignment(java.lang.String day,
                                             java.lang.String time,
                                             java.lang.String room,
                                             java.lang.String courseInfo)
                                      throws java.lang.Exception

Throws:

java.lang.Exception

insertCourseEnroll

public java.lang.String insertCourseEnroll(java.lang.String courseInfo,
                                           java.lang.String enrollType,
                                           java.lang.String studentId)
                                    throws java.lang.Exception

Throws:

java.lang.Exception

initializeForTest

public void initializeForTest(java.lang.String professor,
                              java.lang.String studentId,
                              java.lang.String courseId)