#include <manageindexes.h>
Public Member Functions | |
ManageIndexes (QWidget *parent=0) | |
~ManageIndexes () | |
void | refreshIndexes () |
Public Attributes | |
QSqlDatabase | db |
QString | dbName |
QString | tableName |
Definition at line 11 of file manageindexes.h.
ManageIndexes::ManageIndexes | ( | QWidget * | parent = 0 ) |
[explicit] |
Definition at line 4 of file manageindexes.cpp.
: QDialog(parent), ui(new Ui::ManageIndexes) { ui->setupUi(this); }
ManageIndexes::~ManageIndexes | ( | ) |
Definition at line 11 of file manageindexes.cpp.
{
delete ui;
}
void ManageIndexes::refreshIndexes | ( | ) |
Definition at line 16 of file manageindexes.cpp.
References db, dbName, and tableName.
{ db.open(); if (db.isOpen()) { QSqlQuery qu(db); ui->lineEdit->setText(dbName); ui->lineEdit_2->setText(tableName); ui->treeWidget->clear(); if (qu.exec(tr("show keys from `%1`.`%2`").arg(dbName, tableName))) { while (qu.next()) { QSqlRecord rec = qu.record(); QString indName = rec.value("Key_name").toString(); QString cols = rec.value("Column_name").toString(); QTreeWidgetItem *it = new QTreeWidgetItem(ui->treeWidget); it->setText(0, indName); it->setText(1, cols); it->setIcon(0, QIcon("://icons/Icon_43.ico")); } } } }
QSqlDatabase ManageIndexes::db |
Definition at line 18 of file manageindexes.h.
Referenced by refreshIndexes().
QString ManageIndexes::dbName |
Definition at line 19 of file manageindexes.h.
Referenced by refreshIndexes().
QString ManageIndexes::tableName |
Definition at line 20 of file manageindexes.h.
Referenced by refreshIndexes().