/**
* Find job in table 'jobs'. Get values of all fields in searched record. Create object of 'Job'
* class by these values.
*
* @param jobId - id number of need job.
* @return object of Job class.
*/
protected Job createJobById(int jobId) {
ResultSet resultSet = null;
try {
resultSet = find("jobs", Job.JOB_ID, jobId); // find record by id
resultSet.first();
// Getting values of fields.
int id = (int) resultSet.getObject(Job.JOB_ID);
String name = String.valueOf(resultSet.getObject(Job.JOB_NAME));
String description = String.valueOf(resultSet.getObject(Job.DESCRIPTION));
int percents = (int) resultSet.getObject(Job.PERCENTS);
Date beginDate = (Date) resultSet.getObject(Job.BEGIN_DATE);
Date endDate = (Date) resultSet.getObject(Job.END_DATE);
Status status = createStatusById((int) resultSet.getObject(Job.STATUS_ID));
Priority priority = createPriorityById((int) resultSet.getObject(Job.PRIORITY_ID));
User worker = createUserById((int) resultSet.getObject(Job.WORKER_ID));
User manager = createUserById((int) resultSet.getObject(Job.MANAGER_ID));
// Create object of Job class by values.
return new Job(
id, name, description, percents, beginDate, endDate, status, priority, worker, manager);
} catch (SQLException exception) {
logger.getExceptionTextFileLogger().error(exception);
return null;
}
}
/**
* Find field by its name in result set.
*
* @param resultSet - result set for searching (must be one record).
* @param fieldName - field name, which value need to search.
* @return - value of field.
*/
protected Object findField(ResultSet resultSet, String fieldName) {
try {
resultSet.first();
return resultSet.getObject(fieldName);
} catch (SQLException e) {
logger.getExceptionTextFileLogger().error(e);
return null;
}
}
/**
* Find record in table 'priorities' by id number. Getting values form result set. Create object
* of Priority class by values.
*
* @param priorityId
* @return object of Priority class.
*/
protected Priority createPriorityById(int priorityId) {
ResultSet resultSet = null;
try {
resultSet = find("priorities", Priority.PRIORITY_ID, priorityId);
resultSet.first();
int id = (int) resultSet.getObject(Priority.PRIORITY_ID);
String priority = String.valueOf(resultSet.getObject(Priority.PRIORITY));
return new Priority(id, priority);
} catch (SQLException exception) {
logger.getExceptionTextFileLogger().error(exception);
return null;
}
}
/**
* Find records in data base by table and set of conditions.
*
* @param tableName - name of table in which record will be search.
* @param values - set of conditions for searching.
* @return
*/
protected ResultSet find(String tableName, Object... values) {
DataBaseReader dataBaseReader = new DataBaseReader();
ResultSet resultSet = null;
try {
resultSet = (ResultSet) dataBaseReader.select(tableName, values);
if (resultSet != null) {
if (resultSet.next()) {
resultSet.beforeFirst();
return resultSet;
}
} else {
return null;
}
} catch (SQLException exception) {
logger.getExceptionTextFileLogger().error(exception);
}
return null;
}
/**
* Find records in data base by table name, field name and field value.
*
* @param tableName - table name.
* @param fieldName - field name.
* @param fieldValue - field value as string.
* @return result set of searching.
*/
protected ResultSet find(String tableName, String fieldName, String fieldValue) {
DataBaseReader dataBaseReader = new DataBaseReader();
String query = null;
ResultSet resultSet = null;
try {
query = String.format("SELECT * FROM %s WHERE %s = '%s';", tableName, fieldName, fieldValue);
resultSet = (ResultSet) dataBaseReader.select(query);
if (resultSet != null) {
if (resultSet.next()) {
resultSet.beforeFirst();
return resultSet;
}
} else {
return null;
}
} catch (SQLException exception) {
logger.getExceptionTextFileLogger().error(exception);
}
return null;
}
/**
* Find user in table 'users' by its id number. Get values of all fields in searching record.
* Create object of User class by these values.
*
* @param userId - id number of need user.
* @return object of User class.
*/
protected User createUserById(int userId) {
ResultSet resultSet = null;
try {
resultSet = find("users", User.USER_ID, userId); // find user by id
resultSet.first();
// Getting values of fields and converting to need type.
int id = (int) resultSet.getObject(User.USER_ID);
String login = String.valueOf(resultSet.getObject(User.LOGIN));
String name = String.valueOf(resultSet.getObject(User.USER_NAME));
String surname = String.valueOf(resultSet.getObject(User.SURNAME));
String password = String.valueOf(resultSet.getObject(User.PASSWORD));
String email = String.valueOf(resultSet.getObject(User.EMAIL));
Position position = createPositionById((int) resultSet.getObject(User.POSITION_ID));
// Create user object by these values.
return new User(id, login, name, surname, password, email, position);
} catch (SQLException exception) {
logger.getExceptionTextFileLogger().error(exception);
return null;
}
}