各位大虾帮忙看看这是怎么回事，代码如下：
static bool createConnection()
{
QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");
db.setHostName("shark");
db.setDatabaseName("TheLostOneFinding");//我自己建的数据库名
db.setUserName("sa");
db.setPassword("5304508");
if(!db.open())
{
QMessageBox::critical(0,QObject::tr("Database Error"),db.lastError().text());
return false;
}
/*QSqlQuery query;
query.exec("create table student (id int primary key, "
"name varchar(20))");
query.exec("insert into student values(0, 'first')");
/* query.exec(“insert into student values(1, ‘second’)”);
query.exec(“insert into student values(2, ‘third’)”);
query.exec(“insert into student values(3, ‘fourth’)”);
query.exec(“insert into student values(4, ‘fifth’)”);*/
return true;
}
然后用一个pushbutton去控制读取：
void Widget::on_pushButton_clicked()
{
QSqlQuery query;
query.exec("select * from FileList");
while(query.next())
{
QString name=query.value(1).toString();
ui->label->setText(name);
qDebug()<<query.value(0).toString()<<query.value(1).toString()<<query.value(2).toString()<<query.value(3).toString();
}
}
数据库截图：
