prepared-statement - Cassandra中的准备语句与绑定(bind)语句？

Question

我想知道使用 BoundStatement 有什么好处？超过 PreparedStatement ?

PreparedStatement statement = session.prepare(
                      "INSERT INTO simplex.songs " +
                      "(id, title, album, artist) " +
                      "VALUES (?, ?, ?, ?);");

BoundStatement boundStatement = new BoundStatement(statement);
            session.execute(boundStatement.bind(
                  UUID.fromString("756716f7-2e54-4715-9f00-91debea6cf50"),
                  "La Petite Tonkinoise",
                  "Bye Bye Blackbird",
                  "Joséphine Baker");

最简单的方法是:

PreparedStatement ps = session.prepare(
                      "INSERT INTO simplex.songs " +
                      "(id, title, album, artist, tags) " +
                      "VALUES (?, ?, ?, ?, ?);");
ps.bind(UUID.fromString("756716f7-2e54-4715-9f00-91debea6cf50"),
                      "La Petite Tonkinoise",
                      "Bye Bye Blackbird",
                      "Joséphine Baker");

如您所见，我可以将数据绑定(bind)到 preparedStatement没有 boundStatements . boundStatement 在哪里有用？

Answer 1

没有优势:BoundStatement 只不过是一个有界变量的 PreparedStatement。 bind() PreparedStatements 的方法，实际上返回一个BoundStatement。