/** @return */
public List<CourseDokeosDTO> selectCourses() {
List<CourseDokeosDTO> courses = new ArrayList();
CourseDokeosDTO course;
try {
String sqlOrder =
"SELECT code, db_name, title, description, course_language, db_name FROM dokeos_main.course";
statement = connection.createStatement();
rs = statement.executeQuery(sqlOrder);
while (rs.next()) {
course = new CourseDokeosDTO();
course.setCode(rs.getString("code"));
course.setDb_name(rs.getString("db_name"));
course.setTitle(rs.getString("title"));
course.setDescription(rs.getString("description"));
courses.add(course);
}
} catch (Exception e) {
e.printStackTrace();
}
return courses;
}
/**
* @param idCourse
* @return
*/
public CourseDokeosDTO selectCourse(String idCourse) {
CourseDokeosDTO course = new CourseDokeosDTO();
try {
String sqlOrder =
"SELECT code, db_name, title, description, course_language, db_name FROM dokeos_main.course WHERE code='"
+ idCourse
+ "'";
statement = connection.createStatement();
rs = statement.executeQuery(sqlOrder);
if (rs.next()) {
course.setCode(rs.getString("code"));
course.setDb_name(rs.getString("db_name"));
course.setTitle(rs.getString("title"));
course.setDescription(rs.getString("description"));
} else {
return null;
}
} catch (Exception e) {
e.printStackTrace();
}
return course;
}