#include?“stdafx.h“

#include?
#include?“fastdb.h“
USE_FASTDB_NAMESPACE
class?Contract;
class?Detail?{?
??public:
????char?const*?name;
????char?const*?material;
????char?const*?color;
????real4???????weight;
????dbArray?>?contracts;
????TYPE_DEscriptOR（（KEY（name?INDEXED|HASHED）?
?????????????????????KEY（material?HASHED）?
?????????????????????KEY（color?HASHED）
?????????????????????KEY（weight?INDEXED）
?????????????????????RELATION（contracts?detail）））;
};
class?Supplier?{?
??public:
????char?const*?company;
????char?const*?location;
????bool????????foreign;
????dbArray?>?contracts;
????TYPE_DEscriptOR（（KEY（company?INDEXED|HASHED）?
?????????????????????KEY（location?HASHED）?
?????????????????????FIELD（foreign）
?????????????????????RELATION（contracts?supplier）））;
};

class?Contract?{?
??public:
????dbDateTime????????????delivery;
????int4??????????????????quantity;
????db_int8??????????????????price;
????dbReference???detail;
????dbReference?supplier;
????TYPE_DEscriptOR（（KEY（delivery?HASHED|INDEXED）?
?????????????????????KEY（quantity?INDEXED）?
?????????????????????KEY（price?INDEXED）
?????????????????????RELATION（detail?contracts）
?????????????????????RELATION（supplier?contracts）））;
};

REGISTER（Detail）;
REGISTER（Supplier）;
REGISTER（Contract）;
void?input（char?const*?prompt?char*?buf?size_t?buf_size）
{
????char*?p;
????do?{?
????????printf（prompt）;
????????*buf?=?‘\0‘;
????????fgets（buf?buf_size?stdin）;
????????p?=?buf?+?strlen（buf）;
????}?while?（p?<=?buf+1）;?
????
????if?（*（p-1）?==?‘\n‘）?{
????????*--p?=?‘\0‘;
????}
}
int?main（）?
{
????const?int?maxStrLen?=?256;
????dbDatabase?db;
????char?buf[maxStrLen];
????char?name[maxStrLen];
????char?company[maxStrLen];
????char?material[maxStrLen];
????char?address[maxStrLen];
????int?d?m?y;
????int?i?n;
????int?choice;
????int?quantity;
????db_int8?price;
????dbDateTime?from?till;
????Contract?contract;
????Supplier?supplier;
????Detail?detail;
????dbQuery?q1?q2?q3?q4?q6?q9?q10;
????q1?=?“exists?i:（contracts[i].supplier.company=“company“）“;
????q2?=?“name?like“name;
????q3?=?“supplier.location?=“address;
????q4?=?between（“delivery“?from?till）“and?price?>“price
????????“order?by“dbDateTime::ascent（“delivery“）;
????q6?=?“price?>=“price“or?quantity?>=“quantity;
????q9?=?“company?=“company;
????q10?=?“supplier.company?=“company“and?detail.name?like“name;
????dbCursor???details;
????dbCursor?contracts;
????dbCursor?suppliers;
????dbCursor?updateContracts（dbCursorForUpdate）;
????????
????if?（db.open（“testdb“））?{
????????while?（true）?{?
????????????printf（
“\n\n????MENU:\n1.??Details?shipped?by?supplier\n2.??Suppliers?of?the?detail\n3.??Contracts?from?specified?city\n4.??Expensive?details?to?be?delivered?in?specified?period\n5.??Foreign?suppliers\n6.??Importa

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件?????766044??2012-11-22?14:00??FastDb\Debug\FastDb.exe

?????文件?????724296??2012-11-22?14:00??FastDb\Debug\FastDb.ilk

?????文件?????213100??2012-11-22?14:00??FastDb\Debug\FastDb.obj

?????文件?????187184??2012-11-22?10:52??FastDb\Debug\FastDb.pch

?????文件????1295360??2012-11-22?14:00??FastDb\Debug\FastDb.pdb

?????文件???????2096??2012-11-22?10:52??FastDb\Debug\StdAfx.obj

?????文件?????254976??2012-11-22?14:07??FastDb\Debug\vc60.idb

?????文件?????356352??2012-11-22?14:00??FastDb\Debug\vc60.pdb

?????文件??????14095??2012-11-22?14:00??FastDb\FastDb.cpp

?????文件???????4567??2012-11-22?14:20??FastDb\FastDb.dsp

?????文件????????537??2012-11-22?10:48??FastDb\FastDb.dsw

?????文件??????41984??2012-11-22?14:20??FastDb\FastDb.ncb

?????文件??????48640??2012-11-22?14:20??FastDb\FastDb.opt

?????文件???????1374??2012-11-22?14:00??FastDb\FastDb.plg

?????文件???????1208??2012-11-22?10:48??FastDb\ReadMe.txt

?????文件????????293??2012-11-22?10:48??FastDb\StdAfx.cpp

?????文件????????667??2012-11-22?10:48??FastDb\StdAfx.h

?????文件????8388608??2012-11-22?14:00??FastDb\testdb.fdb

?????文件????????366??2012-11-22?14:21??使用說明.txt

?????文件?????271575??2012-11-20?17:36??fastdb-361\aclocal.m4

?????文件?????????74??2012-11-20?17:36??fastdb-361\AUTHORS

?????文件????1052729??2012-11-22?12:02??fastdb-361\bin\subsql.exe

?????文件????????608??2012-11-20?17:36??fastdb-361\buglogin.htm

?????文件??????44979??2012-11-20?17:36??fastdb-361\CHANGES

?????文件???????4100??2012-11-20?17:35??fastdb-361\CLI\cli.dsp

?????文件????????961??2012-11-22?12:01??fastdb-361\CLI\cli.plg

?????文件??????16218??2012-11-20?17:35??fastdb-361\CLI\cli.vcproj

?????文件?????250314??2012-11-22?12:01??fastdb-361\CLI\Debug\cli.lib

?????文件?????118527??2012-11-22?12:01??fastdb-361\CLI\Debug\cli.obj

?????文件??????34992??2012-11-22?12:01??fastdb-361\CLI\Debug\repsock.obj

............此處省略583個文件信息