Qt 操作sqlite

//在.pro文件中增加一句:QT += sql
#include <QtCore/QCoreApplication> 
 
#include <QtSql> 
#include <QTextCodec> 
int main(int argc, char *argv[]){      
QCoreApplication a(argc, argv);     
 QTextCodec::setCodecForTr(QTextCodec::codecForLocale());     
  QSqlDatabase dbconn=QSqlDatabase::addDatabase("QSQLITE");    //添加数据库驱动      
  dbconn.setDatabaseName("mytest.db");  //在工程目录新建一个mytest.db的文件      
  if(!dbconn.open())    {          
  qDebug()<<"fdsfds";      
  }      
 QSqlQuery query;//以下执行相关QSL语句      
 query.exec("create table student(id varchar,name varchar)");    //新建student表，id设置为主键，还有一个name项     
  query.exec(QObject::tr("insert into student values(1,'李刚')"));      
  query.exec(QObject::tr("insert into student values(2,'苹果')"));     
   query.exec(QObject::tr("insert into student values(3,'葡萄')"));      
   query.exec(QObject::tr("insert into student values(3,'李子')"));      
   query.exec(QObject::tr("insert into student values(4,’橘子')"));      
   query.exec(QObject::tr("insert into student values(5,'核桃')"));      
   query.exec(QObject::tr("insert into student values(6,'芒果')"));  
      //query.exec(QObject::tr("select id,name from student where id>=1"));      
   query.exec("select id,name from student where id>=1");     
    while(query.next())//query.next()指向查找到的第一条记录，然后每次后移一条记录    {   
           int ele0=query.value(0).toInt();//query.value(0)是id的值，将其转换为int型          
           QString ele1=query.value(1).toString();          
           qDebug()<<ele0<<ele1;//输出两个值  
  }     
 query.exec(QObject::tr("drop student"));     
  return a.exec();  
}

　　

转载于:https://www.cnblogs.com/fuyanwen/p/3291254.html