MySQL: Building User Interfaces

MySQL: Building User Interfaces

by Matthew Stucky

Paperback

$42.08 $49.99 Save 16% Current price is $42.08, Original price is $49.99. You Save 16%.

Overview

MySQL: Designing User Interfaces starts by introducing the functionality of GTK+ and how to migrate from Microsoft's Visual Basic. It then introduces MySQL as a simple, fast, reliable database for corporate applications.

The book then flows into the how-to of combining GTK+ and MySQL through the coverage of the C API for MySQL because it is the "backend" to a GTK+ application. It then expands its coverage and teaches about heterogeneous network and deployment issues, as well as migration from existing systems to MySQL.

Product Details

ISBN-13: 9780735710498
Publisher: Sams
Publication date: 07/11/2001
Series: Landmark Series
Pages: 632
Product dimensions: 7.01(w) x 8.99(h) x 1.36(d)

Table of Contents

IQuick and Dirty1
1MySQL for Access and SQL Server Developers and DBAs3
Why You Should Use MySQL4
Licensing Issues4
Datatypes: MySQL Compared to Access 2000 and SQL Server 75
What MySQL Lacks7
MySQL, MYSQL, and mysql--They're Not the Same Thing12
For Access Converts Only: Daemons and Services15
Where to Get MySQL16
Deciding On an Installation Method: Pros and Cons17
What to Get for RPM Installation18
Installation19
The Whirlwind Tour: Creating, Accessing, and Dropping a Database23
Nonstandard or Unique SQL Constructs in MySQL (Extensions to ANSI SQL92)25
Utilities and Programs for MySQL30
MySQL's C API39
2GTK+ for VB Developers45
Why You Should Use GTK+46
Where to Get GTK+ and How to Install It47
Licensing Issues47
GTK+ Overview49
GTK+ Containers as Resizer Controls56
The Basic Widget Tour--As a Program57
3More GTK+ Widgets83
The GtkCombo Widget83
The GtkProgressBar and GtkStatusBar Widgets88
GtkFrame and GtkAspectFrame96
GtkDialog, GtkFileSelection, GtkColorSelectionDialog, and GtkFontSelectionDialog100
Menu Widget, ItemFactory, and Popup Menu Widgets109
4Advanced GTK+ Layout Widgets119
GtkTable119
GtkTree and GtkCTree125
GtkFixed131
GtkLayout134
GtkScrolledWindow136
GtkNotebook138
GtkPaned142
5Glade for VB Developers147
About Glade147
Diving Right In: HelloWorld Done with Glade149
HelloWorld Files Dissected158
Glade by the Widgets167
Project Design: Knowing Your Object Hierarchy171
Window-to-Window Communication in a Glade Project172
Global Variables and Good Software Engineering178
IIReal World Implementations181
Project 1Order Entry, a Simple Transactional Application
6Order Entry Abstract and Design183
Problem Definition and Design Issues184
User Interface187
Creating the Database191
Deploying the Application194
Upgrading the Application198
7Construction of the SESI Order Entry Application199
User Interface Construction with Glade200
Utility Functions of the Application212
Connecting the Interface to the Utility Functions252
Compiling the Program263
Project Post-Mortem264
Project 2Worldwide Commissions Application
8Commission Calculations Abstract and Design267
Problem Definition268
User Interface271
Database and Login Setup276
Creating the Database277
9Constructing the Commissions Application285
User Interface (UI) Construction with Glade285
The Data Display Control (DDC)291
Utility Functions of the Application294
The "Glue": callbacks.c328
Project Post-Mortem336
10Commission Calculations Deployment339
Compiling from the Command Line339
The Benefits of Using Make340
Deploying the Application342
Compiling for Win32 Using MS VC++355
Project 3Management Reporting, Key Business Indicators
11Management Reporting Abstract and Design365
Problem Definition365
User Interface366
Database and Login Setup370
Creating the Database371
12Management Reporting Construction375
Problem Definition375
The Controlling Application: KBI376
Report 1Tabular387
Report 2Pie Chart393
Report 3Bar/Line Chart404
Report 4Scatter Plot412
13Compiling the Key Business Indicators Application423
Compiling and Distributing via an RPM423
Compiling with MinGW for Win32429
IIIExample437
14Dynamic User Interface Control with XML439
HelloWorld!...One More Time439
Cross-Window Communication445
Changing the Application Without Recompiling454
IVAppendixes457
AGlade-Generated Files from the SESI Order Application459
interface.c460
sesi.glade489
BGlade-Generated Files from the Worldwide Commissions Application535
interface.c535
ssi.glade555
CGlade-Generated Files from the Key Business Indicators Application591
KBI Files591
Tabular Files596
Pie Chart Files601
bar_line Files606
Scatter Plot Files609
Index619

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews