模板
教程
环境
性能
功能
管理
软件测试 > 测试开发技术 > 软件测试开发语言 > 数据库 > SQL Server >
SQLITE数据库
[cpp] view plaincopyprint?
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("support");
if(!db.open())
{
QMessageBox::critical(0, qApp->tr("Cannot open database"),
qApp->tr("Unable to establish a database connection.\n"
"This example needs SQLite support. Please read "
"the Qt SQL driver documentation for information how "
"to build it.\n\n"
"Click Cancel to exit."), QMessageBox::Cancel);
return false;
}
QSqlQuery q;
q.exec("create table student(id integer primary key,name varchar,age integer)");
q.exec("insert into student(id,name,age) values(1001,'AnPan',21)");
q.exec("insert into student(id,name,age) values(1002,'CaoLL',22)");
return true;
QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("support");
if(!db.open())
{
QMessageBox::critical(0, qApp->tr("Cannot open database"),
qApp->tr("Unable to establish a database connection.\n"
"This example needs SQLite support. Please read "
"the Qt SQL driver documentation for information how "
"to build it.\n\n"
"Click Cancel to exit."), QMessageBox::Cancel);
return false;
}
QSqlQuery q;
q.exec("create table student(id integer primary key,name varchar,age integer)");
q.exec("insert into student(id,name,age) values(1001,'AnPan',21)");
q.exec("insert into student(id,name,age) values(1002,'CaoLL',22)");
return true;
