~oif-team/ubuntu/natty/qt4-x11/xi2.1

<td width="1">  </td><td class="postheader" valign="center"><a href="index.html"><font color="#004faf">Home</font></a> · <a href="classes.html"><font color="#004faf">All Classes</font></a> · <a href="mainclasses.html"><font color="#004faf">Main Classes</font></a> · <a href="annotated.html"><font color="#004faf">Annotated</font></a> · <a href="groups.html"><font color="#004faf">Grouped Classes</font></a> · <a href="functions.html"><font color="#004faf">Functions</font></a></td>

<td align="right" valign="top" width="230"><img src="images/trolltech-logo.png" align="right" width="203" height="32" border="0" /></td></tr></table><h1 align="center">connectionwidget.cpp Example File<br /><small><small>demos/sqlbrowser/connectionwidget.cpp</small></small></h1>

<pre>  /****************************************************************************

** This file is part of the documentation of the Qt Toolkit.

** This file may be distributed under the terms of the Q Public License

** as defined by Trolltech AS of Norway and appearing in the file

** LICENSE.QPL included in the packaging of this file.

** This file may be distributed and/or modified under the terms of the

** GNU General Public License version 2 as published by the Free Software

** Foundation and appearing in the file LICENSE.GPL included in the

** packaging of this file.

** See http://www.trolltech.com/pricing.html or email sales@trolltech.com for

** information about Qt Commercial License Agreements.

** See http://www.trolltech.com/qpl/ for QPL licensing information.

** See http://www.trolltech.com/gpl/ for GPL licensing information.

** Contact info@trolltech.com if any conditions of this licensing are

** not clear to you.

** This file is provided AS IS with NO WARRANTY OF ANY KIND, INCLUDING THE

** WARRANTY OF DESIGN, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.

****************************************************************************/

#include "connectionwidget.h"

#include <QtGui>

#include <QtSql>

ConnectionWidget::ConnectionWidget(QWidget *parent)

: QWidget(parent)

{

QVBoxLayout *layout = new QVBoxLayout(this);

tree = new QTreeWidget(this);

tree->setObjectName(QLatin1String("tree"));

tree->setHeaderLabels(QStringList(tr("database")));

tree->header()->setResizeMode(QHeaderView::Stretch);

QAction *refreshAction = new QAction(tr("Refresh"), tree);

connect(refreshAction, SIGNAL(triggered()), SLOT(refresh()));

tree->addAction(refreshAction);

tree->setContextMenuPolicy(Qt::ActionsContextMenu);

layout->addWidget(tree);

QMetaObject::connectSlotsByName(this);

}

ConnectionWidget::~ConnectionWidget()

{

}

static QString qDBCaption(const QSqlDatabase &db)

{

QString nm = db.driverName();

nm.append(QLatin1Char(':'));

if (!db.userName().isEmpty())

nm.append(db.userName()).append(QLatin1Char('@'));

nm.append(db.databaseName());

return nm;

}

void ConnectionWidget::refresh()

{

tree->clear();

QStringList connectionNames = QSqlDatabase::connectionNames();

bool gotActiveDb = false;

for (int i = 0; i < connectionNames.count(); ++i) {

QTreeWidgetItem *root = new QTreeWidgetItem(tree);

QSqlDatabase db = QSqlDatabase::database(connectionNames.at(i), false);

root->setText(0, qDBCaption(db));

if (connectionNames.at(i) == activeDb) {

gotActiveDb = true;

setActive(root);

}

if (db.isOpen()) {

100

QStringList tables = db.tables();

101

for (int t = 0; t < tables.count(); ++t) {

102

QTreeWidgetItem *table = new QTreeWidgetItem(root);

103

table->setText(0, tables.at(t));

104

}

105

}

106

}

107

if (!gotActiveDb) {

108

activeDb = connectionNames.value(0);

109

setActive(tree->topLevelItem(0));

110

}

111

112

tree->doItemsLayout(); // HACK

113

}

114

115

QSqlDatabase ConnectionWidget::currentDatabase() const

116

{

117

return QSqlDatabase::database(activeDb);

118

}

119

120

static void qSetBold(QTreeWidgetItem *item, bool bold)

121

{

122

QFont font = item->font(0);

123

font.setBold(bold);

124

item->setFont(0, font);

125

}

126

127

void ConnectionWidget::setActive(QTreeWidgetItem *item)

128

{

129

for (int i = 0; i < tree->topLevelItemCount(); ++i) {

130

if (tree->topLevelItem(i)->font(0).bold())

131

qSetBold(tree->topLevelItem(i), false);

132

}

133

134

if (!item)

135

return;

136

137

qSetBold(item, true);

138

activeDb = QSqlDatabase::connectionNames().value(tree->indexOfTopLevelItem(item));

139

}

140

141

void ConnectionWidget::on_tree_itemActivated(QTreeWidgetItem *item, int /* column */)

142

{

143

144

if (!item)

145

return;

146

147

if (!item->parent()) {

148

setActive(item);

149

} else {

150

setActive(item->parent());

151

emit tableActivated(item->text(0));

152

}

153

}</pre>

154

155

156

157

<td width="40%" align="center"><a href="trademarks.html">Trademarks</a></td>

158

159

</tr></table></div></address></body>

160

</html>

Older »