аграма класів
Код SQL-скрипта
TABLE program (INTEGER NOT NULL, VARCHAR (1) NOT NULL, VARCHAR (1) NOT NULL, PK_program2 PRIMARY KEY (number)
); TABLE Upravlenie (SMALLINT NOT NULL, VARCHAR (1) NOT NULL, VARCHAR (1) NOT NULL, INTEGER NOT NULL, _number INTEGER NOT NULL, _number INTEGER NOT NULL, _number INTEGER NOT NULL, _17 INTEGER NOT NULL, _number INTEGER NOT NULL, PK_Upravlenie4 PRIMARY KEY (program_number, COL_17, Zakazchik_number, Rukovoditel_number, number, numbername)
); TABLE Manager (INTEGER NOT NULL, VARCHAR (1) NOT NULL, VARCHAR (1) NOT NULL, PK_Manager0 PRIMARY KEY (number)
); TABLE Zakazchik (INTEGER NOT NULL, VARCHAR (1) NOT NULL, VARCHAR (1) NOT NULL, VARCHAR (1) NOT NULL, INTEGER NOT NULL, PK_Zakazchik3 PRIMARY KEY (number)
); TABLE Rukovoditel (INTEGER NOT NULL, VARCHAR (1) NOT NULL, VARCHAR (1) NOT NULL, PK_Rukovoditel1 PRIMARY KEY (number)
); TABLE Upravlenie ADD CONSTRAINT FK_Upravlenie8 FOREIGN KEY (program_number) REFERENCES program (number) ON DELETE NO ACTION ON UPDATE NO ACTION; TABLE Upravlenie ADD CONSTRAINT FK_Upravlenie5 FOREIGN KEY (COL_17) REFERENCES Manager (number) ON DELETE NO ACTION ON UPDATE NO ACTION; TABLE Upravlenie ADD CONSTRAINT FK_Upravlenie4 FOREIGN KEY (Manager_number) REFERENCES Manager (number) ON DELETE NO ACTION ON UPDATE NO ACTION; TABLE Upravlenie ADD CONSTRAINT FK_Upravlenie3 FOREIGN KEY (Zakazchik_number) REFERENCES Zakazchik (number) ON DELETE NO ACTION ON UPDATE NO ACTION; TABLE Upravlenie ADD CONSTRAINT FK_Upravlenie2 FOREIGN KEY (Rukovoditel_number) REFERENCES Rukovoditel (number) ON DELETE NO ACTION ON UPDATE NO ACTION; TABLE Upravlenie ADD CONSTRAINT FK_Upravlenie0 FOREIGN KEY (number) REFERENCES program (number) ON DELETE NO ACTION ON UPDATE NO ACTION;
автоматизація клієнт постачальник таблиця
Рис.13 Схема бази даних
Генерація коду JAVA
class Manager
/ **
* @ roseuid 40D8584300BC
* / Application ()
{
}
/ **
* @ roseuid 3FBF4B53032A
* / void open ()
{
}
/ **
* @ roseuid 3FBF4B5B029E
* / void close ()
{
}
/ **
* @ roseuid 3FBF4B5E038E
* / void add ()
{
}
/ **
* @ roseuid 3FBF4B660140
* / void delete ()
{
}
/ **
* @ roseuid 3FBF4B6903B6
* / void find ()
{
}
/ **
* @ roseuid 3FBF4B6D00BE
* / void update ()
{
}
...
