, , . , , .
, . , .
2.3 , . , , . .
2.3
2.2 .
2.3 .
2.4 .
2.5 .
2.6 .
2.7 .
MySQL. MySQL-, , :
CREATE TABLE IF NOT EXISTS `avtopark` (
`idavtopark` int(11) NOT NULL AUTO_INCREMENT,
`idavtovokz` int(11) NOT NULL,
`num_avto` int(11) NOT NULL,
`marka` varchar(20) DEFAULT NULL,
`model` varchar(20) DEFAULT NULL,
`color` varchar(20) DEFAULT NULL,
`kolvo_mest` int(11) NOT NULL,
PRIMARY KEY (`idavtopark`)
)
CREATE TABLE IF NOT EXISTS `avtovokzal` (
`idavtovokz` int(11) NOT NULL AUTO_INCREMENT,
`gorod` varchar(20) DEFAULT NULL,
`adress` varchar(20) DEFAULT NULL,
`telefon` varchar(20) DEFAULT NULL,
`fioDirector` varchar(20) DEFAULT NULL,
PRIMARY KEY (`idavtovokz`)
)
CREATE TABLE IF NOT EXISTS `bilet` (
`num_bileta` int(11) NOT NULL AUTO_INCREMENT,
`num_reysa` int(11) NOT NULL,
`num_zakaza` int(11) NOT NULL,
`place` varchar(100) NOT NULL,
`price` float NOT NULL,
`student` float NOT NULL,
`pensia` float NOT NULL,
PRIMARY KEY (`num_bileta`)
)
CREATE TABLE IF NOT EXISTS `doljnost` (
`iddolj` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`iddolj`)
)
CREATE TABLE IF NOT EXISTS `gorod` (
`idgorod` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) DEFAULT NULL,
PRIMARY KEY (`idgorod`)
)
CREATE TABLE IF NOT EXISTS `obsl_reysov` (
`idobsl_reysov` int(11) NOT NULL AUTO_INCREMENT,
`idavtopark` int(11) NOT NULL,
`num_reysa` int(11) NOT NULL,
PRIMARY KEY (`idobsl_reysov`)
)
CREATE TABLE IF NOT EXISTS `personal` (
`idsotr` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
`fio` varchar(20) DEFAULT NULL,
`iddolj` int(11) NOT NULL,
`pol` varchar(20) DEFAULT NULL,
`data_rojd` varchar(100) NOT NULL,
`adress` varchar(20) NOT NULL,
`telefon` varchar(20) DEFAULT NULL,
`idavtovokz` int(11) NOT NULL,
PRIMARY KEY (`idsotr`)
)
CREATE TABLE IF NOT EXISTS `reysi` (
`num_reysa` int(11) NOT NULL AUTO_INCREMENT,
`data_reysa` varchar(100) NOT NULL,
`place_otpr` varchar(20) NOT NULL,
`place_nazn` varchar(20) NOT NULL,
`num_platf` int(11) NOT NULL,
`idsotr` int(11) NOT NULL,
PRIMARY KEY (`num_reysa`)
)
CREATE TABLE IF NOT EXISTS `zakazi` (
`num_zakaza` int(11) NOT NULL AUTO_INCREMENT,
`num_reysa` int(11) NOT NULL,
`data_zakaza` varchar(255) DEFAULT NULL,
`fio` varchar(20) DEFAULT NULL,
`telefon` varchar(20) DEFAULT NULL,
PRIMARY KEY (`num_zakaza`)
)
`avtopark`
INSERT INTO `avtopark` (`idavtopark`, `idavtovokz`, `num_avto`, `marka`, `model`, `color`, `kolvo_mest`) VALUES
(11, 11, 133, '', '8', '', 34),
(14, 9, 13, '', '5', '', 12);
`avtovokzal`
INSERT INTO `avtovokzal` (`idavtovokz`, `gorod`, `adress`, `telefon`, `fioDirector`) VALUES
(10, '', '. ', '883-4232', ' .'),
(13, '', '. ', '779-3123', ' .'),
(14, '', '. ', '779-8341', ' .');
`bilet`
INSERT INTO `bilet` (`num_bileta`, `num_reysa`, `num_zakaza`, `place`, `price`, `student`, `pensia`) VALUES
(3, 6, 3, '', 1300, 0, 260),
(4, 6, 0, '', 2000, 0, 0),
(5, 6, 3, '', 2000, 400, 0),
(6, 6, 3, '', 19000, 0, 0);
`doljnost`
INSERT INTO `doljnost` (`iddolj`, `name`) VALUES
(1, '');
`gorod`
INSERT INTO `gorod` (`idgorod`, `name`) VALUES
(1, ''),
(2, ''),
(3, ''),
(5, '');
`personal`
INSERT INTO `personal` (`idsotr`, `fio`, `iddolj`, `pol`, `data_rojd`, `adress`, `telefon`, `idavtovokz`) VALUES
(12, ' .', 3, '', '13.07.1983', ' . ', '99-54-32', 1),
(13, ' .', 1, '', '12.04.1980', ' . ', '40-34-32', 2);
`reysi`
INSERT INTO `reysi` (`num_reysa`, `data_reysa`, `place_otpr`, `place_nazn`, `num_platf`, `idsotr`) VALUES
(6, '14.02.2014', '', '', 15, 13),
(10, '12.02.2014', '', '', 13, 12),
(11, '13.02.2014', '', '', 12, 13),
(12, '15.02.2014', '', '', 9, 12),
(13, '24.12.2012', '', '', 11, 13);
`zakazi`
INSERT INTO `zakazi` (`num_zakaza`, `num_reysa`, `data_zakaza`, `fio`, `telefon`) VALUES
(2, 1, '19-02-2010', ' .', '99-23-12'),
(3, 6, '13-02-2014', ' .', '99-34-26');
, . , , . , ( ).
, , , , .
|
|
|
:
1 : SELECT * FROM avtovokzal;
2 : SELECT * FROM avtopark;
3 : SELECT * FROM reysi;
4 : SELECT * FROM billet;
5 : SELECT * FROM avtovokzal;
6 : SELECT * FROM personal;
7 : SELECT * FROM gorod;
:
1 : DELETE FROM avtovokzal WHERE idavtovokz='" + idavtoparkal + "';
2 : DELETE FROM avtopark WHERE idavtopark='" + idavtopark + "';
3 : DELETE FROM reysi WHERE num_reysa='" + idReysa + "';
4 : DELETE FROM bilet WHERE num_bileta='" + num_bileta + "';
5 : DELETE FROM zakazi WHERE num_zakaza='" + num_zakaza + "';
6 : DELETE FROM personal WHERE idsotr='" + idsotr + "';
7 : DELETE FROM gorod WHERE idgorod='" + idgorod + "';
:
1 : UPDATE `avtovokzal` SET `gorod`='" + gorod + "',`adress`='" + adress + "',`telefon`='" + telefon + "',`fioDirector`='" + fioDirector + "' WHERE idAvtovokz = '" + idAvtovokz + "';
2 : UPDATE avtopark SET `idavtovokz`='" + idAvtovokzal + "',`num_avto`='" + numberAvto + "',`marka`='" + markaAvto + "',`model`='" + modelAvto + "',`color`='" + colorAvto + "', `kolvo_mest`='" + kolichestvoMestAvto + "' WHERE idavtopark = '" + idAvtopark + "';
3 : UPDATE `reysi` SET`data_reysa`='"+dateReysa+"',`place_otpr`='"+mestoOtpravki+"',`place_nazn`='"+mestoNaznachenia+"',`num_platf`='"+nomerPlatform+"',`idsotr`='"+idSotr+"'
WHERE num_reysa`='"+idReysa+"';
4 : UPDATE bilet SET `num_reysa`='" + idReysa + "',`num_zakaza`='" + idZakaza + "',`price`='" + cena + "',`student`='" + skidkaStudenta + "', `pensia`='" + skidkaPens + "' WHERE num_bileta = '" + idBilet + "';
5 : UPDATE zakazi SET `num_reysa`='" + idReysa + "',`data_zakaza`='" + dateZakaza + "',`fio`='" + fio + "',`telefon`='" + telefon + "' WHERE num_zakaza = '" + idZakaza + "';
6 : UPDATE personal SET `fio`='" + FioSotrudnik + "',`iddolj`='" + Iddolj + "',`pol`='" + Pol + "', `data_rojd`='" + BdSotrudnik + "', `adress`='" + AdresSotrudnik + "', `telefon`='" + TelefonSotrudnik + "', `idavtovokz`='" + Idavtovokz + "' WHERE idsotr = '" + IdSotrudnik + "';
7 : UPDATE gorod SET `name`='" + nameGoroda + "' WHERE idgorod = '" + idGoroda + "';
:
1 : INSERT INTO avtovokzal(gorod, adress, telefon, fioDirector) VALUES('" + gorod + "','" + adress + "','" + telefon + "','" + fioDirector + "');
2 : INSERT INTO `avtopark`(`idAvtovokz`, `num_avto`, `marka`, `model`, `color`, `kolvo_mest`) VALUES('" + dc + "','" + numberAvto + "','" + markaAvto + "','" + modelAvto + "','" + colorAvto + "','" + kolichestvoMestAvto + "');
|
|
|
3 : INSERT INTO `reysi`(`data_reysa`, `place_otpr`, `place_nazn`, `num_platf`, `idsotr`) VALUES('" + dateReysa + "','" + mestoOtpravki + "','" + mestoNasnachenia + "','" + nomerPlatform + "','" + idSotrudnik + "');
4 : INSERT INTO `bilet`(`num_reysa`, `num_zakaza`, `place`, `price`, `student`, `pensia`) VALUES('" + num_reysa + "','" + num_zakaza + "','" + place + "','" + price + "','" + student + "','" + pensia + "');
5 : INSERT INTO zakazi (num_reysa, data_zakaza, fio, telefon) VALUES('" + idReysa + "','"+dateZakaza+"','"+fio+"','"+telefon+"');
6 : INSERT INTO `personal`(`fio`, `iddolj`, `pol`, `data_rojd`, `adress`, `telefon`, `idavtovokz`) VALUES('" + fioSotrudnik + "','" + iddolj + "','" + polSotrudnik + "','" + bdSotrudnik + "','" + adresSotrudnik + "','" + telefonSotrudnik + "','" + idavtovokz + "');
7 : INSERT INTO gorod(name) VALUES('" + name+ "');
. . .
:
:
:
:
:
:
:
