Before you can run this sample as an applet, you must install InterBase and create an ODBC alias pointing to the IntlDemo.gdb database. The following applet parameters defined in the APPLET tag within this .html file are used to make a connection to a database source.

Applet Parameter Name	Meaning	Default Value
url	URL to JDBC data source	jdbc:odbc:IntlDemo
user	user name for logging into database	SYSDBA
password	password for user name	masterkey
driver	name of JDBC driver used to connect to database	sun.jdbc.odbc.JdbcOdbcDriver

To start the applet, select this file in the project's navigation pane, and select 'Run | Run Applet in "IntlDemo.html" from the main menu. Note that because the use of an ODBC driver requires the loading of a .DLL file installed on the client, you will not be able to run this sample as an applet via a browser (such as the JDK1.1 appletviewer) unless you use a 100% pure java JDBC driver (such as Borland's DataGateway or InterBase's InterServer/InterClient) to connect with your web/database server. The basic steps are as follows:

1. Deploy this sample to a JAR file using the Deployment Wizard, including JBCL and JGL dependencies.
2. Add the names of the deployed JAR file and JAR or ZIP file containing your 100% Java client-side JDBC driver to an ARCHIVE tag in the applet in this .html file. (For example, if you were using the InterClient JDBC driver, the tag would be ARCHIVE="IntlDemoApplet.jar,interclient.jar". For DataGateway, the tag would be ARCHIVE="IntlDemoApplet.jar,DataGateway.zip".)
3. Modify the 'url', 'user', 'password' and 'driver' parameters of the APPLET tag in this .html file to correspond to the correct values for your JDBC driver. (If you are using the InterBase InterClient driver, the value of the 'driver' parameter would be "interbase.interclient.Driver" and the url parameter would be "jdbc:interbase://<server name or IP address>/<path to IntlDemo.gdb on your server>" For DataGateway, the 'driver' would be "borland.jdbc.Broker.RemoteDriver" and the url would be "jdbc:BorlandBroker://<server name or IP address>/<BDE alias>". You would need to create the BDE alias on the server using the BDE Administrator program supplied with DataGateway.)
4. Place the archive files and this .html file (which loads the applet) in a world-readable directory on your Web server.
5. Install and run the server-side component of your 100% Java JDBC driver on your Web server.  (If you are using InterBase, this would be the InterServer program.  For DataGateway, you would use the DataGateway Server program.)

Look in the documentation included with your JDBC driver for more detailed steps and information.
 

(In a Java-enabled Web browser, you would push the button appearing in this space to run the applet.)

Things to See and Do While Visiting The Borland Multilingual Store

• WelcomeFrame

• Double-click on a language leaf of the LocaleChooser Java Bean's locale tree to switch to a different locale (you can do this at any time while you're in the store).
• Grab the SplitPanel separator and resize the panes; note that the WrappingTextViewer Java Bean wraps lines of text appropriately for your current locale.
• Change your locale a few times, and note that the InternationalClock Java Bean formats the current time based on your current locale.
• Click on 'View Products' to browse the store's products.
• Click on ''View Previous Order' to view your previous order after you have placed an order.
• ProductFrame

• Click on the radio buttons to filter store products by category.
• Browse the store's available products, and note that the ViewOnlyNavigationBar Java Bean disables its buttons to let you know when you're at the end of a product category.
• Press 'Add to Order' to add the currently displayed product to your order.
• Press 'View Order' to view your current order.
• OrderFrame
• Enter your name and address information into the customer info area, and note that edit masks guide you through order entry. An AnnotatedEmptyItemPainter indicates which entries are required to complete your order.
• Select a credit card type, and enter a credit card number; an edit mask restricts you to entering only digits, and guides you through entering the correct digit pattern for your credit card choice.
• After ordering a product, double-click in the Quantity column and see how the IntegerSpinItemEditor helps you enter a new quantity.
• After you've ordered some products, change the exchange rate value to see what your order totals would be in your local currency.
• Press the 'Cancel Order' button to cancel your order.
• Press the 'Save Order' button to submit your order. Enter your password to complete the order. From the WelcomeFrame, click 'View a Previous Order' and then select yourself from the customer database to review your previous orders.

Summary of interesting classes and where they are used

• CheckboxPanel
• Used to filter products in the ProductFrame
• TreeControl
• Used to display tree of language/country locale pairs in LocaleChooser
• SplitPanel
• Facilitates dynamic resizing of panels within the WelcomeFrame
• MaskableTextItemEditor
• Restricts user keyboard input based upon a customizable entry pattern
• Used in the OrderFrame to enforce valid credit card no. entry
• PickListItemEditor
• Provides a list of choices in a dataset from which to make a selection.
• Restricts Size/Color selection for items ordered by availability in the OrderFrame

• DataModule
• Helps decouple the application's core functionality in AppDataModule from its GUI
• TextDataFile
• Provides application's data from local text files
• QueryDataSet
• Provides application's data from tables on a database server via SQL queries.
• DataSetExceptionHandler
• Replaced by ResourcedDataSetExceptionHandler to customize localized error messages
• CalcFieldListener
• For performing calculations on values of a row, such as an item's extended price or price in locale currency
• CalcAggFieldListener
• For performing summary calculations on groups of rows, such as the sum of item prices for the current order.
• RowFilterListener
• Used to restrict a dataset to a subset of rows, as in only displaying products for a specific category.
• MasterLink
• Maintains the master-detail relationship between two datasets, such as an order and the line items for the order.

• BasicOrderedTreeContainer
• Model/View custom model for sorting items added to the locale tree
• IntegerSpinEditor
• Model/View custom item editor for entering the quantity value for an order item
• AnnotatedEmptyItemPainter
• Model/View custom item painter which paints a 'required' string in empty controls
• LocaleChooser
• Model/View component for selecting a system locale.  Has its own custom property editors and also localized BeanInfo information.
• ViewOnlyNavigationBar
• Example of a data-aware component for read-only navigation of a dataset
• WrappingTextViewer
• Wraps text according to conventions for a particular locale, also a data-aware component
• LoadingFrame
• Displays an image and hourglass mouse cursor while the application is loading

Application Overview

The application can be viewed abstractly as being composed of three major parts--the data module, user interface, and locale manager.  The data module defines the data structures and logic used in the application.  It essentially consists of a Database component and several QueryDataSet components added to it and customized via the UI Designer.  It also exposes public methods used by the GUI to manage the state of the application.  For example, pressing the 'Add To Order' button of the ProductFrame calls the AddProductToOrderLineItem() method of the data module, which adds a row with information about the currently selected row of productsDataSet to orderLineItemDataSet.  The GridControl connected to orderLineItemDataSet is automatically notified of the change and updates its display automatically.  Similarly, other methods of the data module, typically triggered by events occurring on its DataSets, cause other changes to the application's state.  For example, inside the data module, a ColumnChangeListener is attached to the Quantity column of orderLineItemDataSet.  When the value in the Quantity column changes, the data module's quantityColumn_changed() method is triggered, which updates the row's extended price and the order's summary totals.  To get an overview of the data module, design AppDataModule.java in the UI Designer and examine the properties and events set in the Inspector for each DataSet's Column components.

The frames which comprise the user interface of the sample were also created using the UI Designer.  To allow the frames to be used for several different languages, they were all designed using dynamically sizable layout managers such as BorderLayout, GridLayout, or GridBagLayout in order to accomodate variable length text.  Also, the Resource Strings wizard was used to automatically extract hard-coded strings from visual components and place them into resource bundles which can be loaded dynamically at runtime based upon the user's current locale.

Finally, each component of the application was designed to be locale-sensitive and resourceable.  Each component registers itself with the LocaleChangeManager, which listens to the LocaleChooser bean for locale changes.  The LocaleChangeManager broadcasts a 'localeChanged' event to each of its registered listeners, which then update themselves accordingly to the new locale.  For example, each frame updates its visual components with strings obtained from the resource bundle for the new locale and redraws itself.  The data module similarly updates any visual data within its DataSets which needs to be localized.  

Some notes about the Java Beans used in the sample

The application opens by displaying the WelcomeFrame, which is composed of several Java Beans dropped into and customized in the UI Designer.  The LocaleChooser, WrappingTextViewer, and InternationalClock beans each have their own bean info classes which display localized property descriptions in the UI Designer's pop-up property hints.  LocaleChooser also demonstrates the use of a  custom property editor (actually the LocaleChooser itself) to customize its properties.  One very useful technique when debugging bean property editors in the UI Designer is to set the 'jbuilder.logOutput' flag in the \JBuilder\lib\jbuilder.properties file.  One can then write output from within a custom property editor to a log file or the console.

Pressing the 'Browse Products' button on the WelcomeFrame brings up the ProductFrame, from which the store's products can be browsed.  The frame uses the WrappingTextViewer's data-aware ability to display product descriptions from the productsDataSet in the data module.  The ViewOnlyNavigationBar is also a data-aware bean, which was connected via the UI Designer to the productsDataSet.  Pressing the navigation buttons calls navigation methods on the productsDataSet.  Because the WrappingTextViewer bean is also attached to productsDataSet, it automatically navigates in unison with the navigation bar.

The 'View Order' button of the ProductFrame displays the main order entry form, OrderFrame.  It contains several sample beans which take advantage of special features of JBuilder's Model-View component architecture to implement interesting behavior.  These beans can be dropped from the component palette and customized via the UI Designer.  The AnnotatedEmptyItemPainter bean, for example, is a custom 'item painter' which, when asked to paint, displays the word "<required>" if it doesn't have a value.  In the order line item area, the ResourceableItemPainter bean is used as the item painter for the 'description' column.  It takes a product id, looks up the id in a resource bundle, and displays the corresponding localized value.  Finally, the IntegerSpinItemEditor is an example of a custom 'item editor' used to control entry into the 'quantity' column.  It is composed of a MaskableTextItemEditor to restrict entries to digits and a ScrollBar to increase and decrease the entry value. Because its edit mask can be set dynamically, the MaskableTextItemEditor is also used as the item editor for the credit card no column.  When a credit card is selected, its edit mask is set to the appropriate digit entry pattern.
 

Adding Additional Locales to the sample

Adding Images as BLOB data to a database

Package Summary