Skip to Main Content
Java EE 8 Development with Eclipse
book

Java EE 8 Development with Eclipse

by Ram Kulkarni
June 2018
Intermediate to advanced content levelIntermediate to advanced
596 pages
12h 39m
English
Packt Publishing
Content preview from Java EE 8 Development with Eclipse

Getting courses from database tables using JDBC

We will now modify listCourses.jsp to display the courses that we have added using addCourse.jsp. However, we first need to add a method in CourseDAO to get all courses from the database.

Note that the Course table has a one-to-many relationship with Teacher. It stores the teacher ID in it. Further, the teacher ID is not a required field, so a course can exist in the Course table with null teacher_id. To get all the details of a course, we need to get the teacher for the course too. However, we cannot create a simple join in an SQL query to get the details of a course and of the teacher for each course, because a teacher may not have been set for the course. In such cases, we use the left outer ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Java EE 7: The Big Picture

Java EE 7: The Big Picture

Dr. Danny Coward
Professional Java EE Design Patterns

Professional Java EE Design Patterns

Murat Yener, Alex Theedom

Publisher Resources

ISBN: 9781788833776Supplemental Content