Parameter count mismatch 请各位大佬帮忙解决
{
QSqlDatabase db = QSqlDatabase::database("sqlite2"); //建立数据库连接
QSqlQuery query(db);
bool success = query.exec("create table car(id int primary key,buyer_name varchar,"
"phone_number varchar,time varchar,money varchar,rate varchar,type varchar,"
"carnumber varchar,carduce varchar,month varchar,day varchar)");
if(success)
{
qDebug() << QObject::tr("数据库表创建成功!\n");
return true;
}
else
{
qDebug() << QObject::tr("数据库表创建失败!\n");
return false;
}
db.close();
}
//根据ID更新记录
bool DataBase::updateById(int id,QString *m)
{
QSqlDatabase db = QSqlDatabase::database("sqlite2"); //建立数据库连接
QSqlQuery query(db);
query.prepare(QString("update car set buyer_name=?"
"phone_number=?,time=?, money=?,rate=?,type=?"
"carnumber=?,carduce=?, month=?,day=? where id=%1").arg(id));
qDebug()<<id;
for(int x=0;x<10;x++)
{
if(m[x]!=NULL&&m[x]!="年月日"&&m[x]!="月"&&m[x]!="日")query.bindValue(x,m[x]);
}
bool success=query.exec();
if(!success)
{
QSqlError lastError = query.lastError();
qDebug() << lastError.driverText() << QString(QObject::tr("更新失败"));
}
return true;
}
但是使用这个函数时,总会"Parameter count mismatch"
而且实际也没有更新数据库的内容
相关推荐
C2修复工具【银灿916】固件
[Preformat] 1="INQU invalid bus selector" 2="INQU invalid function selector" 3="INQU invalid timeout value" 4="INQU invalid parameter" 5="INQU inquiry fail" 6="INQU disconnect" 7="INQU reattach error" 8="INQU mode sense error" 9="INQU mode select error" 10="NAND invalid bus selector" 11="NAND invalid function selector" 12="NAND invalid timeout value" 13="NAND invalid parameter" 14="NAND erase block error" 15="NAND get map error" 16="NAND configurate SSD Info. error" 17="NAND configurate device error" 18="NAND configurate project info. error" 19="NAND read PINF error" 20="NAND write PINF error" 21="NAND read physical block status error" 22="NAND execute error" 23="NAND scan initial defective blocks error" 24="NAND check ready busy error" 25="NAND flash physical read error" 26="NAND flash physical write error 27="NAND read spare data error" 28="NAND set spare data error" 29="NAND write spare data error" 30="NAND read parameter page error" 31="NAND set PINF block address error" 32="NAND read sorting info. error" 33="NAND config. scramble error" 34="NFTL invalid bus selector" 35="NFTL invalid function selector" 36="NFTL invalid timeout value" 37="NFTL invalid parameter" 38="NFTL get information error" 39="NFTL get L2P mapping table error" 40="NFTL get physical block state table error" 41="NFTL start NFTL error" 42="NFTL stop NFTL error" 43="NFTL get versoin error" 44="NFTL get erase count error" 45="PM invalid bus selector" 46="PM invalid function selector" 47="PM invalid timeout value" 48="PM invalid parameter" 49="PM incorrect system descriptor error" 50="PM incorrect system descriptor length error" 51="PM write partition error" 52="PM write system descriptor error" 53="PM write customer application partition error" 54="PM write image file error" 55="PM read capacity error" 56="PM set partition error" 57="PM read partition error" 58="PM read system descriptor error" 59="PM read customer application partition error" 60="PM set key error" 61="PM set security partition status error" 62="PM start security partition error" 63="PM stop security partition error" 64="PM toggle write protect partition error" 65="PM get supported system IDs error" 66="EXEC invalid bus selector" 67="EXEC invalid function selector" 68="EXEC invalid timeout value" 69="EXEC invalid parameter" 70="EXEC firmware program fail" 71="EXEC download program image fail" 72="LEDC invalid bus selector" 73="LEDC invalid function selector" 74="LEDC invalid timeout value" 75="LEDC invalid parameter" 76="LEDC control error" 77="PINF invalid bus selector" 78="PINF invalid function selector" 79="PINF invalid timeout value" 80="PINF invalid parameter" 81="PINF read capacity error" 82="PINF read PINF block error" 83="PINF write PINF block error" 84="PINF erase block error" 85="TEPF invalid bus selector" 86="TEPF invalid function selector" 87="TEPF invalid timeout value" 88="TEPF invalid parameter" 89="TEPF execute fail" 90="SPTI invalid parameter" 91="SPTI test unit ready error" 92="SPTI inquiry error" 93="SPTI read capacity error" 94="APTI invalid parameter" 95="SPTI invalid parameter" 96="SCSI invalid parameter error" 97="SCSI read error" 98="SCSI write error" 99="SCSI read ex. error" 100="SCSI write ex. error" 101="ATA invalid parameter" 102="ATA read error" 103="ATA write error" 104="ATA read ex. error" 105="ATA write ex. error" 106="RAID invalid parameter" 107="RAID read error" 108="RAID write error" 109="RAID read ex. error" 110="RAID write ex. error" 111="Preformat status function fail" 112="That is not ONFI DDR Flash" 113="Group A pages of PINF is not enough" 114="Group A pages is not enough" 115="Allocate PINF fail" 116="LINF verify fail" 117="PINF verify fail" 118="Get firmware file fail" 119="Set capacity fail" 120="Set Serial Number fail" 121="Serial number lenth too large" 122="Boot firmware fail" 123="Build FW Loc. fail" 124="Get PINF Page fail" [Sorting] 1001="sorting event function fail" 1002="sorting status function fail" 1003="sorting set parameter fail" 1004="sorting get parameter fail" 1005="sorting set pattern fail" 1006="sorting set table fail" 1007="sorting erase fail" 1008="sorting write fail" 1009="sorting read compare fail" 1010="sorting get result fail" 1011="sorting is not TLC flash" 1012="sorting power on/off fail" 1013="sorting set feature fail" 1014="sorting set block mapping fail" 1015="sorting bad blocks too much" 1016="sorting not support multi channel/multi bank" 1017="sorting data length mismatch" 1018="sorting set alpha table fail" 1019="sorting verify IDBT fail" 1020="sorting quick parameter fail" 1021="sorting invalid sorting level" 1022="Sorting user stop" [Booted] 2001="Format Fail!" 2002="Copy Test Fail!" 2003="Partition Fail!" 2004="Used space too much!"
29Linux基础命令详解——用户管理.docx
29Linux基础命令详解——用户管理
科技服务机构如何通过数据分析增强服务竞争力?.docx
科易网基于40亿+科创知识图谱数据库,深度探索AI技术在技术转移、成果转化、技术经纪、知识产权、产业创新、科技招商等垂直领域的多样化应用场景,研究科技创新领域的AI+数智化解决方案,推动科技创新与产业创新智能化发展。
vue+springboot基于 Java 的南昌实利广告公司的员工管理系统的设计与实现_oj680rl3毕业设计源码数据库.zip
vue+springboot基于 Java 的南昌实利广告公司的员工管理系统的设计与实现_oj680rl3毕业设计源码数据库.zip
车辆缺陷分割数据集4000张json格式.zip
数据集格式:labelme格式(不包含mask文件,仅仅包含jpg图片和对应的json文件) 图片数量(jpg文件个数):4000 标注数量(json文件个数):4000 标注类别数:1 标注类别名称:["defect"] 每个类别标注的框数: defect count = 8740 总框数:8740 使用标注工具:labelme=5.5.0 所在仓库:firc-dataset 图片分辨率:640x640 标注规则:对类别进行画多边形框polygon 重要说明:可以将数据集用labelme打开编辑,json数据集需自己转成mask或者yolo格式或者coco格式作语义分割或者实例分割 特别声明:本数据集不对训练的模型或者权重文件精度作任何保证


