QT 连接SQL数据新建表并写入数据库失败

[x1aoyua367]

刚学qt 今天连接SQL数据新建表并写入数据库失败
代码如下 yu是数据库名称 用户名和密码均为test

    QSqlDatabase db=QSqlDatabase::addDatabase("QSQLITE");
    db.setHostName("localhost");
    db.setDatabaseName("yu");
    db.setUserName("test");
    db.setPassword("test");
     bool ok=db.open();
    if(ok){
        QMessageBox msgBox;
        msgBox.setText("ok");
        msgBox.exec();
        }
        else{
            QMessageBox msgBox;
            msgBox.setText("Error connect database!"+db.lastError().text());
            msgBox.exec();
        }
    QSqlQuery query; //以下执行相关QSL语句
        query.exec("create table student(id int primary key,name varchar)");
        //新建student表，id设置为主键，还有一个name项
        query.exec("insert into student values(1,’xiaogang’)");
        query.exec("insert into student values(2,’xiaoming’)");
        query.exec("insert into student values(3,’xiaohong’)");

[牧牛童子]

友情顶起。我这在学习QT