If you are not familiar with Prepared Statements on MySQL have
an extra look at the source code comments and explanations in
the file examples/prepared_statement.cpp
.
sql::PreparedStatement
is created by
passing a SQL query to
sql::Connection::prepareStatement()
. As
sql::PreparedStatement
is derived from
sql::Statement
, you will feel familiar
with the API once you have learned how to use (simple)
statements (sql::Statement
). For example,
the syntax for fetching results is identical.
// ... sql::Connection *con; sql::PreparedStatement *prep_stmt // ... prep_stmt = con->prepareStatement("INSERT INTO test(id, label) VALUES (?, ?)"); prep_stmt->setInt(1, 1); prep_stmt->setString(2, "a"); prep_stmt->execute(); prep_stmt->setInt(1, 2); prep_stmt->setString(2, "b"); prep_stmt->execute(); delete prep_stmt; delete con;
As usual, you have to free
sql::PreparedStatement
and
sql::Connection
objects explicitly.
User Comments
Add your own comment.