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()andupdate(String table) - Methods representing a
WHEREclause: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.
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 alice and set the location as well. Let's the name the program QueryBuilderInsert.java:
import com.datastax.driver.core.Cluster; import com.datastax.driver.core.Session; import com.datastax.driver.core.Statement; import com.datastax.driver.core.querybuilder...