QueryBuilder API

QueryBuilder API provides another way to execute queries without using prepared statements. QueryBuilder has many methods to help generate dynamic queries. Some of these methods are as follows:

• Methods to select/insert/update/delete: select() and update(String table)
• Methods representing a WHERE clause: eq(String name, Object value)
• Methods representing an assignment: set(String name, Object value)

We will look at the QueryBuilder API to build the INSERT, UPDATE, and SELECT statements.

Building an INSERT statement

First, let's write a program, which uses the QueryBuilder API to build an INSERT statement and execute it. Then, we will walk through each method used in the program. To demonstrate this, we will update the email of user...