16,203
社区成员
发帖
与我相关
我的任务
分享
//连接数据库
void foxProp::on_pushButton_clicked()
{
db = QSqlDatabase::addDatabase("QODBC","test");
QString dsn= "Driver={microsoft Visual Foxpro driver};sourcetype=DBC;sourceDB=D:\\vftest\\vfdb.dbc;Exclusive=No;";
db.setDatabaseName(dsn);
if(!db.open ())
{
QSqlError error = db.lastError();
QMessageBox::warning (0, "Warning", QString("Failed to open database!Error:%1").arg(error.text()));
}
else
QMessageBox::about(this,"dbf","ok");
}
//读取数据
void foxProp::on_pushButton_2_clicked()
{
//db = QSqlDatabase::addDatabase("QODBC","test");
QSqlQuery query=QSqlQuery::QSqlQuery(db);
//query.exec("SELECT * FROM csfzk.dbf");
query.exec("SELECT * FROM vftable");
while(query.next())
{
QString index = query.value(1).toString();
QString str1 = QString::fromLocal8Bit(index.toStdString().c_str());
QString str2 = QString::fromLatin1(index.toStdString().c_str());
QString str3 = QString::fromAscii (index.toStdString().c_str());;
// QString str4 = QTextCodec::toUnicode(index.toStdString().c_str());
QString name = query.value(2).toInt();
ui.listWidget->addItem(str1);
break;
}
}