需要处理里面有引号的名称

Question

我有两个查询可以插入和更新数据库-

insertSQL = "insert into LineManager(LINEMANAGERID,LINEMANAGERNAME,BUSINESSGROUPID,STATUS) VALUES('" + lineManager.getLineManagerID() + "','" + lineManager.getLineManagerName() + "','" + lineManager.getBusinessGroupID() + "','" + lineManager.getStatus() + "')";
updateSQL = "update LineManager set BUSINESSGROUPID ='" + lineManager.getBusinessGroupID() + "' , LINEMANAGERNAME ='" + lineManager.getLineManagerName() + "' , STATUS ='" + lineManager.getStatus() + "' where LINEMANAGERID='" + lineManager.getLineManagerID() + "'";

到目前为止，它对于常规名称工作正常，但是当LineManager名称像"Doko N'dah，Dominick先生"时，它就面临问题。它在执行过程中引发异常。

任何人都可以帮助解决这个问题吗？

Answer 1

使用绑定变量：

QSqlQuery query;
query.prepare("insert into LineManager(LINEMANAGERID,LINEMANAGERNAME,BUSINESSGROUPID,STATUS) VALUES(:id,:name,:groupid:status)");
query.bindValue( ":id",      lineManager.getLineManagerID() );
query.bindValue( ":name",    lineManager.getLineManagerName() );
query.bindValue( ":groupid", lineManager.getBusinessGroupID() );
query.bindValue( ":status",  lineManager.getStatus() );
query.exec();