#include <QtCore/QCoreApplication>
#include"QtSql/QtSql"
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(":memory:");
if(!db.open())
{
return false;
}
QSqlQuery query;
query.exec("CREATE TABLE employee(id int primary key,name varchar(15),salary int");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1001, 'Thad Beaumont', 65000)");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1002, 'Thad Beaumonts', 65000)");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1003, 'Thad Beaumontss', 65000)");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1004, 'Thad Beaumontq', 65000)");
query.exec("select * from employee");
if(query.next())
qDebug()<<query.value(0).toInt()<<query.value(1).toString()<<query.value(2).toInt();
return a.exec();
}
#include"QtSql/QtSql"
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName(":memory:");
if(!db.open())
{
return false;
}
QSqlQuery query;
query.exec("CREATE TABLE employee(id int primary key,name varchar(15),salary int");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1001, 'Thad Beaumont', 65000)");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1002, 'Thad Beaumonts', 65000)");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1003, 'Thad Beaumontss', 65000)");
query.exec("INSERT INTO employee (id, name, salary) "
"VALUES (1004, 'Thad Beaumontq', 65000)");
query.exec("select * from employee");
if(query.next())
qDebug()<<query.value(0).toInt()<<query.value(1).toString()<<query.value(2).toInt();
return a.exec();
}
第二次再执行会提示表已经存在了。