Saving courses in database tables using JDBC

Now that we have figured out how to use the JDBC connection pool and get a connection from it, let's write the code to save a course to the database.

We will create Course Data Access Object (CourseDAO), which will have functions required to directly interact with the database. We are thus separating the code to access the database from the UI and business code.

Create package Create a class called CourseDAO in it:

package; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import; import; ...

Get Java EE 8 Development with Eclipse now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.