qt在执行sql语句是报QSqlError("", "Parameter count mismatch", "")错误

Question

qt在执行sql语句是报QSqlError("", "Parameter count mismatch", "")错误，检查语句和参数应该都没问题？不知道有没有大神遇到过类似的情况？

语句: insert into personal (role, name, number, password, gender, college, major, classes, phone, remarks, created_at, updated_at) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

绑定参数个数也是对的

Answer 1

用prepare+bindValue的话，后面exec的时候就不要再带参数了，直接query.exec()