Qt 数据库表中插入记录

mySql的插入语句（多条记录）是：

QSqlQuery query;

query.prepare("INSERT INTO table(id,title,year)" " VALUES(:id,:title,:year)");

query.bindValue(":id",1);

query.bindValue(":title","Hello");

query.bindValue(":year",2012);

query.exec();

 

sqlserver插入语句为：

QSqlQuery query;

query.prepare("INSERT INTO table(id,title,year)" " VALUES(?,?,?)");

query.bindValue(1);

query.bindValue("Hello");

query.bindValue(2012);

query.exec();

---记录点点滴滴