Query builder in clause to prepared statement

Question

I want to change following query to prepared statement :

QueryBuilder.select().column(id).from(studentTable).where(QueryBuilder.in(id,List)).

I know noramlly this query can be written as :

select id from studentTable where id = ?

How the same can be achieved by querybuilder ?

Possible duplicate of [PreparedStatement IN clause alternatives?](https://stackoverflow.com/questions/178479/preparedstatement-in-clause-alternatives) — amicoderozer, Jun 01 '18 at 10:03
Possible duplicate of https://stackoverflow.com/questions/16918853/prepared-statement-with-collection-in-in-clause-in-datastax-cassandra-cql-driver — mallikarjun, Jun 01 '18 at 10:07

score 1 · Answer 1 · answered Jun 01 '18 at 10:56

To achieve this with QueryBuilder you need to call the bindMarker(), or bindMarker("name")... See corresponding Javadocs (example is from it):

Insert i = QueryBuilder.insertInto("test").value("k", 0)
                       .value("c", QueryBuilder.bindMarker());
PreparedStatement p = session.prepare(i.toString());

Query builder in clause to prepared statement

1 Answers1