QT 中为何无法将QString数据写入到QSQLite中,是不是格式错了?
主要程序如下:
QString djs = "hsoahddshk";
QSqlQuery query;
query.exec("DROP TABLE shuju");
query.exec("CREATE TABLE shuju ("
"id INTEGER PRIMARY KEY, "
"wdata1 text NOT NULL, "
"wdata2 VARCHAR(40) NOT NULL, "
"sdata1 VARCHAR(40) NOT NULL, "
"sdata2 VARCHAR(40) NOT NULL, "
"edata1 VARCHAR(40) NOT NULL, "
"edata2 VARCHAR(40) NOT NULL, "
"ndata1 VARCHAR(40) NOT NULL, "
"ndata2 VARCHAR(40) NOT NULL)");
query.exec("INSERT INTO shuju (id, wdata1,wdata2, sdata1,sdata2,edata1,edata2,ndata1,ndata2) "
"VALUES (1,'1045', '35.1','35.89', '35.1','35.89', '35.1','35.89', '35.1')");
query.exec("UPDATE shuju set wdata1= djs,sdata1='hum_d',edata1='nav_longi',ndata1='nav_lati' where id=1");
执行时最后一句:query.exec("UPDATE shuju set wdata1= djs,sdata1='hum_d',edata1='nav_longi',ndata1='nav_lati' where id=1");
没有任何效果,请问想要把QString写入数据库程序要怎么写?请高手指点!
[解决办法]
你要把插入数据库的语句组织好,参考下面的:
strSql = QString("insert into Table values(%1, '%2')"
).arg(strTmpValue).arg(iTmpValue);
bRet = query.exec(strSql);
[解决办法]
QString strSql;
strSql = QString("UPDATE shuju set wdata1= '%1',sdata1='hum_d',edata1='nav_longi',ndata1='nav_lati' where id=1").arg(djs);
query.exec(strSql);
[解决办法]