WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

AppML Cases


This case study demonstrates how to build a complete <AppML> Internet application with the function of enumerating, editing and searching for several tables in the database.


What we will create

We will use an existing database called Demo.

For each table in the database, we will:

  • Creating a prototype
  • Creating a prototype HTML page
  • Creating an application model
  • Creating HTML templates
  • Creating a complete application

Demo database

For the case study, we used a subset of the Northwind database preinstalled by MS Office.

This database is well known, and it's easy to test whether it's using PHP, classic ASP, or ASP.NET.

The Demo database contains several tables with data, as follows:


Text Files

To exhibit how to get to content records, we have utilized document much like this:

cd_catalog.txt

Domain Burlesque,Bob Dylan,USA,Columbia,10.90,1985
Hide your heart,Bonnie Tyler,UK,CBS Records,9.90,1988
Greatest Hits,Dolly Parton,USA,RCA,9.90,1982
Still got the blues,Gary Moore,UK,Virgin records,10.20,1990
.
.

XML Files

To show how to get to XML records, we have utilized a document much like this:

cd_catalog.xml

<?xml version="1.0" encoding="ISO-8859-1"?>
<CATALOG>
<CD>
  <TITLE>Empire Burlesque</TITLE>
  <ARTIST>Bob Dylan</ARTIST>
  <COUNTRY>USA</COUNTRY>
  <COMPANY>Columbia</COMPANY>
  <PRICE>10.90</PRICE>
  <PUBLISHED>1985</PUBLISHED>
</CD>
<CD>
  <TITLE>Hide your heart</TITLE>
  <ARTIST>Bonnie Tyler</ARTIST>
  <COUNTRY>UK</COUNTRY>
  <COMPANY>CBS Records</COMPANY>
  <PRICE>9.90</PRICE>
  <PUBLISHED>1988</PUBLISHED>
</CD>
.
.

JSON Files

To demonstrate how to access JSON files, we have used a file much like this:

cd_catalog.js

{
"cd" : [
{ "title" : "Empire Burlesque", "artist" : "Bob Dylan", "price" : "10.90" },
{ "title" : "Hide your heart", "artist" : "Bonnie Tyler", "price" : "9.90" },
{ "title" : "Greatest Hits", "artist" : "Dolly Parton", "price" : "9.90" },
{ "title" : "Still got the blues", "artist" : "Gary Moore", "price" : "10.20" },
.
.

Databases

Our test database contains several tables like this:

Person

Person Address City Country
Around the Horn JHARKHAND LONDEN UNITED STATE
house Berguvsvägen 8 Luleå Sweden
Blauer See Delikatessen Forsterstr. 57 Mannheim Germany
Blondel père et fils 24, place Kléber Strasbourg France
Bólido Comidas preparadas C/Araquil, 67 Madrid Spain
Bottom-Dollar Markets 23 Tsawassen Blvd. Tsawassen Canada

Suppliers

Supplier Address City Country
Exotic Liquid 49 Gilbert St. London UK
New Orleans Cajun Delights P.O. Box 78934 New Orleans USA
Grandma Kelly's Homestead 707 Oxford Rd. Ann Arbor USA
Tokyo Traders 9-8 SekimaiMusashino-shi Tokyo Japan
Cooperativa de Quesos 'Las Cabras' Calle del Rosal 4 Oviedo Spain
Mayumi's 92 Setsuko Chuo-ku Osaka Japan
Pavlova, Ltd. 74 Rose St. Moonie Ponds Melbourne Australia
Specialty Biscuits, Ltd. 29 King's Way Manchester UK
PB Kn ckebr d AB Kaloadagatan 13 G teborg Sweden
Refrescos Americanas LTDA Av. das Americanas 12.890 S o Paulo Brazil

Products

Product Quantity Per Unit Unit Price Units In Stock
Chai 10 boxes x 20 bags 18 39
Chang 24 - 12 oz bottles 19 17
Aniseed Syrup 12 - 550 ml bottles 10 13
Chai 10 boxes x 20 bags 18 39
Chef Anton's Gumbo Mix 36 boxes 21 0
Grandma's Boysenberry Spread 12 - 8 oz jars 25 120
Uncle Bob's Organic Dried Pears 12 - 1 lb pkgs. 30 15
Northwoods Cranberry Sauce 12 - 12 oz jars 40 6
Mishi Kobe Niku 18 - 500 g pkgs. 97 29
Ikura 12 - 200 ml jars 31 31