MySQL: Building User Interfaces (Landmark)

MySQL Building User Interfaces

About the Author

About the Technical Reviewers

Acknowledgments

Tell Us What You Think

Introduction

     Who Should Read This Book

     Organization of This Book

     Conventions Used in This Book

I: Quick and Dirty

1. MySQL for Access and SQL Server Developers and DBAs

     Why You Should Use MySQL

     Licensing Issues

     Datatypes: MySQL Compared to Access 2000 and SQL Server 7

     What MySQL Lacks

     MySQL, MYSQL, and mysql ”They re Not the Same Thing

     For Access Converts Only: Daemons and Services

     Where to Get MySQL

     Deciding On an Installation Method: Pros and Cons

     What to Get for RPM Installation

     Installation

     The Whirlwind Tour: Creating, Accessing, and Dropping a Database

     Nonstandard or Unique SQL Constructs in MySQL (Extensions to ANSI SQL92)

     Utilities and Programs for MySQL

     MySQL s C API

2. GTK+ for VB Developers

     Why You Should Use GTK+

     Where to Get GTK+ and How to Install It

     Licensing Issues

     GTK+ Overview

     GTK+ Containers as Resizer Controls

     The Basic Widget Tour ”As a Program

3. More GTK+ Widgets

     The GtkCombo Widget

     The GtkProgressBar and GtkStatusBar Widgets

     GtkFrame and GtkAspectFrame

     GtkDialog, GtkFileSelection, GtkColorSelectionDialog, and GtkFontSelectionDialog

     Menu Widget, ItemFactory, and Popup Menu Widgets

4. Advanced GTK+ Layout Widgets

     GtkTable

     GtkTree and GtkCTree

     GtkFixed

     GtkLayout

     GtkScrolledWindow

     GtkNotebook

     GtkPaned

5. Glade for VB Developers

     About Glade

     Diving Right In: HelloWorld Done with Glade

     HelloWorld Files Dissected

     Glade by the Widgets

     Project Design: Knowing Your Object Hierarchy

     Window-to-Window Communication in a Glade Project

     Global Variables and Good Software Engineering

II: Real World Implementations

6. Order Entry Abstract and Design

     Problem Definition and Design Issues

     User Interface

     Creating the Database

     Deploying the Application

     Upgrading the Application

7. Construction of the SESI Order Entry Application

     User Interface Construction with Glade

     Utility Functions of the Application

     Connecting the Interface to the Utility Functions

     Compiling the Program

     Project Post-Mortem

8. Commission Calculations Abstract and Design

     Problem Definition

     User Interface

     Database and Login Setup

     Creating the Database

9. Constructing the Commissions Application

     User Interface (UI) Construction with Glade

     The Data Display Control (DDC)

     Utility Functions of the Application

     The Glue : callbacks.c

     Project Post-Mortem

10. Commission Calculations Deployment

     Compiling from the Command Line

     The Benefits of Using Make

     Deploying the Application

     Compiling for Win32 Using MS VC++

11. Management Reporting Abstract and Design

     Problem Definition

     User Interface

     Database and Login Setup

     Creating the Database

12. Management Reporting Construction

     Problem Definition

     The Controlling Application: KBI

     Report 1: Tabular

     Report 2: Pie Chart

     Report 3: Bar/Line Chart

     Report 4: Scatter Plot

13. Compiling the Key Business Indicators Application

     Compiling and Distributing Via an RPM

     Compiling with MinGW for Win32

III: Example

14. Dynamic User Interface Control with XML

     HelloWorld! One More Time

     Cross-Window Communication

     Changing the Application Without Recompiling

IV: Appendixes

A. Glade-Generated Files from the SESI Order Application

     interface.c

     sesi.glade

B. Glade-Generated Files from the Worldwide Commissions Application

     interface.c

     sesi.glade

C. Glade-Generated Files from the Key Business Indicators Application

     KBI Files

     Tabular Files

     Pie Chart Files

     bar_line Files

     Scatter Plot Files