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.