MySQL: Building User Interfaces (Landmark)

ISBN: 073571049X
EAN: 2147483647

Year: 2001
Pages: 119

Authors: Matthew Stucky

BUY ON AMAZON

Starting Page
Table of Content
Front Matter
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
Part I: Quick and Dirty
Chapter 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 mysqlTheyre 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
MySQLs C API
Chapter 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 TourAs a Program
Chapter 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
Chapter 4. Advanced GTK Layout Widgets
GtkTable
GtkTree and GtkCTree
GtkFixed
GtkLayout
GtkScrolledWindow
GtkNotebook
GtkPaned
Chapter 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
Part II: Real World Implementations
Chapter 6. Order Entry Abstract and Design
Problem Definition and Design Issues
User Interface
Creating the Database
Deploying the Application
Upgrading the Application
Chapter 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
Chapter 8. Commission Calculations Abstract and Design
Problem Definition
User Interface
Database and Login Setup
Creating the Database
Chapter 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
Chapter 10. Commission Calculations Deployment
Compiling from the Command Line
The Benefits of Using Make
Deploying the Application
Compiling for Win32 Using MS VC
Chapter 11. Management Reporting Abstract and Design
Problem Definition
User Interface
Database and Login Setup
Creating the Database
Chapter 12. Management Reporting Construction
Problem Definition
The Controlling Application: KBI
Report 1: Tabular
Report 2: Pie Chart
Report 3: BarLine Chart
Report 4: Scatter Plot
Chapter 13. Compiling the Key Business Indicators Application
Compiling and Distributing Via an RPM
Compiling with MinGW for Win32
Part III: Example
Chapter 14. Dynamic User Interface Control with XML
HelloWorldOne More Time
Cross-Window Communication
Changing the Application Without Recompiling
Part IV: Appendixes
Appendix A. Glade-Generated Files from the SESI Order Application
interface.c
sesi.glade
Appendix B. Glade-Generated Files from the Worldwide Commissions Application
interface.c
sesi.glade
Appendix C. Glade-Generated Files from the Key Business Indicators Application
KBI Files
Tabular Files
Pie Chart Files
bar_line Files
Scatter Plot Files