Class Retriever

java.lang.Object
  |
  +--Retriever

public class Retriever

extends java.lang.Object

This class is to be used from all other classes to execute SQL statements on the database. This class uses the MyConnection class to establish the database connection

Constructor Summary

Retriever()

Method Summary

static java.sql.ResultSet	executeSQL(java.lang.String sql) Executes sql statements.
static java.sql.ResultSet	p_get_all_with_level(java.lang.String level, java.lang.String discipline) Returns all courses from a specific discipline.
static java.sql.ResultSet	p_get_liberal_arts() Returns all courses considered liberal arts.
static java.sql.ResultSet	p_getCollegeWide() Returns College-wide requirements.
static java.sql.ResultSet	p_getCore() Returns Core requirements.
static java.lang.String	p_getCoreq(java.lang.String course) Returns Expression with corequisite requirements.
static java.lang.String	p_getCourseCode(java.lang.String course) Returns the course code for example CSC175.
static int	p_getCredits(java.lang.String course) Returns credits for a specific course.
static java.sql.ResultSet	p_getGeneral() Returns General requirements.
static int	p_getLiberalArt_req_credits(java.lang.String major)
static java.sql.ResultSet	p_getMajor(java.lang.String major_id) Returns requirements for the major.
static java.lang.String	p_getMajorName(java.lang.String major) Returns the title of a specific major.
static java.sql.ResultSet	p_getMinor(java.lang.String minor_id) Returns requirements for the minor.
static java.lang.String	p_getMinorName(java.lang.String minor) Returns the title of a specific minor.
static java.lang.String	p_getName(java.lang.String course) Returns the name of a specific course.
static java.lang.String	p_getPrereq(java.lang.String course) Returns Expression with prerequisite requirements.
static int	p_getTotalCredits(java.lang.String major) Returns requirements for total credits completed before graduation.
static int	p_getTransferCore(java.lang.String tran_credits) Returns Core requirements for transfer students.

Methods inherited from class java.lang.Object

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

Constructor Detail

Retriever

public Retriever()

Method Detail

executeSQL

public static java.sql.ResultSet executeSQL(java.lang.String sql)

Executes sql statements.

p_getMajor

public static java.sql.ResultSet p_getMajor(java.lang.String major_id)

Returns requirements for the major.

p_getMinor

public static java.sql.ResultSet p_getMinor(java.lang.String minor_id)

Returns requirements for the minor.

p_getCore

public static java.sql.ResultSet p_getCore()

Returns Core requirements.

p_getTransferCore

public static int p_getTransferCore(java.lang.String tran_credits)

Returns Core requirements for transfer students.

p_getCollegeWide

public static java.sql.ResultSet p_getCollegeWide()

Returns College-wide requirements.

p_getGeneral

public static java.sql.ResultSet p_getGeneral()

Returns General requirements.

p_getName

public static java.lang.String p_getName(java.lang.String course)

Returns the name of a specific course.

p_getMajorName

public static java.lang.String p_getMajorName(java.lang.String major)

Returns the title of a specific major.

p_getMinorName

public static java.lang.String p_getMinorName(java.lang.String minor)

Returns the title of a specific minor.

p_getCourseCode

public static java.lang.String p_getCourseCode(java.lang.String course)

Returns the course code for example CSC175.

p_getPrereq

public static java.lang.String p_getPrereq(java.lang.String course)

Returns Expression with prerequisite requirements.

p_getCoreq

public static java.lang.String p_getCoreq(java.lang.String course)

Returns Expression with corequisite requirements.

p_getCredits

public static int p_getCredits(java.lang.String course)

Returns credits for a specific course.

p_get_liberal_arts

public static java.sql.ResultSet p_get_liberal_arts()

Returns all courses considered liberal arts.

p_get_all_with_level

public static java.sql.ResultSet p_get_all_with_level(java.lang.String level,
                                                      java.lang.String discipline)

Returns all courses from a specific discipline. Can discriminate between upper and lower level.

p_getLiberalArt_req_credits

public static int p_getLiberalArt_req_credits(java.lang.String major)

p_getTotalCredits

public static int p_getTotalCredits(java.lang.String major)

Returns requirements for total credits completed before graduation.