c++ - 如何使用qt将数据插入到sqlite中

Question

如何使用qt将数据插入sqlite:

query = QSqlQuery("INSERT INTO customer_details (rationcard_num, aadharcard_num, name) 
    values('"+rationcard_num+"','"+aadharcard_num+"','"+name+"')");

Answer 1

您可以修改您的代码并使查询看起来像这样，我认为这将澄清您的疑虑:

准备查询语句

QSqlQuery query;
query.prepare("INSERT INTO customer_details(rationcard_num \
                 , aadharcard_num \
                 , name) \ 
                 VALUES(:rationcard_num \
                 , :aadharcard_num \
                 , :name); ");

绑定(bind)值

query.bindValue(":rationcard_num", your_value);
query.bindValue(":aadharcard_num", your_value);
query.bindValue(":name", your_value);

调试

您可以使用 qDebug() 来查找您的查询是否可执行:

qDebug()<<query.exec()<<endl;

如果插入数据则返回真，否则返回假