<QDebug>
#include <QSqlDatabase>
#include <QSqlQuery>
int main(
int argc,
char *
argv[])
{
QCoreApplication a(argc, argv);
QSqlDatabase db = QSqlDatabase::addDatabase(
"QSQLITE");
db.setDatabaseName("student.db");
if(!
db.open())
{
qDebug() <<
"open err";
}
else
{
qDebug() <<
"database is ok";
}
QSqlQuery query(db);
bool isok = query.exec(
"create table stud(id int primary key,name varchar(20))");
query.exec("insert into stud values(111,‘liming‘)");
query.exec("insert into stud values(102,‘li‘)");
query.exec("insert into stud values(103,‘lisi‘)");
query.exec("insert into stud values(105,‘zhangsan‘)");
if(!
isok)
{
qDebug() <<
"table err";
}
else
{
qDebug() <<
"table is ok";
}
query.exec("select * from stud");
while(query.next())
{
qDebug() <<
"id:"<<query.value(
0).toInt()<<
"name:"<<query.value(
1).toString();
}
return a.exec();
}
qt连接数据库Sqlite
标签：insert basename [] set data include tab bug arch
本文系统来源：http://www.cnblogs.com/lt-6/p/6720459.html
【说明】：
本文章由站长整理发布，文章内容不代表本站观点，如文中有侵权行为，请与本站客服联系(QQ:254677821)！