Package com.rit.dca.pubpaper.dao
Class DAOUtil
java.lang.Object
com.rit.dca.pubpaper.dao.DAOUtil
public class DAOUtil
extends java.lang.Object
Database Connectivity and Access
-
Field Summary
Fields Modifier and Type Field Description protected static java.lang.String
CHECK_ADMIN
protected static java.lang.String
CHECK_LOGIN
protected static java.lang.String
CHECK_USER_EXIST
protected static java.lang.String
DELETE_AFFILIATION
protected static java.lang.String
DELETE_AUTHOR_PAPERS
protected static java.lang.String
DELETE_PAPER
protected static java.lang.String
DELETE_PAPER_AUTHORS
protected static java.lang.String
DELETE_PAPER_SUBJECTS
protected static java.lang.String
DELETE_SINGLE_PAPER_AUTHOR
protected static java.lang.String
DELETE_SINGLE_PAPER_SUBJECT
protected static java.lang.String
DELETE_SUBJECT
protected static java.lang.String
DELETE_SUBJECT_PAPERS
protected static java.lang.String
DELETE_TYPE
protected static java.lang.String
DELETE_USER_PAPERS
protected static java.lang.String
DELETE_USERS
protected static java.lang.String
GET_AFFILIATION_WITH_ID
protected static java.lang.String
GET_ALL_AFFILIATIONS
protected static java.lang.String
GET_ALL_SUBJECTS
protected static java.lang.String
GET_ALL_TYPES
protected static java.lang.String
GET_ALL_USERS
protected static java.lang.String
GET_AUTHOR_PAPERS
protected static java.lang.String
GET_DISPLAY_ORDER
protected static java.lang.String
GET_LAST_AFFILIATION_ID
protected static java.lang.String
GET_LAST_SUBJECT_ID
protected static java.lang.String
GET_LAST_TYPE_ID
protected static java.lang.String
GET_NEXT_PAPER_ID
protected static java.lang.String
GET_NEXT_USER_ID
protected static java.lang.String
GET_PAPER_AUTHORS
protected static java.lang.String
GET_PAPER_SUBJECTS
protected static java.lang.String
GET_PAPER_TYPE_ID
protected static java.lang.String
GET_PAPER_TYPE_WITH_ID
protected static java.lang.String
GET_PAPER_WITH_PAPER_ID
protected static java.lang.String
GET_SINGLE_USER
protected static java.lang.String
GET_SUBJECT
protected static java.lang.String
GET_USER_AFFILIATION
protected static java.lang.String
GET_USER_PAPERS
protected static java.lang.String
HOST
protected static java.lang.String
INSERT_AFFILIATION
protected static java.lang.String
INSERT_NEW_PAPER
protected static java.lang.String
INSERT_NEW_USER
protected static java.lang.String
INSERT_PAPER_AUTHOR
protected static java.lang.String
INSERT_PAPER_SUBJECT
protected static java.lang.String
INSERT_SUBJECT
protected static java.lang.String
INSERT_TYPE
protected static java.lang.String
INSERT_UPDATE_PAPER_AUTHOR
protected static java.lang.String
INSERT_UPDATE_PAPER_SUBJECT
protected static java.lang.String
PASSWORD
protected static java.lang.String
SET_PAPER_TYPE_NULL
protected static java.lang.String
SET_USER_AFFILIATION_NULL
protected static java.lang.String
SET_USER_AS_ADMIN
protected static java.lang.String
SET_USER_CAN_REVIEW
static java.lang.String
UNABLE_TO_ADD_AFFILIATION
static java.lang.String
UNABLE_TO_ADD_PAPER_AUTHORS
static java.lang.String
UNABLE_TO_ADD_PAPER_SUBJECT
static java.lang.String
UNABLE_TO_ADD_SUBJECT
static java.lang.String
UNABLE_TO_ADD_TYPE
static java.lang.String
UNABLE_TO_CHANGE_ADMIN_STATUS
static java.lang.String
UNABLE_TO_CHANGE_AFFILIATION
static java.lang.String
UNABLE_TO_CHANGE_REVIEW_STATUS
static java.lang.String
UNABLE_TO_CHANGE_SUBJECT
static java.lang.String
UNABLE_TO_CHANGE_TYPE
static java.lang.String
UNABLE_TO_CHECK_ADMIN
static java.lang.String
UNABLE_TO_DELETE_AFFILIATION
static java.lang.String
UNABLE_TO_DELETE_AUTHOR_PAPERS
static java.lang.String
UNABLE_TO_DELETE_PAPER
static java.lang.String
UNABLE_TO_DELETE_PAPER_AUTHORS
static java.lang.String
UNABLE_TO_DELETE_PAPER_SUBJECT
static java.lang.String
UNABLE_TO_DELETE_SINGLE_PAPER_AUTHOR
static java.lang.String
UNABLE_TO_DELETE_SINGLE_PAPER_SUBJECT
static java.lang.String
UNABLE_TO_DELETE_SUBJECT
static java.lang.String
UNABLE_TO_DELETE_SUBJECT_PAPERS
static java.lang.String
UNABLE_TO_DELETE_TYPE
static java.lang.String
UNABLE_TO_DELETE_USER
static java.lang.String
UNABLE_TO_DELETE_USER_PAPER
static java.lang.String
UNABLE_TO_GET_AFFILIATION
static java.lang.String
UNABLE_TO_GET_AFFILIATIONS
static java.lang.String
UNABLE_TO_GET_ALL_USERS
static java.lang.String
UNABLE_TO_GET_AUTHOR_PAPERS
static java.lang.String
UNABLE_TO_GET_DISPLAY_ORDER
static java.lang.String
UNABLE_TO_GET_PAPER
static java.lang.String
UNABLE_TO_GET_PAPER_AUTHORS
static java.lang.String
UNABLE_TO_GET_PAPER_SUBJECTS
static java.lang.String
UNABLE_TO_GET_PAPERS
static java.lang.String
UNABLE_TO_GET_SUBJECT
static java.lang.String
UNABLE_TO_GET_SUBJECTS
static java.lang.String
UNABLE_TO_GET_TYPE
static java.lang.String
UNABLE_TO_GET_TYPES
static java.lang.String
UNABLE_TO_GET_USER
static java.lang.String
UNABLE_TO_GET_USER_PROFILE
static java.lang.String
UNABLE_TO_LOGIN
static java.lang.String
UNABLE_TO_LOGIN_TRY_LATER
static java.lang.String
UNABLE_TO_RESET_PASSWORD
static java.lang.String
UNABLE_TO_SET_PAPER
static java.lang.String
UNABLE_TO_SET_USER_PROFILE
static java.lang.String
UNABLE_TO_UPDATE_PAPER_AUTHORS
static java.lang.String
UNABLE_TO_UPDATE_PAPER_SUBJECT
protected static java.lang.String
UPDATE_AFFILIATION
protected static java.lang.String
UPDATE_PAPER
protected static java.lang.String
UPDATE_SUBJECT
protected static java.lang.String
UPDATE_TYPE
protected static java.lang.String
UPDATE_USER_PROFILE
protected static java.lang.String
USER_NAME
-
Constructor Summary
Constructors Constructor Description DAOUtil()
-
Method Summary
-
Field Details
-
USER_NAME
protected static final java.lang.String USER_NAME- See Also:
- Constant Field Values
-
PASSWORD
protected static final java.lang.String PASSWORD- See Also:
- Constant Field Values
-
HOST
protected static final java.lang.String HOST- See Also:
- Constant Field Values
-
CHECK_LOGIN
protected static final java.lang.String CHECK_LOGIN- See Also:
- Constant Field Values
-
CHECK_ADMIN
protected static final java.lang.String CHECK_ADMIN- See Also:
- Constant Field Values
-
GET_ALL_USERS
protected static final java.lang.String GET_ALL_USERS- See Also:
- Constant Field Values
-
GET_SINGLE_USER
protected static final java.lang.String GET_SINGLE_USER- See Also:
- Constant Field Values
-
DELETE_USERS
protected static final java.lang.String DELETE_USERS- See Also:
- Constant Field Values
-
CHECK_USER_EXIST
protected static final java.lang.String CHECK_USER_EXIST- See Also:
- Constant Field Values
-
UPDATE_USER_PROFILE
protected static final java.lang.String UPDATE_USER_PROFILE- See Also:
- Constant Field Values
-
INSERT_NEW_USER
protected static final java.lang.String INSERT_NEW_USER- See Also:
- Constant Field Values
-
GET_NEXT_USER_ID
protected static final java.lang.String GET_NEXT_USER_ID- See Also:
- Constant Field Values
-
SET_USER_AS_ADMIN
protected static final java.lang.String SET_USER_AS_ADMIN- See Also:
- Constant Field Values
-
SET_USER_CAN_REVIEW
protected static final java.lang.String SET_USER_CAN_REVIEW- See Also:
- Constant Field Values
-
DELETE_PAPER_AUTHORS
protected static final java.lang.String DELETE_PAPER_AUTHORS- See Also:
- Constant Field Values
-
DELETE_AUTHOR_PAPERS
protected static final java.lang.String DELETE_AUTHOR_PAPERS- See Also:
- Constant Field Values
-
DELETE_SINGLE_PAPER_AUTHOR
protected static final java.lang.String DELETE_SINGLE_PAPER_AUTHOR- See Also:
- Constant Field Values
-
GET_PAPER_AUTHORS
protected static final java.lang.String GET_PAPER_AUTHORS- See Also:
- Constant Field Values
-
GET_AUTHOR_PAPERS
protected static final java.lang.String GET_AUTHOR_PAPERS- See Also:
- Constant Field Values
-
GET_DISPLAY_ORDER
protected static final java.lang.String GET_DISPLAY_ORDER- See Also:
- Constant Field Values
-
INSERT_PAPER_AUTHOR
protected static final java.lang.String INSERT_PAPER_AUTHOR- See Also:
- Constant Field Values
-
INSERT_UPDATE_PAPER_AUTHOR
protected static final java.lang.String INSERT_UPDATE_PAPER_AUTHOR- See Also:
- Constant Field Values
-
GET_USER_PAPERS
protected static final java.lang.String GET_USER_PAPERS- See Also:
- Constant Field Values
-
GET_PAPER_WITH_PAPER_ID
protected static final java.lang.String GET_PAPER_WITH_PAPER_ID- See Also:
- Constant Field Values
-
DELETE_USER_PAPERS
protected static final java.lang.String DELETE_USER_PAPERS- See Also:
- Constant Field Values
-
UPDATE_PAPER
protected static final java.lang.String UPDATE_PAPER- See Also:
- Constant Field Values
-
DELETE_PAPER
protected static final java.lang.String DELETE_PAPER- See Also:
- Constant Field Values
-
GET_NEXT_PAPER_ID
protected static final java.lang.String GET_NEXT_PAPER_ID- See Also:
- Constant Field Values
-
INSERT_NEW_PAPER
protected static final java.lang.String INSERT_NEW_PAPER- See Also:
- Constant Field Values
-
GET_USER_AFFILIATION
protected static final java.lang.String GET_USER_AFFILIATION- See Also:
- Constant Field Values
-
GET_AFFILIATION_WITH_ID
protected static final java.lang.String GET_AFFILIATION_WITH_ID- See Also:
- Constant Field Values
-
GET_ALL_AFFILIATIONS
protected static final java.lang.String GET_ALL_AFFILIATIONS- See Also:
- Constant Field Values
-
INSERT_AFFILIATION
protected static final java.lang.String INSERT_AFFILIATION- See Also:
- Constant Field Values
-
GET_LAST_AFFILIATION_ID
protected static final java.lang.String GET_LAST_AFFILIATION_ID- See Also:
- Constant Field Values
-
DELETE_AFFILIATION
protected static final java.lang.String DELETE_AFFILIATION- See Also:
- Constant Field Values
-
SET_USER_AFFILIATION_NULL
protected static final java.lang.String SET_USER_AFFILIATION_NULL- See Also:
- Constant Field Values
-
UPDATE_AFFILIATION
protected static final java.lang.String UPDATE_AFFILIATION- See Also:
- Constant Field Values
-
GET_ALL_TYPES
protected static final java.lang.String GET_ALL_TYPES- See Also:
- Constant Field Values
-
GET_PAPER_TYPE_ID
protected static final java.lang.String GET_PAPER_TYPE_ID- See Also:
- Constant Field Values
-
GET_PAPER_TYPE_WITH_ID
protected static final java.lang.String GET_PAPER_TYPE_WITH_ID- See Also:
- Constant Field Values
-
GET_LAST_TYPE_ID
protected static final java.lang.String GET_LAST_TYPE_ID- See Also:
- Constant Field Values
-
INSERT_TYPE
protected static final java.lang.String INSERT_TYPE- See Also:
- Constant Field Values
-
DELETE_TYPE
protected static final java.lang.String DELETE_TYPE- See Also:
- Constant Field Values
-
SET_PAPER_TYPE_NULL
protected static final java.lang.String SET_PAPER_TYPE_NULL- See Also:
- Constant Field Values
-
UPDATE_TYPE
protected static final java.lang.String UPDATE_TYPE- See Also:
- Constant Field Values
-
DELETE_PAPER_SUBJECTS
protected static final java.lang.String DELETE_PAPER_SUBJECTS- See Also:
- Constant Field Values
-
DELETE_SUBJECT_PAPERS
protected static final java.lang.String DELETE_SUBJECT_PAPERS- See Also:
- Constant Field Values
-
DELETE_SINGLE_PAPER_SUBJECT
protected static final java.lang.String DELETE_SINGLE_PAPER_SUBJECT- See Also:
- Constant Field Values
-
GET_PAPER_SUBJECTS
protected static final java.lang.String GET_PAPER_SUBJECTS- See Also:
- Constant Field Values
-
INSERT_PAPER_SUBJECT
protected static final java.lang.String INSERT_PAPER_SUBJECT- See Also:
- Constant Field Values
-
INSERT_UPDATE_PAPER_SUBJECT
protected static final java.lang.String INSERT_UPDATE_PAPER_SUBJECT- See Also:
- Constant Field Values
-
GET_SUBJECT
protected static final java.lang.String GET_SUBJECT- See Also:
- Constant Field Values
-
GET_ALL_SUBJECTS
protected static final java.lang.String GET_ALL_SUBJECTS- See Also:
- Constant Field Values
-
GET_LAST_SUBJECT_ID
protected static final java.lang.String GET_LAST_SUBJECT_ID- See Also:
- Constant Field Values
-
INSERT_SUBJECT
protected static final java.lang.String INSERT_SUBJECT- See Also:
- Constant Field Values
-
DELETE_SUBJECT
protected static final java.lang.String DELETE_SUBJECT- See Also:
- Constant Field Values
-
UPDATE_SUBJECT
protected static final java.lang.String UPDATE_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_GET_TYPE
public static final java.lang.String UNABLE_TO_GET_TYPE- See Also:
- Constant Field Values
-
UNABLE_TO_GET_TYPES
public static final java.lang.String UNABLE_TO_GET_TYPES- See Also:
- Constant Field Values
-
UNABLE_TO_ADD_TYPE
public static final java.lang.String UNABLE_TO_ADD_TYPE- See Also:
- Constant Field Values
-
UNABLE_TO_CHANGE_TYPE
public static final java.lang.String UNABLE_TO_CHANGE_TYPE- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_TYPE
public static final java.lang.String UNABLE_TO_DELETE_TYPE- See Also:
- Constant Field Values
-
UNABLE_TO_GET_AFFILIATION
public static final java.lang.String UNABLE_TO_GET_AFFILIATION- See Also:
- Constant Field Values
-
UNABLE_TO_GET_AFFILIATIONS
public static final java.lang.String UNABLE_TO_GET_AFFILIATIONS- See Also:
- Constant Field Values
-
UNABLE_TO_ADD_AFFILIATION
public static final java.lang.String UNABLE_TO_ADD_AFFILIATION- See Also:
- Constant Field Values
-
UNABLE_TO_CHANGE_AFFILIATION
public static final java.lang.String UNABLE_TO_CHANGE_AFFILIATION- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_AFFILIATION
public static final java.lang.String UNABLE_TO_DELETE_AFFILIATION- See Also:
- Constant Field Values
-
UNABLE_TO_GET_SUBJECT
public static final java.lang.String UNABLE_TO_GET_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_GET_SUBJECTS
public static final java.lang.String UNABLE_TO_GET_SUBJECTS- See Also:
- Constant Field Values
-
UNABLE_TO_ADD_SUBJECT
public static final java.lang.String UNABLE_TO_ADD_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_CHANGE_SUBJECT
public static final java.lang.String UNABLE_TO_CHANGE_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_SUBJECT
public static final java.lang.String UNABLE_TO_DELETE_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_GET_PAPER_SUBJECTS
public static final java.lang.String UNABLE_TO_GET_PAPER_SUBJECTS- See Also:
- Constant Field Values
-
UNABLE_TO_ADD_PAPER_SUBJECT
public static final java.lang.String UNABLE_TO_ADD_PAPER_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_UPDATE_PAPER_SUBJECT
public static final java.lang.String UNABLE_TO_UPDATE_PAPER_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_PAPER_SUBJECT
public static final java.lang.String UNABLE_TO_DELETE_PAPER_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_SUBJECT_PAPERS
public static final java.lang.String UNABLE_TO_DELETE_SUBJECT_PAPERS- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_SINGLE_PAPER_SUBJECT
public static final java.lang.String UNABLE_TO_DELETE_SINGLE_PAPER_SUBJECT- See Also:
- Constant Field Values
-
UNABLE_TO_GET_PAPER_AUTHORS
public static final java.lang.String UNABLE_TO_GET_PAPER_AUTHORS- See Also:
- Constant Field Values
-
UNABLE_TO_GET_AUTHOR_PAPERS
public static final java.lang.String UNABLE_TO_GET_AUTHOR_PAPERS- See Also:
- Constant Field Values
-
UNABLE_TO_GET_DISPLAY_ORDER
public static final java.lang.String UNABLE_TO_GET_DISPLAY_ORDER- See Also:
- Constant Field Values
-
UNABLE_TO_ADD_PAPER_AUTHORS
public static final java.lang.String UNABLE_TO_ADD_PAPER_AUTHORS- See Also:
- Constant Field Values
-
UNABLE_TO_UPDATE_PAPER_AUTHORS
public static final java.lang.String UNABLE_TO_UPDATE_PAPER_AUTHORS- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_PAPER_AUTHORS
public static final java.lang.String UNABLE_TO_DELETE_PAPER_AUTHORS- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_AUTHOR_PAPERS
public static final java.lang.String UNABLE_TO_DELETE_AUTHOR_PAPERS- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_SINGLE_PAPER_AUTHOR
public static final java.lang.String UNABLE_TO_DELETE_SINGLE_PAPER_AUTHOR- See Also:
- Constant Field Values
-
UNABLE_TO_GET_PAPERS
public static final java.lang.String UNABLE_TO_GET_PAPERS- See Also:
- Constant Field Values
-
UNABLE_TO_GET_PAPER
public static final java.lang.String UNABLE_TO_GET_PAPER- See Also:
- Constant Field Values
-
UNABLE_TO_SET_PAPER
public static final java.lang.String UNABLE_TO_SET_PAPER- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_USER_PAPER
public static final java.lang.String UNABLE_TO_DELETE_USER_PAPER- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_PAPER
public static final java.lang.String UNABLE_TO_DELETE_PAPER- See Also:
- Constant Field Values
-
UNABLE_TO_GET_USER_PROFILE
public static final java.lang.String UNABLE_TO_GET_USER_PROFILE- See Also:
- Constant Field Values
-
UNABLE_TO_SET_USER_PROFILE
public static final java.lang.String UNABLE_TO_SET_USER_PROFILE- See Also:
- Constant Field Values
-
UNABLE_TO_RESET_PASSWORD
public static final java.lang.String UNABLE_TO_RESET_PASSWORD- See Also:
- Constant Field Values
-
UNABLE_TO_LOGIN
public static final java.lang.String UNABLE_TO_LOGIN- See Also:
- Constant Field Values
-
UNABLE_TO_LOGIN_TRY_LATER
public static final java.lang.String UNABLE_TO_LOGIN_TRY_LATER- See Also:
- Constant Field Values
-
UNABLE_TO_CHECK_ADMIN
public static final java.lang.String UNABLE_TO_CHECK_ADMIN- See Also:
- Constant Field Values
-
UNABLE_TO_GET_ALL_USERS
public static final java.lang.String UNABLE_TO_GET_ALL_USERS- See Also:
- Constant Field Values
-
UNABLE_TO_GET_USER
public static final java.lang.String UNABLE_TO_GET_USER- See Also:
- Constant Field Values
-
UNABLE_TO_DELETE_USER
public static final java.lang.String UNABLE_TO_DELETE_USER- See Also:
- Constant Field Values
-
UNABLE_TO_CHANGE_ADMIN_STATUS
public static final java.lang.String UNABLE_TO_CHANGE_ADMIN_STATUS- See Also:
- Constant Field Values
-
UNABLE_TO_CHANGE_REVIEW_STATUS
public static final java.lang.String UNABLE_TO_CHANGE_REVIEW_STATUS- See Also:
- Constant Field Values
-
-
Constructor Details
-
DAOUtil
public DAOUtil()
-