<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en_US" lang="en_US"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Qt 4.8: browser.cpp Example File (demos/sqlbrowser/browser.cpp)</title> <link rel="stylesheet" type="text/css" href="style/style.css" /> <script src="scripts/jquery.js" type="text/javascript"></script> <script src="scripts/functions.js" type="text/javascript"></script> <link rel="stylesheet" type="text/css" href="style/superfish.css" /> <link rel="stylesheet" type="text/css" href="style/narrow.css" /> <!--[if IE]> <meta name="MSSmartTagsPreventParsing" content="true"> <meta http-equiv="imagetoolbar" content="no"> <![endif]--> <!--[if lt IE 7]> <link rel="stylesheet" type="text/css" href="style/style_ie6.css"> <![endif]--> <!--[if IE 7]> <link rel="stylesheet" type="text/css" href="style/style_ie7.css"> <![endif]--> <!--[if IE 8]> <link rel="stylesheet" type="text/css" href="style/style_ie8.css"> <![endif]--> <script src="scripts/superfish.js" type="text/javascript"></script> <script src="scripts/narrow.js" type="text/javascript"></script> </head> <body class="" onload="CheckEmptyAndLoadList();"> <div class="header" id="qtdocheader"> <div class="content"> <div id="nav-logo"> <a href="index.html">Home</a></div> <a href="index.html" class="qtref"><span>Qt Reference Documentation</span></a> <div id="narrowsearch"></div> <div id="nav-topright"> <ul> <li class="nav-topright-home"><a href="http://qt.digia.com/">Qt HOME</a></li> <li class="nav-topright-dev"><a href="http://qt-project.org/">DEV</a></li> <li class="nav-topright-doc nav-topright-doc-active"><a href="http://qt-project.org/doc/"> DOC</a></li> <li class="nav-topright-blog"><a href="http://blog.qt.digia.com/">BLOG</a></li> </ul> </div> <div id="shortCut"> <ul> <li class="shortCut-topleft-inactive"><span><a href="index.html">Qt 4.8</a></span></li> <li class="shortCut-topleft-active"><a href="http://qt-project.org/doc/">ALL VERSIONS </a></li> </ul> </div> <ul class="sf-menu" id="narrowmenu"> <li><a href="#">API Lookup</a> <ul> <li><a href="classes.html">Class index</a></li> <li><a href="functions.html">Function index</a></li> <li><a href="modules.html">Modules</a></li> <li><a href="namespaces.html">Namespaces</a></li> <li><a href="qtglobal.html">Global Declarations</a></li> <li><a href="qdeclarativeelements.html">QML elements</a></li> </ul> </li> <li><a href="#">Qt Topics</a> <ul> <li><a href="qt-basic-concepts.html">Programming with Qt</a></li> <li><a href="qtquick.html">Device UIs & Qt Quick</a></li> <li><a href="qt-gui-concepts.html">UI Design with Qt</a></li> <li><a href="supported-platforms.html">Supported Platforms</a></li> <li><a href="technology-apis.html">Qt and Key Technologies</a></li> <li><a href="best-practices.html">How-To's and Best Practices</a></li> </ul> </li> <li><a href="#">Examples</a> <ul> <li><a href="all-examples.html">Examples</a></li> <li><a href="tutorials.html">Tutorials</a></li> <li><a href="demos.html">Demos</a></li> <li><a href="qdeclarativeexamples.html">QML Examples</a></li> </ul> </li> </ul> </div> </div> <div class="wrapper"> <div class="hd"> <span></span> </div> <div class="bd group"> <div class="sidebar"> <div class="searchlabel"> Search index:</div> <div class="search" id="sidebarsearch"> <form id="qtdocsearch" action="" onsubmit="return false;"> <fieldset> <input type="text" name="searchstring" id="pageType" value="" /> <div id="resultdialog"> <a href="#" id="resultclose">Close</a> <p id="resultlinks" class="all"><a href="#" id="showallresults">All</a> | <a href="#" id="showapiresults">API</a> | <a href="#" id="showarticleresults">Articles</a> | <a href="#" id="showexampleresults">Examples</a></p> <p id="searchcount" class="all"><span id="resultcount"></span><span id="apicount"></span><span id="articlecount"></span><span id="examplecount"></span> results:</p> <ul id="resultlist" class="all"> </ul> </div> </fieldset> </form> </div> <div class="box first bottombar" id="lookup"> <h2 title="API Lookup"><span></span> API Lookup</h2> <div id="list001" class="list"> <ul id="ul001" > <li class="defaultLink"><a href="classes.html">Class index</a></li> <li class="defaultLink"><a href="functions.html">Function index</a></li> <li class="defaultLink"><a href="modules.html">Modules</a></li> <li class="defaultLink"><a href="namespaces.html">Namespaces</a></li> <li class="defaultLink"><a href="qtglobal.html">Global Declarations</a></li> <li class="defaultLink"><a href="qdeclarativeelements.html">QML elements</a></li> </ul> </div> </div> <div class="box bottombar" id="topics"> <h2 title="Qt Topics"><span></span> Qt Topics</h2> <div id="list002" class="list"> <ul id="ul002" > <li class="defaultLink"><a href="qt-basic-concepts.html">Programming with Qt</a></li> <li class="defaultLink"><a href="qtquick.html">Device UIs & Qt Quick</a></li> <li class="defaultLink"><a href="qt-gui-concepts.html">UI Design with Qt</a></li> <li class="defaultLink"><a href="supported-platforms.html">Supported Platforms</a></li> <li class="defaultLink"><a href="technology-apis.html">Qt and Key Technologies</a></li> <li class="defaultLink"><a href="best-practices.html">How-To's and Best Practices</a></li> </ul> </div> </div> <div class="box" id="examples"> <h2 title="Examples"><span></span> Examples</h2> <div id="list003" class="list"> <ul id="ul003"> <li class="defaultLink"><a href="all-examples.html">Examples</a></li> <li class="defaultLink"><a href="tutorials.html">Tutorials</a></li> <li class="defaultLink"><a href="demos.html">Demos</a></li> <li class="defaultLink"><a href="qdeclarativeexamples.html">QML Examples</a></li> </ul> </div> </div> </div> <div class="wrap"> <div class="toolbar"> <div class="breadcrumb toolblock"> <ul> <li class="first"><a href="index.html">Home</a></li> <!-- Breadcrumbs go here --> </ul> </div> <div class="toolbuttons toolblock"> <ul> <li id="smallA" class="t_button">A</li> <li id="medA" class="t_button active">A</li> <li id="bigA" class="t_button">A</li> <li id="print" class="t_button"><a href="javascript:this.print();"> <span>Print</span></a></li> </ul> </div> </div> <div class="content mainContent"> <h1 class="title">browser.cpp Example File</h1> <span class="small-subtitle">demos/sqlbrowser/browser.cpp</span> <!-- $$$demos/sqlbrowser/browser.cpp-description --> <div class="descr"> <a name="details"></a> <pre class="cpp"> <span class="comment">/**************************************************************************** ** ** Copyright (C) 2013 Digia Plc and/or its subsidiary(-ies). ** Contact: http://www.qt-project.org/legal ** ** This file is part of the demonstration applications of the Qt Toolkit. ** ** $QT_BEGIN_LICENSE:LGPL$ ** Commercial License Usage ** Licensees holding valid commercial Qt licenses may use this file in ** accordance with the commercial license agreement provided with the ** Software or, alternatively, in accordance with the terms contained in ** a written agreement between you and Digia. For licensing terms and ** conditions see http://qt.digia.com/licensing. For further information ** use the contact form at http://qt.digia.com/contact-us. ** ** GNU Lesser General Public License Usage ** Alternatively, this file may be used under the terms of the GNU Lesser ** General Public License version 2.1 as published by the Free Software ** Foundation and appearing in the file LICENSE.LGPL included in the ** packaging of this file. Please review the following information to ** ensure the GNU Lesser General Public License version 2.1 requirements ** will be met: http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html. ** ** In addition, as a special exception, Digia gives you certain additional ** rights. These rights are described in the Digia Qt LGPL Exception ** version 1.1, included in the file LGPL_EXCEPTION.txt in this package. ** ** GNU General Public License Usage ** Alternatively, this file may be used under the terms of the GNU ** General Public License version 3.0 as published by the Free Software ** Foundation and appearing in the file LICENSE.GPL included in the ** packaging of this file. Please review the following information to ** ensure the GNU General Public License version 3.0 requirements will be ** met: http://www.gnu.org/copyleft/gpl.html. ** ** ** $QT_END_LICENSE$ ** ****************************************************************************/</span> <span class="preprocessor">#include "browser.h"</span> <span class="preprocessor">#include "qsqlconnectiondialog.h"</span> <span class="preprocessor">#include <QtGui></span> <span class="preprocessor">#include <QtSql></span> Browser<span class="operator">::</span>Browser(<span class="type"><a href="qwidget.html">QWidget</a></span> <span class="operator">*</span>parent) : <span class="type"><a href="qwidget.html">QWidget</a></span>(parent) { setupUi(<span class="keyword">this</span>); table<span class="operator">-</span><span class="operator">></span>addAction(insertRowAction); table<span class="operator">-</span><span class="operator">></span>addAction(deleteRowAction); <span class="keyword">if</span> (<span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>drivers()<span class="operator">.</span>isEmpty()) <span class="type"><a href="qmessagebox.html">QMessageBox</a></span><span class="operator">::</span>information(<span class="keyword">this</span><span class="operator">,</span> tr(<span class="string">"No database drivers found"</span>)<span class="operator">,</span> tr(<span class="string">"This demo requires at least one Qt database driver. "</span> <span class="string">"Please check the documentation how to build the "</span> <span class="string">"Qt SQL plugins."</span>)); <span class="keyword">emit</span> statusMessage(tr(<span class="string">"Ready."</span>)); } Browser<span class="operator">::</span><span class="operator">~</span>Browser() { } <span class="type">void</span> Browser<span class="operator">::</span>exec() { <span class="type"><a href="qsqlquerymodel.html">QSqlQueryModel</a></span> <span class="operator">*</span>model <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qsqlquerymodel.html">QSqlQueryModel</a></span>(table); model<span class="operator">-</span><span class="operator">></span>setQuery(<span class="type"><a href="qsqlquery.html">QSqlQuery</a></span>(sqlEdit<span class="operator">-</span><span class="operator">></span>toPlainText()<span class="operator">,</span> connectionWidget<span class="operator">-</span><span class="operator">></span>currentDatabase())); table<span class="operator">-</span><span class="operator">></span>setModel(model); <span class="keyword">if</span> (model<span class="operator">-</span><span class="operator">></span>lastError()<span class="operator">.</span>type() <span class="operator">!</span><span class="operator">=</span> <span class="type"><a href="qsqlerror.html">QSqlError</a></span><span class="operator">::</span>NoError) <span class="keyword">emit</span> statusMessage(model<span class="operator">-</span><span class="operator">></span>lastError()<span class="operator">.</span>text()); <span class="keyword">else</span> <span class="keyword">if</span> (model<span class="operator">-</span><span class="operator">></span>query()<span class="operator">.</span>isSelect()) <span class="keyword">emit</span> statusMessage(tr(<span class="string">"Query OK."</span>)); <span class="keyword">else</span> <span class="keyword">emit</span> statusMessage(tr(<span class="string">"Query OK, number of affected rows: %1"</span>)<span class="operator">.</span>arg( model<span class="operator">-</span><span class="operator">></span>query()<span class="operator">.</span>numRowsAffected())); updateActions(); } <span class="type"><a href="qsqlerror.html">QSqlError</a></span> Browser<span class="operator">::</span>addConnection(<span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&</span>driver<span class="operator">,</span> <span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&</span>dbName<span class="operator">,</span> <span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&</span>host<span class="operator">,</span> <span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&</span>user<span class="operator">,</span> <span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&</span>passwd<span class="operator">,</span> <span class="type">int</span> port) { <span class="keyword">static</span> <span class="type">int</span> cCount <span class="operator">=</span> <span class="number">0</span>; <span class="type"><a href="qsqlerror.html">QSqlError</a></span> err; <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span> db <span class="operator">=</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>addDatabase(driver<span class="operator">,</span> <span class="type"><a href="qstring.html">QString</a></span>(<span class="string">"Browser%1"</span>)<span class="operator">.</span>arg(<span class="operator">+</span><span class="operator">+</span>cCount)); db<span class="operator">.</span>setDatabaseName(dbName); db<span class="operator">.</span>setHostName(host); db<span class="operator">.</span>setPort(port); <span class="keyword">if</span> (<span class="operator">!</span>db<span class="operator">.</span>open(user<span class="operator">,</span> passwd)) { err <span class="operator">=</span> db<span class="operator">.</span>lastError(); db <span class="operator">=</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span>(); <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>removeDatabase(<span class="type"><a href="qstring.html">QString</a></span>(<span class="string">"Browser%1"</span>)<span class="operator">.</span>arg(cCount)); } connectionWidget<span class="operator">-</span><span class="operator">></span>refresh(); <span class="keyword">return</span> err; } <span class="type">void</span> Browser<span class="operator">::</span>addConnection() { <span class="type">QSqlConnectionDialog</span> dialog(<span class="keyword">this</span>); <span class="keyword">if</span> (dialog<span class="operator">.</span>exec() <span class="operator">!</span><span class="operator">=</span> <span class="type"><a href="qdialog.html">QDialog</a></span><span class="operator">::</span>Accepted) <span class="keyword">return</span>; <span class="keyword">if</span> (dialog<span class="operator">.</span>useInMemoryDatabase()) { <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>database(<span class="string">"in_mem_db"</span><span class="operator">,</span> <span class="keyword">false</span>)<span class="operator">.</span>close(); <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>removeDatabase(<span class="string">"in_mem_db"</span>); <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span> db <span class="operator">=</span> <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span><span class="operator">::</span>addDatabase(<span class="string">"QSQLITE"</span><span class="operator">,</span> <span class="string">"in_mem_db"</span>); db<span class="operator">.</span>setDatabaseName(<span class="string">":memory:"</span>); <span class="keyword">if</span> (<span class="operator">!</span>db<span class="operator">.</span>open()) <span class="type"><a href="qmessagebox.html">QMessageBox</a></span><span class="operator">::</span>warning(<span class="keyword">this</span><span class="operator">,</span> tr(<span class="string">"Unable to open database"</span>)<span class="operator">,</span> tr(<span class="string">"An error occurred while "</span> <span class="string">"opening the connection: "</span>) <span class="operator">+</span> db<span class="operator">.</span>lastError()<span class="operator">.</span>text()); <span class="type"><a href="qsqlquery.html">QSqlQuery</a></span> q(<span class="string">""</span><span class="operator">,</span> db); q<span class="operator">.</span>exec(<span class="string">"drop table Movies"</span>); q<span class="operator">.</span>exec(<span class="string">"drop table Names"</span>); q<span class="operator">.</span>exec(<span class="string">"create table Movies (id integer primary key, Title varchar, Director varchar, Rating number)"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Movies values (0, 'Metropolis', 'Fritz Lang', '8.4')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Movies values (1, 'Nosferatu, eine Symphonie des Grauens', 'F.W. Murnau', '8.1')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Movies values (2, 'Bis ans Ende der Welt', 'Wim Wenders', '6.5')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Movies values (3, 'Hardware', 'Richard Stanley', '5.2')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Movies values (4, 'Mitchell', 'Andrew V. McLaglen', '2.1')"</span>); q<span class="operator">.</span>exec(<span class="string">"create table Names (id integer primary key, Firstname varchar, Lastname varchar, City varchar)"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Names values (0, 'Sala', 'Palmer', 'Morristown')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Names values (1, 'Christopher', 'Walker', 'Morristown')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Names values (2, 'Donald', 'Duck', 'Andeby')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Names values (3, 'Buck', 'Rogers', 'Paris')"</span>); q<span class="operator">.</span>exec(<span class="string">"insert into Names values (4, 'Sherlock', 'Holmes', 'London')"</span>); connectionWidget<span class="operator">-</span><span class="operator">></span>refresh(); } <span class="keyword">else</span> { <span class="type"><a href="qsqlerror.html">QSqlError</a></span> err <span class="operator">=</span> addConnection(dialog<span class="operator">.</span>driverName()<span class="operator">,</span> dialog<span class="operator">.</span>databaseName()<span class="operator">,</span> dialog<span class="operator">.</span>hostName()<span class="operator">,</span> dialog<span class="operator">.</span>userName()<span class="operator">,</span> dialog<span class="operator">.</span>password()<span class="operator">,</span> dialog<span class="operator">.</span>port()); <span class="keyword">if</span> (err<span class="operator">.</span>type() <span class="operator">!</span><span class="operator">=</span> <span class="type"><a href="qsqlerror.html">QSqlError</a></span><span class="operator">::</span>NoError) <span class="type"><a href="qmessagebox.html">QMessageBox</a></span><span class="operator">::</span>warning(<span class="keyword">this</span><span class="operator">,</span> tr(<span class="string">"Unable to open database"</span>)<span class="operator">,</span> tr(<span class="string">"An error occurred while "</span> <span class="string">"opening the connection: "</span>) <span class="operator">+</span> err<span class="operator">.</span>text()); } } <span class="type">void</span> Browser<span class="operator">::</span>showTable(<span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&</span>t) { <span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span>model <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span>(table<span class="operator">,</span> connectionWidget<span class="operator">-</span><span class="operator">></span>currentDatabase()); model<span class="operator">-</span><span class="operator">></span>setEditStrategy(<span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span><span class="operator">::</span>OnRowChange); model<span class="operator">-</span><span class="operator">></span>setTable(connectionWidget<span class="operator">-</span><span class="operator">></span>currentDatabase()<span class="operator">.</span>driver()<span class="operator">-</span><span class="operator">></span>escapeIdentifier(t<span class="operator">,</span> <span class="type"><a href="qsqldriver.html">QSqlDriver</a></span><span class="operator">::</span>TableName)); model<span class="operator">-</span><span class="operator">></span>select(); <span class="keyword">if</span> (model<span class="operator">-</span><span class="operator">></span>lastError()<span class="operator">.</span>type() <span class="operator">!</span><span class="operator">=</span> <span class="type"><a href="qsqlerror.html">QSqlError</a></span><span class="operator">::</span>NoError) <span class="keyword">emit</span> statusMessage(model<span class="operator">-</span><span class="operator">></span>lastError()<span class="operator">.</span>text()); table<span class="operator">-</span><span class="operator">></span>setModel(model); table<span class="operator">-</span><span class="operator">></span>setEditTriggers(<span class="type"><a href="qabstractitemview.html">QAbstractItemView</a></span><span class="operator">::</span>DoubleClicked<span class="operator">|</span><span class="type"><a href="qabstractitemview.html">QAbstractItemView</a></span><span class="operator">::</span>EditKeyPressed); connect(table<span class="operator">-</span><span class="operator">></span>selectionModel()<span class="operator">,</span> SIGNAL(currentRowChanged(<span class="type"><a href="qmodelindex.html">QModelIndex</a></span><span class="operator">,</span><span class="type"><a href="qmodelindex.html">QModelIndex</a></span>))<span class="operator">,</span> <span class="keyword">this</span><span class="operator">,</span> SLOT(currentChanged())); updateActions(); } <span class="type">void</span> Browser<span class="operator">::</span>showMetaData(<span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&</span>t) { <span class="type"><a href="qsqlrecord.html">QSqlRecord</a></span> rec <span class="operator">=</span> connectionWidget<span class="operator">-</span><span class="operator">></span>currentDatabase()<span class="operator">.</span>record(t); <span class="type"><a href="qstandarditemmodel.html">QStandardItemModel</a></span> <span class="operator">*</span>model <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="qstandarditemmodel.html">QStandardItemModel</a></span>(table); model<span class="operator">-</span><span class="operator">></span>insertRows(<span class="number">0</span><span class="operator">,</span> rec<span class="operator">.</span>count()); model<span class="operator">-</span><span class="operator">></span>insertColumns(<span class="number">0</span><span class="operator">,</span> <span class="number">7</span>); model<span class="operator">-</span><span class="operator">></span>setHeaderData(<span class="number">0</span><span class="operator">,</span> <span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>Horizontal<span class="operator">,</span> <span class="string">"Fieldname"</span>); model<span class="operator">-</span><span class="operator">></span>setHeaderData(<span class="number">1</span><span class="operator">,</span> <span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>Horizontal<span class="operator">,</span> <span class="string">"Type"</span>); model<span class="operator">-</span><span class="operator">></span>setHeaderData(<span class="number">2</span><span class="operator">,</span> <span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>Horizontal<span class="operator">,</span> <span class="string">"Length"</span>); model<span class="operator">-</span><span class="operator">></span>setHeaderData(<span class="number">3</span><span class="operator">,</span> <span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>Horizontal<span class="operator">,</span> <span class="string">"Precision"</span>); model<span class="operator">-</span><span class="operator">></span>setHeaderData(<span class="number">4</span><span class="operator">,</span> <span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>Horizontal<span class="operator">,</span> <span class="string">"Required"</span>); model<span class="operator">-</span><span class="operator">></span>setHeaderData(<span class="number">5</span><span class="operator">,</span> <span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>Horizontal<span class="operator">,</span> <span class="string">"AutoValue"</span>); model<span class="operator">-</span><span class="operator">></span>setHeaderData(<span class="number">6</span><span class="operator">,</span> <span class="type"><a href="qt.html">Qt</a></span><span class="operator">::</span>Horizontal<span class="operator">,</span> <span class="string">"DefaultValue"</span>); <span class="keyword">for</span> (<span class="type">int</span> i <span class="operator">=</span> <span class="number">0</span>; i <span class="operator"><</span> rec<span class="operator">.</span>count(); <span class="operator">+</span><span class="operator">+</span>i) { <span class="type"><a href="qsqlfield.html">QSqlField</a></span> fld <span class="operator">=</span> rec<span class="operator">.</span>field(i); model<span class="operator">-</span><span class="operator">></span>setData(model<span class="operator">-</span><span class="operator">></span>index(i<span class="operator">,</span> <span class="number">0</span>)<span class="operator">,</span> fld<span class="operator">.</span>name()); model<span class="operator">-</span><span class="operator">></span>setData(model<span class="operator">-</span><span class="operator">></span>index(i<span class="operator">,</span> <span class="number">1</span>)<span class="operator">,</span> fld<span class="operator">.</span>typeID() <span class="operator">=</span><span class="operator">=</span> <span class="operator">-</span><span class="number">1</span> <span class="operator">?</span> <span class="type"><a href="qstring.html">QString</a></span>(<span class="type"><a href="qvariant.html">QVariant</a></span><span class="operator">::</span>typeToName(fld<span class="operator">.</span>type())) : <span class="type"><a href="qstring.html">QString</a></span>(<span class="string">"%1 (%2)"</span>)<span class="operator">.</span>arg(<span class="type"><a href="qvariant.html">QVariant</a></span><span class="operator">::</span>typeToName(fld<span class="operator">.</span>type()))<span class="operator">.</span>arg(fld<span class="operator">.</span>typeID())); model<span class="operator">-</span><span class="operator">></span>setData(model<span class="operator">-</span><span class="operator">></span>index(i<span class="operator">,</span> <span class="number">2</span>)<span class="operator">,</span> fld<span class="operator">.</span>length()); model<span class="operator">-</span><span class="operator">></span>setData(model<span class="operator">-</span><span class="operator">></span>index(i<span class="operator">,</span> <span class="number">3</span>)<span class="operator">,</span> fld<span class="operator">.</span>precision()); model<span class="operator">-</span><span class="operator">></span>setData(model<span class="operator">-</span><span class="operator">></span>index(i<span class="operator">,</span> <span class="number">4</span>)<span class="operator">,</span> fld<span class="operator">.</span>requiredStatus() <span class="operator">=</span><span class="operator">=</span> <span class="operator">-</span><span class="number">1</span> <span class="operator">?</span> <span class="type"><a href="qvariant.html">QVariant</a></span>(<span class="string">"?"</span>) : <span class="type"><a href="qvariant.html">QVariant</a></span>(<span class="type">bool</span>(fld<span class="operator">.</span>requiredStatus()))); model<span class="operator">-</span><span class="operator">></span>setData(model<span class="operator">-</span><span class="operator">></span>index(i<span class="operator">,</span> <span class="number">5</span>)<span class="operator">,</span> fld<span class="operator">.</span>isAutoValue()); model<span class="operator">-</span><span class="operator">></span>setData(model<span class="operator">-</span><span class="operator">></span>index(i<span class="operator">,</span> <span class="number">6</span>)<span class="operator">,</span> fld<span class="operator">.</span>defaultValue()); } table<span class="operator">-</span><span class="operator">></span>setModel(model); table<span class="operator">-</span><span class="operator">></span>setEditTriggers(<span class="type"><a href="qabstractitemview.html">QAbstractItemView</a></span><span class="operator">::</span>NoEditTriggers); updateActions(); } <span class="type">void</span> Browser<span class="operator">::</span>insertRow() { <span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span>model <span class="operator">=</span> qobject_cast<span class="operator"><</span><span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span><span class="operator">></span>(table<span class="operator">-</span><span class="operator">></span>model()); <span class="keyword">if</span> (<span class="operator">!</span>model) <span class="keyword">return</span>; <span class="type"><a href="qmodelindex.html">QModelIndex</a></span> insertIndex <span class="operator">=</span> table<span class="operator">-</span><span class="operator">></span>currentIndex(); <span class="type">int</span> row <span class="operator">=</span> insertIndex<span class="operator">.</span>row() <span class="operator">=</span><span class="operator">=</span> <span class="operator">-</span><span class="number">1</span> <span class="operator">?</span> <span class="number">0</span> : insertIndex<span class="operator">.</span>row(); model<span class="operator">-</span><span class="operator">></span>insertRow(row); insertIndex <span class="operator">=</span> model<span class="operator">-</span><span class="operator">></span>index(row<span class="operator">,</span> <span class="number">0</span>); table<span class="operator">-</span><span class="operator">></span>setCurrentIndex(insertIndex); table<span class="operator">-</span><span class="operator">></span>edit(insertIndex); } <span class="type">void</span> Browser<span class="operator">::</span>deleteRow() { <span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span>model <span class="operator">=</span> qobject_cast<span class="operator"><</span><span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span><span class="operator">></span>(table<span class="operator">-</span><span class="operator">></span>model()); <span class="keyword">if</span> (<span class="operator">!</span>model) <span class="keyword">return</span>; model<span class="operator">-</span><span class="operator">></span>setEditStrategy(<span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span><span class="operator">::</span>OnManualSubmit); <span class="type"><a href="qmodelindex.html#QModelIndexList-typedef">QModelIndexList</a></span> currentSelection <span class="operator">=</span> table<span class="operator">-</span><span class="operator">></span>selectionModel()<span class="operator">-</span><span class="operator">></span>selectedIndexes(); <span class="keyword">for</span> (<span class="type">int</span> i <span class="operator">=</span> <span class="number">0</span>; i <span class="operator"><</span> currentSelection<span class="operator">.</span>count(); <span class="operator">+</span><span class="operator">+</span>i) { <span class="keyword">if</span> (currentSelection<span class="operator">.</span>at(i)<span class="operator">.</span>column() <span class="operator">!</span><span class="operator">=</span> <span class="number">0</span>) <span class="keyword">continue</span>; model<span class="operator">-</span><span class="operator">></span>removeRow(currentSelection<span class="operator">.</span>at(i)<span class="operator">.</span>row()); } model<span class="operator">-</span><span class="operator">></span>submitAll(); model<span class="operator">-</span><span class="operator">></span>setEditStrategy(<span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span><span class="operator">::</span>OnRowChange); updateActions(); } <span class="type">void</span> Browser<span class="operator">::</span>updateActions() { <span class="type">bool</span> enableIns <span class="operator">=</span> qobject_cast<span class="operator"><</span><span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span><span class="operator">></span>(table<span class="operator">-</span><span class="operator">></span>model()); <span class="type">bool</span> enableDel <span class="operator">=</span> enableIns <span class="operator">&</span><span class="operator">&</span> table<span class="operator">-</span><span class="operator">></span>currentIndex()<span class="operator">.</span>isValid(); insertRowAction<span class="operator">-</span><span class="operator">></span>setEnabled(enableIns); deleteRowAction<span class="operator">-</span><span class="operator">></span>setEnabled(enableDel); } <span class="type">void</span> Browser<span class="operator">::</span>about() { <span class="type"><a href="qmessagebox.html">QMessageBox</a></span><span class="operator">::</span>about(<span class="keyword">this</span><span class="operator">,</span> tr(<span class="string">"About"</span>)<span class="operator">,</span> tr(<span class="string">"The SQL Browser demonstration "</span> <span class="string">"shows how a data browser can be used to visualize the results of SQL"</span> <span class="string">"statements on a live database"</span>)); }</pre> </div> <!-- @@@demos/sqlbrowser/browser.cpp --> </div> </div> </div> <div class="ft"> <span></span> </div> </div> <div class="footer"> <p> <acronym title="Copyright">©</acronym> 2013 Digia Plc and/or its subsidiaries. Documentation contributions included herein are the copyrights of their respective owners.</p> <br /> <p> The documentation provided herein is licensed under the terms of the <a href="http://www.gnu.org/licenses/fdl.html">GNU Free Documentation License version 1.3</a> as published by the Free Software Foundation.</p> <p> Documentation sources may be obtained from <a href="http://www.qt-project.org"> www.qt-project.org</a>.</p> <br /> <p> Digia, Qt and their respective logos are trademarks of Digia Plc in Finland and/or other countries worldwide. All other trademarks are property of their respective owners. <a title="Privacy Policy" href="http://en.gitorious.org/privacy_policy/">Privacy Policy</a></p> </div> <script src="scripts/functions.js" type="text/javascript"></script> </body> </html>