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 the O’Reilly learning platform.

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