Qt学习难题（一）.
voidmyProject::pushButton_3_adminFunction()
{
QSqlQueryquery;
query.prepare(QObject::tr("createtablestudent(idintprimarykey,namevarchar(15));"));
//query.exec("droptablestudent");//执行成功
//query.exec("delete*fromadmin_tablewhereadmin_no='3';");//不能执行
query.prepare(QObject::tr("INSERTINTOstudent(id,name)VALUES(1,’xiaogang’)"));
query.prepare(QObject::tr("INSERTINTOstudent(id,name)VALUES(2,’xiaofang’)"));
query.prepare(QObject::tr("INSERTINTOstudent(id,name)VALUES(3,’xiaoli’)"));
query.prepare(QObject::tr("INSERTINTOstudent(id,name)VALUES(4,’xiaogming’)"));
query.exec();
}
类似于上面这段代码，执行不出结果，vs也没有提示错误，但是数据库里面没有显示创建和插入的内容。
voidmyProject::pushButton_3_adminFunction()
{
QSqlQueryquery;
query.exec(QObject::tr("createtablestudent(idintprimarykey,namevarchar(15));"));
//query.exec("droptablestudent");
//query.exec("delete*fromadmin_tablewhereadmin_no='3';");
query.exec(QObject::tr("INSERTINTOstudent(id,name)VALUES(1,’xiaogang’)"));
query.exec(QObject::tr("INSERTINTOstudent(id,name)VALUES(2,’xiaofang’)"));
query.exec(QObject::tr("INSERTINTOstudent(id,name)VALUES(3,’xiaoli’)"));
query.exec(QObject::tr("INSERTINTOstudent(id,name)VALUES(4,’xiaogming’)"));
query.exec();
}
这段代码，和上面类似，只是将prepare改为exec，这个执行create和select都成功，但是下面的insertinto和delete等执行后都无结果显示，菜鸟请教高手解答。
分 -->
|
