Book Image

Google Web Toolkit 2 Application Development Cookbook

By : Shamsuddin Ahammad
Book Image

Google Web Toolkit 2 Application Development Cookbook

By: Shamsuddin Ahammad

Overview of this book

GWT 2 radically improves web experience for users by using existing Java tools to build no-compromise AJAX for any modern browser. It provides a solid platform so that other great libraries can be built on top of GWT. Creating web applications efficiently and making them impressive, however, is not as easy as it sounds. Writing web applications for multiple browsers can be quite tasking. In addition, building, reusing, and maintaining large JavaScript code bases and AJAX components can be difficult. GWT 2 Application Development Cookbook eases these burdens by allowing developers to quickly build and maintain complex yet highly efficient JavaScript front-end applications in the Java programming language . It tells you how to make web experience all the more thrilling and hassle free, using various tools along with GWT SDK.This book starts with developing an application from scratch. Right from creating the layout of the home page to home page elements including left and right sidebars, to placing tree like navigational menu, menu bars, tool bars, banners, footers are discussed with examples. You will see how to create forms using the Ext GWT library widgets and handle different types of events. Then you will move on to see how to design a database for sales processing systems and learn to create the database in MySQL with the help of easy–to-follow recipes. One of the interesting topics of this book is using JPA in GWT. Using the JPA object in GWT is a challenge. To use them perfectly, a mechanism to convert the JPA object into plain object and vice versa is required. You will see recipes to use entity classes, entity managers, and controller classes in GWT application. You will efficiently create reports with parameters, variables and subreports, and get the report output in both HTML and PDF format using real-world recipes. You will then learn to configure the GlassFish server to deploy a GWT application with database. Finally, learn how to trace speed and improve perfomance in web applications using tracing techniques.
Table of Contents (16 chapters)
Google Web Toolkit 2 Application Development Cookbook
Credits
About the Author
About the Reviewers
Preface
Index

Creating tables with primary key


In this recipe, we are going to create the table, Branch.

How to do it...

  1. Start the MySQL Query Browser.

  2. Double-click on Sales in Schemata to select the database.

  3. Right-click on the Sales database and select Create New Table.

  4. In the Table Editor, specify the Column Name, Datatype, and other constraints, as shown in the following screenshot:

  5. A "key" symbol is present on the left-hand side of the BranchId column name. This is the symbol for Primary Key. To set a primary key, just click on the icon appearing on the left-hand side of the column name.

  6. Click on Apply Changes to create the table.

  7. Click on Close.

Creating tables from MySQL Command Line Client

To create the Branch table from the Command Line Client, carry out the following steps:

  1. Start MySQL Command Line Client.

  2. Enter the Password.

  3. Change the database to Sales by writing the following command:

    USE Sales;
    
  4. Execute the following command:

    
    CREATE TABLE `sales`.`branch` (
    `BranchId` int(10) unsigned NOT NULL,
    `Name...