当前位置: 首页 > 网络学院 > 客户端脚本教程 > APPML > 案例研究:数据库

APPML
AppML 简介
AppML 案例
AppML 案例说明
AppML 网络服务
案例研究简介
案例研究:数据库
案例研究:AppML
案例研究:HTML 报告
案例研究:HTML 表单
案例研究:目录
案例研究:产品
案例研究:托运人
案例研究:供应商
案例研究:客户
案例研究:雇员
案例研究:应用程序
案例研究:下载
AppML FAQ
AppML 文档
AppML 数据库元素

APPML 中的 案例研究:数据库


出处:互联网   整理: 软晨网(RuanChen.com)   发布: 2009-03-01   浏览: 927 ::
收藏到网摘: n/a

The AppML Case study uses the Northwind database.
AppML案例研究使用了North 数据库。


The Northwind Database
Northwind 数据库

The Northwind company has a traditional database model with data about customers, suppliers, products, orders, and employees.
Northwind 公司包含了一个关于客户数据、供应方数据、产品数据和雇员数据的传统数据库模型。

The information is stored in a database with 8 tables:
这份信息存储在数据库的8张表中:

  • Customers
    客户
  • Suppliers
    供应商
  • Products
    产品
  • Categories
    目录
  • Orders
    订单
  • Order Details
    订单细则
  • Shippers
    托运人
  • Employees
    雇员

Sample output from the database tables is displayed below. To save space we don't display all tables. We have also reduced the number of columns and rows.
数据库表单输出样本如下表。为了节省空间,我们并不现实所有的表。我们还去掉了相应的行和列。


Northwind Customers
Northwind 客户

CompanyName
公司名称
Address
地址
City
城市
Country
国家
Alfreds Futterkiste Obere Str. 57 Berlin Germany
Ana Trujillo Emparedados y heladoso Avda. de la Constituci 222 Mexico D.F. Mexico
Antonio Moreno Taquer韆 Mataderos 2312 M閤ico D.F. Mexico
Around the Horn 120 Hanover Sq. London UK
Berglunds snabbk鰌 Berguvsv鋑en 8 Lule?/td> Sweden
Blauer See Delikatessen Forsterstr. 57 Mannheim Germany
Blondel p鑢e et fils 24, place Kl閎er Strasbourg France
B髄ido Comidas preparadas C/ Araquil, 67 Madrid Spain
Bon app' 12, rue des Bouchers Marseille France
Bottom-Dollar Markets 23 Tsawassen Blvd. Tsawassen Canada


Northwind Suppliers
Northwind 供应商

CompanyName
公司名称
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鋍kebr鰀 AB Kaloadagatan 13 G鰐eborg Sweden
Refrescos Americanas LTDA Av. das Americanas 12.890 S鉶 Paulo Brazil


Northwind Products
Northwind 产品

ProductName
产品名称
QuantityPerUnit
单位数量
UnitPrice
单位价格
UnitsInStock
单位库存
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


Northwind Orders
Northwind 订单

CustomerID
客户ID
OrderDate
订购日期
ShipAddress
装船地址
ShipCity
装船城市
ShipCountry
装船国家
VINET 7/4/1996 59 rue de l Reims France
TOMSP 7/5/1996 Luisenstr. 48 M黱ster Germany
VICTE 7/8/1996 2, rue du Commerce Lyon France
SUPRD 7/9/1996 Boulevard Tirou, 255 Charleroi Belgium
HANAR 7/10/1996 Rua do Pa鏾, 67 Rio de Janeiro Brazil
CHOPS 7/11/1996 Hauptstr. 31 Bern Switzerland
RICSU 7/12/1996 Starenweg 5 Gen鑦e Switzerland
WELLI 7/15/1996 Rua do Mercado, 12 Resende Brazil
HILAA 7/16/1996 Carrera 22 con Ave. Carlos Soublette #8-35 San Crist骲al Venezuela
ERNSH 7/17/1996 Kirchgasse 6 Graz Austria


Northwind Employees
Northwind 雇员

LastName
FirstName

Title
标题
Davolio Nancy Sales Representative
Fuller Andrew Vice President, Sales
Leverling Janet Sales Representative
Peacock Margaret Sales Representative
Buchanan Steven Sales Manager
Suyama Michael Sales Representative
King Robert Sales Representative
Callahan Laura Inside Sales Coordinator
Dodsworth Anne Sales Representative


评论 (0) All

登陆 | 还没注册?