嵌入式 Ubuntu系统下QtCreator开发与MySql的使用问题

#include
#include

int main(int argc, char *argv[])
{
   QCoreApplication a(argc, argv);
    qDebug()<<"Available drivers:";
    QStringListdrivers = QSqlDatabase::drivers();
   foreach(QString driver, drivers)
       qDebug() << "\t" << driver;

    QSqlDatabasedb = QSqlDatabase::addDatabase("QSQLITE");//Ìí¼ÓÊý¾Ý¿âÇý¶¯
   db.setDatabaseName("/root/Desktop/FirstWorkSpace/QtMySql/kj.db");//注意了路径的‘\’与windows下的相反！！！！

    if(!db.open())
    {
       return false;
    }
    QSqlQueryquery;
    if(query.exec("create table student(id int primary k ey, namevarchar)") )//н¨±ístudent Ö÷¼üÊÇid£¬Ãû×ÖÊǿɱ䳤¶È×Ö·û´®
    {
       qDebug() <<"Create success !!!";
    }
    if(query.exec("insert into student values(1,'KongJun')"))
    {
       qDebug() <<"insert success !!!";
    }
   query.exec("insert into student values(2,'LiuXiaoWei')");
   query.exec("insert into studentvalues(3,'ZhuShiWei')");//²åÈëÈýÌõ¼Ç¼
   query.exec("select id,name from student where id >=2");//²éÕÒ±íÖÐid´óÓÚ2µÄ¼Ç¼µÄidºÍÐÕÃû
    while(query.next())//query.next()Ö¸Ïò²éÕҵĵÚÒ»Ìõ¼Ç¼£¬È»ºóÿ´ÎÏòºóÒƶ¯Ò»Ìõ¼Ç¼
    {
       int ele0 = query.value(0).toInt();//idµÄֵת»»ÎªintÐÍ
       QString ele1 = query.value(1).toString();
       qDebug() << ele0 << ele1;
    }

    returna.exec();
}