икористаних джерел
1. А Я. Архангельський, Програмування в C ++ Builder 6 raquo ;.- М .: БІНОМ raquo ;, 2003
2. Борі Х., FIREBIRD. Керівництво розробника баз даних raquo ;.- С-Пб .: БХВ raquo ;, 2006 р 2-е видання.
. Шамис В., Borland C ++ Builder 6.0 raquo ;.- С - Пб .: Пітер raquo ;, 2005
. Похомов Б.І. C C ++ і Borland C ++ Builder для студента. СПб .: БХВ-Петербург, 2006. - 448с.
. Хомоненко А.Д., Ададуров С.Є. Робота з базами даних в C ++ Builder.- СПб .: БХВ-Петербург, 2006. - 496 с: ил.
6. lt; # center gt; Програми
Додаток 1. SQL код створення БД
Створення таблиць
Читач
/*** Tables ***/
/***************************************** *******************/
CREATE TABLE CHITATEL (_CHITATELYA D_NAME/* D_NAME=VARCHAR (45) NOT NULL * /, _ CHITATELYA D_NAME/* D_NAME=VARCHAR (45) NOT NULL * /, D_NAME/* D_NAME=VARCHAR (45 ) NOT NULL * /, D_NAME/* D_NAME=VARCHAR (45) NOT NULL * /, _ DOMA D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, D_TEL/* D_TEL=VARCHAR (15) * /, _ CHITATELYA D_INDEXTYPE NOT NULL/* D_INDEXTYPE=INTEGER NOT NULL */
);
/***************************************** *******************/
/*** Primary Keys ***/
/***************************************** *******************/TABLE CHITATEL ADD PRIMARY KEY (NOMER_CHITATELYA);
/***************************************** ******************/
/*** Indices ***/
/***************************************** *******************/
CREATE INDEX FAMILIYA_CHITATELYA ON CHITATEL (FAMILIYA_CHITATELYA); INDEX ULICA ON CHITATEL (ULICA);
/***************************************** *******************/
/*** Triggers for tables ***/
/***************************************** *******************/
/* Trigger: CHITATEL_BI0 */OR ALTER TRIGGER CHITATEL_BI0 FOR CHITATELBEFORE INSERT OR UPDATE POSITION 0 (NEW. nomer_chitatelya is null) then. nomer_chitatelya=gen_id (gen_chitatel, 1);
^
SET TERM; ^
/* Fields descriptions */ON COLUMN CHITATEL. NOMER_DOMA IS
VALUE gt; 0 raquo ;;
/***************************************** *******************/
/*** Privileges ***/
/***************************************** *******************/
Бібліотекар
CREATE TABLE BIBLIOTEKOR (_BIBLIOTEKORYA D_INDEXTYPE NOT NULL/* D_INDEXTYPE=INTEGER NOT NULL * /, _ OTDELA D_INDEXTYPE/* D_INDEXTYPE=INTEGER NOT NULL * /, _ BIBLIOTEKORYA D_NAME/* D_NAME=VARCHAR (45) NOT NULL * /, _ BIBLIOTEKORYA D_NAME/* D_NAME=VARCHAR (45) NOT NULL */
);
/***************************************** *******************/
/*** Primary Keys ***/
/***************************************** *******************/TABLE BIBLIOTEKOR ADD CONSTRAINT PK_BIBLIOTEKOR PRIMARY KEY (NOMER_BIBLIOTEKORYA);
/***************************************** *******************/
/*** Foreign Keys ***/
/***************************************** *******************/TABLE BIBLIOTEKOR ADD CONSTRAINT FK_BIBLIOTEKOR_1 FOREIGN KEY (NOMER_OTDELA) REFERENCES OTDEL_KNIG (NOMER_OTDELA);
/***************************************** *****************/
/*** Indices ***/
/***************************************** *******************/INDEX FAM ON BIBLIOTEKOR (FAMILIYA_BIBLIOTEKORYA);
/***************************************** *******************/
/*** Triggers ***/
/***************************************** *******************/
SET TERM ^;
/***************************************** *******************/
/*** Triggers for tables ***/
/***************************************** ******************/
/* Trigger: BIBLIOTEKOR_BI0 */OR ALTER TRIGGER BIBLIOTEKOR_BI0 FOR BIBLIOTEKORBEFORE INSERT OR UPDATE POSITION 0 (NEW. nomer_bibliotekorya is null) then. nomer_bibliotekorya=gen_id (gen_bibliotekar, 1);
^
...
