Qt SQL Classes
This chapter gives a general introduction to the capabilities of Qt's SQL classes, using MySQL as an example back end.
|
18.1 |
Introduction to MySQL |
424 |
|
18.2 |
Queries and Result Sets |
427 |
|
18.3 |
Database Models |
429 |
Qt 4 provides a platform-neutral database interface similar to JDBC but without the annoying mandatory exception-handling code. You can use Qt to connect to a variety of different SQL databases, including Oracle, PostgreSQL, and SybaseSQL. In the examples that follow, we use MySQL[1] because it
[1] http://dev.mysql.com/doc/
- Is open source
- Is available on all platforms
- Comes pre-installed on most Linux distributions
- Has excellent documentation
- Is very widely used
Introduction to MySQL |
Part I: Introduction to C++ and Qt 4
C++ Introduction
- C++ Introduction
- Overview of C++
- A Brief History of C++
- Setup: Open-Source Platforms
- Setup: Win32
- C++ First Example
- Input and Output
- Identifiers, Types, and Literals
- C++ Simple Types
- C++ Standard Library Strings
- Streams
- The Keyword const
- Pointers and Memory Access
- const* and *const
- Reference Variables
- Points of Departure
- Review Questions
Classes
- Classes
- Structs
- Class Definitions
- Member Access Specifiers
- Encapsulation
- Introduction to UML
- Friends of a Class
- Constructors
- Subobjects
- Destructors
- The Keyword static
- Copy Constructors and Assignment Operators
- Conversions
- const Member Functions
- Review Questions
Introduction to Qt
- Introduction to Qt
- Example Project: Using QApplication and QLabel
- Makefile, qmake, and Project Files
- Getting Help Online
- Style Guidelines and Naming Conventions
- The Qt Core Module
- Streams and Dates
- Points of Departure
- Review Questions
Lists
Functions
- Functions
- Function Declarations
- Overloading Functions
- Optional Arguments
- Operator Overloading
- Parameter Passing by Value
- Parameter Passing by Reference
- References to const
- Function Return Values
- Returning References from Functions
- Overloading on const-ness
- Inline Functions
- Inlining versus Macro Expansion
- Review Questions
Inheritance and Polymorphism
- Inheritance and Polymorphism
- Simple Derivation
- Derivation with Polymorphism
- Derivation from an Abstract Base Class
- Inheritance Design
- Overloading, Hiding, and Overriding
- Constructors, Destructors, and Copy Assignment Operators
- Processing Command-Line Arguments
- Points of Departure
- Review Questions
Part II: Higher-Level Programming
Libraries
- Libraries
- Code Containers
- Reusing Other Libraries
- Organizing Libraries: Dependency Management
- Installing Libraries: A Lab Exercise
- Frameworks and Components
- Review Questions
Introduction to Design Patterns
QObject
- QObject
- QObjects Child Managment
- Composite Pattern: Parents and Children
- QApplication and the Event Loop
- Q_OBJECT and moc: A Checklist
- Values and Objects
- tr() and Internationalization
- Point of Departure
- Review Questions
Generics and Containers
- Generics and Containers
- Generics and Templates
- Containers
- Managed Containers, Composites, and Aggregates
- Implicitly Shared Classes
- Generics, Algorithms, and Operators
- Serializer Pattern
- Sorted Map Example
- Review Questions
Qt GUI Widgets
- Qt GUI Widgets
- Widget Categories
- QMainWindow and QSettings
- Dialogs
- Images and Resources
- Layout of Widgets
- QActions, QMenus, and QMenuBars
- QActions, QToolbars, and QActionGroups
- Regions and QDockWidgets
- Views of a QStringList
- Points of Departure
- Review Questions
Concurrency
- Concurrency
- QProcess and Process Control
- Threads and QThread
- Summary: QProcess and QThread
- Review Questions
Validation and Regular Expressions
- Validation and Regular Expressions
- Validators
- Regular Expressions
- Regular Expression Validation
- Review Questions
Parsing XML
Meta Objects, Properties, and Reflective Programming
- Meta Objects, Properties, and Reflective Programming
- Anti-patterns
- QMetaObject: The MetaObject Pattern
- Type Identification and qobject_cast
- Q_PROPERTY Macro: Describing QObject Properties
- QVariant Class: Accessing Properties
- DataObject: An Extension of QObject
- Property Containers: PropsMap
- Review Questions
More Design Patterns
- More Design Patterns
- Creational Patterns
- Serializer Pattern Revisited
- The Façade Pattern
- Points of Departure
- Review Questions
Models and Views
- Models and Views
- M-V-C: What about the Controller?
- Dynamic Form Models
- Qt 4 Models and Views
- Table Models
- Tree Models
- Review Questions
Qt SQL Classes
Part III: C++ Language Reference
Types and Expressions
- Types and Expressions
- Operators
- Evaluation of Logical Expressions
- Enumerations
- Signed and Unsigned Integral Types
- Standard Expression Conversions
- Explicit Conversions
- Safer Typecasting Using ANSI C++ Typecasts
- Run-Time Type Identification (RTTI)
- Member Selection Operators
- Point of Departure
- Review Questions
Scope and Storage Class
- Scope and Storage Class
- Declarations and Definitions
- Identifier Scope
- Storage Class
- Namespaces
- Review Questions
Statements and Control Structures
Memory Access
- Memory Access
- Pointer Pathology
- Further Pointer Pathology with Heap Memory
- Memory Access Summary
- Introduction to Arrays
- Pointer Arithmetic
- Arrays, Functions, and Return Values
- Different Kinds of Arrays
- Valid Pointer Operations
- What Happens If new Fails?
Chapter Summary
Inheritance in Detail
- Inheritance in Detail
- Virtual Pointers and Virtual Tables
- Polymorphism and virtual Destructors
- Multiple Inheritance
- Point of Departure
- public, protected, and private Derivation
- Review Questions
Miscellaneous Topics
Part IV: Programming Assignments
MP3 Jukebox Assignments
- MP3 Jukebox Assignments
- Data Model: Mp3File
- Visitor: Generating Playlists
- Preference: An Enumerated Type
- Reusing id3lib
- PlayListModel Serialization
- Testing Mp3File Related Classes
- Simple Queries and Filters
- Mp3PlayerView
- Models and Views: PlayList
- Source Selector
- Persistent Settings
- Edit Form View for FileTagger
- Points of Departure
Part V: Appendices
MP3 Jukebox Assignments
- MP3 Jukebox Assignments
- Appendix A. C++ Reserved Keywords
- Appendix B. Standard Headers
- Appendix C. The Development Environment
- Section C.1. The Preprocessor: For #including Files
- Section C.2. Understanding the Linker
- Section C.3. Debugging
- Section C.4. Qt Assistant and Designer
- Section C.5. Open-Source IDEs and Development Tools
Bibliography
MP3 Jukebox Assignments
EAN: 2147483647
Pages: 268
