File: sql-programming.html

package info (click to toggle)
qt4-x11 4%3A4.8.2%2Bdfsg-11
  • links: PTS, VCS
  • area: main
  • in suites: wheezy
  • size: 701,696 kB
  • sloc: cpp: 2,686,179; ansic: 375,485; python: 25,859; sh: 19,349; xml: 17,091; perl: 14,765; yacc: 5,383; asm: 5,038; makefile: 1,259; lex: 555; ruby: 526; objc: 347; cs: 112; pascal: 112; php: 54; sed: 34
file content (120 lines) | stat: -rw-r--r-- 8,497 bytes parent folder | download 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
 
<?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" />
<!-- sql-programming.qdoc -->
  <title>Qt 4.8: SQL Programming</title>
  <link rel="stylesheet" type="text/css" href="style/offline.css" />
</head>
<body>
<div class="header" id="qtdocheader">
  <div class="content"> 
    <a href="index.html" class="qtref"><span>Qt Reference Documentation</span></a>
  </div>
  <div class="breadcrumb toolblock">
    <ul>
      <li class="first"><a href="index.html">Home</a></li>
      <!--  Breadcrumbs go here -->
<li>SQL Programming</li>
    </ul>
  </div>
</div>
<div class="content mainContent">
  <link rel="next" href="sql-connecting.html" />
<p class="naviNextPrevious headerNavi">
<a class="nextPage" href="sql-connecting.html">Connecting to Databases</a>
</p><p/>
<div class="toc">
<h3><a name="toc">Contents</a></h3>
<ul>
<li class="level1"><a href="#topics">Topics:</a></li>
<li class="level1"><a href="#database-classes">Database Classes</a></li>
<li class="level2"><a href="#driver-layer">Driver Layer</a></li>
<li class="level2"><a href="#sql-api-layer">SQL API Layer</a></li>
<li class="level2"><a href="#user-interface-layer">User Interface Layer</a></li>
</ul>
</div>
<h1 class="title">SQL Programming</h1>
<span class="subtitle"></span>
<!-- $$$sql-programming.html-description -->
<div class="descr"> <a name="details"></a>
<p>This overview assumes that you have at least a basic knowledge of SQL. You should be able to understand simple <tt>SELECT</tt>, <tt>INSERT</tt>, <tt>UPDATE</tt>, and <tt>DELETE</tt> statements. Although the <a href="qsqltablemodel.html">QSqlTableModel</a> class provides an interface to database browsing and editing that does not require a knowledge of SQL, a basic understanding of SQL is highly recommended. A standard text covering SQL databases is <i>An Introduction to Database Systems</i> (7th Ed.) by C. J. Date, ISBN 0201385902.</p>
<a name="topics"></a>
<h2>Topics:</h2>
<ul>
<li><a href="database.html">Database Classes</a></li>
<li><a href="sql-connecting.html">Connecting to Databases</a><ul>
<li><a href="sql-driver.html">SQL Database Drivers</a></li>
</ul>
</li>
<li><a href="sql-sqlstatements.html">Executing SQL Statements</a><ul>
<li><a href="sql-types.html">Data Types for Qt-supported Database Systems</a></li>
</ul>
</li>
<li><a href="sql-model.html">Using the SQL Model Classes</a></li>
<li><a href="sql-presenting.html">Presenting Data in a Table View</a></li>
<li><a href="sql-forms.html">Creating Data-Aware Forms</a></li>
</ul>
<a name="database-classes"></a>
<h2>Database Classes</h2>
<p>These classes provide access to SQL databases.</p>
<table class="annotated">
<tr class="odd topAlign"><td class="tblName"><p><a href="qsql.html">QSql</a></p></td><td class="tblDescr"><p>Contains miscellaneous identifiers used throughout the Qt SQL library</p></td></tr>
<tr class="even topAlign"><td class="tblName"><p><a href="qsqldatabase.html">QSqlDatabase</a></p></td><td class="tblDescr"><p>Represents a connection to a database</p></td></tr>
<tr class="odd topAlign"><td class="tblName"><p><a href="qsqldriver.html">QSqlDriver</a></p></td><td class="tblDescr"><p>Abstract base class for accessing specific SQL databases</p></td></tr>
<tr class="even topAlign"><td class="tblName"><p><a href="qsqldrivercreator.html">QSqlDriverCreator</a></p></td><td class="tblDescr"><p>Template class that provides a SQL driver factory for a specific driver type</p></td></tr>
<tr class="odd topAlign"><td class="tblName"><p><a href="qsqldrivercreatorbase.html">QSqlDriverCreatorBase</a></p></td><td class="tblDescr"><p>The base class for SQL driver factories</p></td></tr>
<tr class="even topAlign"><td class="tblName"><p><a href="qsqlerror.html">QSqlError</a></p></td><td class="tblDescr"><p>SQL database error information</p></td></tr>
<tr class="odd topAlign"><td class="tblName"><p><a href="qsqlfield.html">QSqlField</a></p></td><td class="tblDescr"><p>Manipulates the fields in SQL database tables and views</p></td></tr>
<tr class="even topAlign"><td class="tblName"><p><a href="qsqlindex.html">QSqlIndex</a></p></td><td class="tblDescr"><p>Functions to manipulate and describe database indexes</p></td></tr>
<tr class="odd topAlign"><td class="tblName"><p><a href="qsqlquery.html">QSqlQuery</a></p></td><td class="tblDescr"><p>Means of executing and manipulating SQL statements</p></td></tr>
<tr class="even topAlign"><td class="tblName"><p><a href="qsqlquerymodel.html">QSqlQueryModel</a></p></td><td class="tblDescr"><p>Read-only data model for SQL result sets</p></td></tr>
<tr class="odd topAlign"><td class="tblName"><p><a href="qsqlrecord.html">QSqlRecord</a></p></td><td class="tblDescr"><p>Encapsulates a database record</p></td></tr>
<tr class="even topAlign"><td class="tblName"><p><a href="qsqlrelationaltablemodel.html">QSqlRelationalTableModel</a></p></td><td class="tblDescr"><p>Editable data model for a single database table, with foreign key support</p></td></tr>
<tr class="odd topAlign"><td class="tblName"><p><a href="qsqlresult.html">QSqlResult</a></p></td><td class="tblDescr"><p>Abstract interface for accessing data from specific SQL databases</p></td></tr>
<tr class="even topAlign"><td class="tblName"><p><a href="qsqltablemodel.html">QSqlTableModel</a></p></td><td class="tblDescr"><p>Editable data model for a single database table</p></td></tr>
</table>
<p>The SQL classes are divided into three layers:</p>
<a name="driver-layer"></a>
<h3>Driver Layer</h3>
<p>This comprises the classes <a href="qsqldriver.html">QSqlDriver</a>, <a href="qsqldrivercreator.html">QSqlDriverCreator</a>&lt;T&gt;, <a href="qsqldrivercreatorbase.html">QSqlDriverCreatorBase</a>, <a href="qsqldriverplugin.html">QSqlDriverPlugin</a>, and <a href="qsqlresult.html">QSqlResult</a>.</p>
<p>This layer provides the low-level bridge between the specific databases and the SQL API layer. See <a href="sql-driver.html">SQL Database Drivers</a> for more information.</p>
<a name="sql-api-layer"></a>
<h3>SQL API Layer</h3>
<p>These classes provide access to databases. Connections are made using the <a href="qsqldatabase.html">QSqlDatabase</a> class. Database interaction is achieved by using the <a href="qsqlquery.html">QSqlQuery</a> class. In addition to <a href="qsqldatabase.html">QSqlDatabase</a> and <a href="qsqlquery.html">QSqlQuery</a>, the SQL API layer is supported by <a href="qsqlerror.html">QSqlError</a>, <a href="qsqlfield.html">QSqlField</a>, <a href="qsqlindex.html">QSqlIndex</a>, and <a href="qsqlrecord.html">QSqlRecord</a>.</p>
<a name="user-interface-layer"></a>
<h3>User Interface Layer</h3>
<p>These classes link the data from a database to data-aware widgets. They include <a href="qsqlquerymodel.html">QSqlQueryModel</a>, <a href="qsqltablemodel.html">QSqlTableModel</a>, and <a href="qsqlrelationaltablemodel.html">QSqlRelationalTableModel</a>. These classes are designed to work with Qt's <a href="model-view-programming.html">model/view framework</a>.</p>
<p>Note that to use any of these classes, a <a href="qcoreapplication.html">QCoreApplication</a> object must have been instantiated first.</p>
</div>
<!-- @@@sql-programming.html -->
<p class="naviNextPrevious footerNavi">
<a class="nextPage" href="sql-connecting.html">Connecting to Databases</a>
</p>
  <div class="ft">
    <span></span>
  </div>
</div> 
<div class="footer">
    <p>
      <acronym title="Copyright">&copy;</acronym> 2012 Nokia Corporation 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>
      Nokia, Qt and their respective logos are trademarks of Nokia Corporation 
      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>
</body>
</html>