}
}
public DayTypePerYearOption getDayTypePerYearOption(String studyRegionId)
throws Exception {
DayTypePerYearOption dayTypePerYearOption = null;
/*
* Granted, this method does not access the study region table, but it
* was only one option and creating a new API/BO/DAO structure for it
* seemed overkill. Since it is most closely related to a StudyRegion,
* we sunk it in this DAO.
*/
try {
Connection connection = getConnection();
Statement s = connection.createStatement();
String sql = "SELECT id, regionid, activeoption, option1weekday, " +
"option2weekday, option2saturday, option2sundayholiday " +
"FROM daytypeperyearoption WHERE regionid = '"+studyRegionId+"'";
logger.debug("getDayTypePerYearOption sql=" + sql);
ResultSet r = s.executeQuery(sql);
while( r.next() ) {
dayTypePerYearOption = new DayTypePerYearOption();
dayTypePerYearOption.setId(r.getString(1));
dayTypePerYearOption.setRegionId(r.getString(2));
dayTypePerYearOption.setActiveOption(r.getString(3));
dayTypePerYearOption.setOption1weekday(r.getString(4));
dayTypePerYearOption.setOption2weekday(r.getString(5));
dayTypePerYearOption.setOption2saturday(r.getString(6));
dayTypePerYearOption.setOption2sundayHoliday(r.getString(7));
}
connection.close(); // returns connection to the pool
}
catch (SQLException e) {