Java EE 8 Development with Eclipse

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 packt.book.jee.eclipse.ch4.dao. Create a class called CourseDAO in it:

package packt.book.jee.eclipse.ch4.dao; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import packt.book.jee.eclipse.ch4.bean.Course; import packt.book.jee.eclipse.ch4.db.connection.DatabaseConnectionFactory; ...