lili/qt4-x11
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
qt4-x11/doc/html/demos-sqlbrowser-browser-cpp.html
lili 35a2a1d584 init
2025-08-24 20:55:26 +08:00

449 lines
39 KiB
HTML
Raw Permalink Blame History

<?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 &amp; 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>&nbsp;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 &amp; 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) 2015 The Qt Company Ltd.
** Contact: http://www.qt.io/licensing/
**
** 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 The Qt Company. For licensing terms
** and conditions see http://www.qt.io/terms-conditions. For further
** information use the contact form at http://www.qt.io/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 or version 3 as published by the Free
** Software Foundation and appearing in the file LICENSE.LGPLv21 and
** LICENSE.LGPLv3 included in the packaging of this file. Please review the
** following information to ensure the GNU Lesser General Public License
** requirements will be met: https://www.gnu.org/licenses/lgpl.html and
** http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html.
**
** As a special exception, The Qt Company gives you certain additional
** rights. These rights are described in The Qt Company 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 &quot;browser.h&quot;</span>
<span class="preprocessor">#include &quot;qsqlconnectiondialog.h&quot;</span>
<span class="preprocessor">#include &lt;QtGui&gt;</span>
<span class="preprocessor">#include &lt;QtSql&gt;</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">&gt;</span>addAction(insertRowAction);
table<span class="operator">-</span><span class="operator">&gt;</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">&quot;No database drivers found&quot;</span>)<span class="operator">,</span>
tr(<span class="string">&quot;This demo requires at least one Qt database driver. &quot;</span>
<span class="string">&quot;Please check the documentation how to build the &quot;</span>
<span class="string">&quot;Qt SQL plugins.&quot;</span>));
<span class="keyword">emit</span> statusMessage(tr(<span class="string">&quot;Ready.&quot;</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">&gt;</span>setQuery(<span class="type"><a href="qsqlquery.html">QSqlQuery</a></span>(sqlEdit<span class="operator">-</span><span class="operator">&gt;</span>toPlainText()<span class="operator">,</span> connectionWidget<span class="operator">-</span><span class="operator">&gt;</span>currentDatabase()));
table<span class="operator">-</span><span class="operator">&gt;</span>setModel(model);
<span class="keyword">if</span> (model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</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">&gt;</span>query()<span class="operator">.</span>isSelect())
<span class="keyword">emit</span> statusMessage(tr(<span class="string">&quot;Query OK.&quot;</span>));
<span class="keyword">else</span>
<span class="keyword">emit</span> statusMessage(tr(<span class="string">&quot;Query OK, number of affected rows: %1&quot;</span>)<span class="operator">.</span>arg(
model<span class="operator">-</span><span class="operator">&gt;</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">&amp;</span>driver<span class="operator">,</span> <span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&amp;</span>dbName<span class="operator">,</span> <span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&amp;</span>host<span class="operator">,</span>
<span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&amp;</span>user<span class="operator">,</span> <span class="keyword">const</span> <span class="type"><a href="qstring.html">QString</a></span> <span class="operator">&amp;</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">&quot;Browser%1&quot;</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">&quot;Browser%1&quot;</span>)<span class="operator">.</span>arg(cCount));
}
connectionWidget<span class="operator">-</span><span class="operator">&gt;</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">&quot;in_mem_db&quot;</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">&quot;in_mem_db&quot;</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">&quot;QSQLITE&quot;</span><span class="operator">,</span> <span class="string">&quot;in_mem_db&quot;</span>);
db<span class="operator">.</span>setDatabaseName(<span class="string">&quot;:memory:&quot;</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">&quot;Unable to open database&quot;</span>)<span class="operator">,</span> tr(<span class="string">&quot;An error occurred while &quot;</span>
<span class="string">&quot;opening the connection: &quot;</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">&quot;&quot;</span><span class="operator">,</span> db);
q<span class="operator">.</span>exec(<span class="string">&quot;drop table Movies&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;drop table Names&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;create table Movies (id integer primary key, Title varchar, Director varchar, Rating number)&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Movies values (0, 'Metropolis', 'Fritz Lang', '8.4')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Movies values (1, 'Nosferatu, eine Symphonie des Grauens', 'F.W. Murnau', '8.1')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Movies values (2, 'Bis ans Ende der Welt', 'Wim Wenders', '6.5')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Movies values (3, 'Hardware', 'Richard Stanley', '5.2')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Movies values (4, 'Mitchell', 'Andrew V. McLaglen', '2.1')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;create table Names (id integer primary key, Firstname varchar, Lastname varchar, City varchar)&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Names values (0, 'Sala', 'Palmer', 'Morristown')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Names values (1, 'Christopher', 'Walker', 'Morristown')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Names values (2, 'Donald', 'Duck', 'Andeby')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Names values (3, 'Buck', 'Rogers', 'Paris')&quot;</span>);
q<span class="operator">.</span>exec(<span class="string">&quot;insert into Names values (4, 'Sherlock', 'Holmes', 'London')&quot;</span>);
connectionWidget<span class="operator">-</span><span class="operator">&gt;</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">&quot;Unable to open database&quot;</span>)<span class="operator">,</span> tr(<span class="string">&quot;An error occurred while &quot;</span>
<span class="string">&quot;opening the connection: &quot;</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">&amp;</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">&gt;</span>currentDatabase());
model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>setTable(connectionWidget<span class="operator">-</span><span class="operator">&gt;</span>currentDatabase()<span class="operator">.</span>driver()<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>select();
<span class="keyword">if</span> (model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>lastError()<span class="operator">.</span>text());
table<span class="operator">-</span><span class="operator">&gt;</span>setModel(model);
table<span class="operator">-</span><span class="operator">&gt;</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">&gt;</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">&amp;</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">&gt;</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">&gt;</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">&gt;</span>insertColumns(<span class="number">0</span><span class="operator">,</span> <span class="number">7</span>);
model<span class="operator">-</span><span class="operator">&gt;</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">&quot;Fieldname&quot;</span>);
model<span class="operator">-</span><span class="operator">&gt;</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">&quot;Type&quot;</span>);
model<span class="operator">-</span><span class="operator">&gt;</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">&quot;Length&quot;</span>);
model<span class="operator">-</span><span class="operator">&gt;</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">&quot;Precision&quot;</span>);
model<span class="operator">-</span><span class="operator">&gt;</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">&quot;Required&quot;</span>);
model<span class="operator">-</span><span class="operator">&gt;</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">&quot;AutoValue&quot;</span>);
model<span class="operator">-</span><span class="operator">&gt;</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">&quot;DefaultValue&quot;</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">&lt;</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">&gt;</span>setData(model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>setData(model<span class="operator">-</span><span class="operator">&gt;</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">&quot;%1 (%2)&quot;</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">&gt;</span>setData(model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>setData(model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>setData(model<span class="operator">-</span><span class="operator">&gt;</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">&quot;?&quot;</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">&gt;</span>setData(model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>setData(model<span class="operator">-</span><span class="operator">&gt;</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">&gt;</span>setModel(model);
table<span class="operator">-</span><span class="operator">&gt;</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">&lt;</span><span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span><span class="operator">&gt;</span>(table<span class="operator">-</span><span class="operator">&gt;</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">&gt;</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">&gt;</span>insertRow(row);
insertIndex <span class="operator">=</span> model<span class="operator">-</span><span class="operator">&gt;</span>index(row<span class="operator">,</span> <span class="number">0</span>);
table<span class="operator">-</span><span class="operator">&gt;</span>setCurrentIndex(insertIndex);
table<span class="operator">-</span><span class="operator">&gt;</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">&lt;</span><span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span><span class="operator">&gt;</span>(table<span class="operator">-</span><span class="operator">&gt;</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">&gt;</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">&gt;</span>selectionModel()<span class="operator">-</span><span class="operator">&gt;</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">&lt;</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">&gt;</span>removeRow(currentSelection<span class="operator">.</span>at(i)<span class="operator">.</span>row());
}
model<span class="operator">-</span><span class="operator">&gt;</span>submitAll();
model<span class="operator">-</span><span class="operator">&gt;</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">&lt;</span><span class="type"><a href="qsqltablemodel.html">QSqlTableModel</a></span> <span class="operator">*</span><span class="operator">&gt;</span>(table<span class="operator">-</span><span class="operator">&gt;</span>model());
<span class="type">bool</span> enableDel <span class="operator">=</span> enableIns <span class="operator">&amp;</span><span class="operator">&amp;</span> table<span class="operator">-</span><span class="operator">&gt;</span>currentIndex()<span class="operator">.</span>isValid();
insertRowAction<span class="operator">-</span><span class="operator">&gt;</span>setEnabled(enableIns);
deleteRowAction<span class="operator">-</span><span class="operator">&gt;</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">&quot;About&quot;</span>)<span class="operator">,</span> tr(<span class="string">&quot;The SQL Browser demonstration &quot;</span>
<span class="string">&quot;shows how a data browser can be used to visualize the results of SQL&quot;</span>
<span class="string">&quot;statements on a live database&quot;</span>));
}</pre>
</div>
<!-- @@@demos/sqlbrowser/browser.cpp -->
</div>
</div>
</div>
<div class="ft">
<span></span>
</div>
</div>
<div class="footer">
<p>
<acronym title="Copyright">&copy;</acronym> 2015 The Qt Company Ltd.
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>
Qt and respective logos are trademarks of The Qt Company Ltd
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>
Reference in New Issue View Git Blame Copy Permalink