QT中SELECT语句中能加参数变量吗？ [复制链接]

能否这样：
QSqlQuery cmd;
QString strcmd = "select yyqybm,xxbm,xxzt,ms from xtxx where yyqybm=@yyqybm"
cmd.prepare(strcmd);
cmd.bindValue("@yyqybm",KeyWord);
cmd.exec();

请问这种形式的写法应该怎么写？

参照
     QSqlQuery query;
     query.prepare("INSERT INTO person (id, forename, surname) "
                   "VALUES (:id, :forename, :surname)");
     query.bindValue(":id", 1001);
     query.bindValue(":forename", "Bart");
     query.bindValue(":surname", "Simpson");
     query.exec();