-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathrgr.pgc
84 lines (72 loc) · 1.67 KB
/
rgr.pgc
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
#include <iostream>
EXEC SQL include sqlca;
using namespace std;
EXEC SQL WHENEVER SQLERROR SQLPRINT;
void connectionToDb(const char* host, const char* dbname, const char* user, const char* pass) {
EXEC SQL BEGIN DECLARE SECTION;
char target[256];
const char* db = dbname;
const char* u = user;
const char* p = pass;
EXEC SQL END DECLARE SECTION;
strcpy(target, db);
strcat(target, "@");
strcat(target, host);
cout << "target: " << target << endl;
EXEC SQL CONNECT TO :target USER :u USING :p;
}
#include "country.c"
#include "state.c"
#include "city.c"
#include "passenger.c"
#include "trip.c"
#include "transport_route.c"
void menu() {
while (true) {
cout << "Меню:" << endl;
cout << "1. Управление странами:" << endl;
cout << "2. Управления Административными единицами" << endl;
cout << "3. Управление городами" << endl;
cout << "4. Управление пассажирами" << endl;
cout << "5. Управление поездками" << endl;
cout << "6. Управление транспортными маршрутами" << endl;
cout << "0. Выход" << endl;
int number;
cin >> number;
switch (number) {
case 1: {
menu_country();
break;
}
case 2: {
menu_state();
break;
}
case 3: {
menu_city();
break;
}
case 4: {
menu_passenger();
break;
}
case 5: {
menu_trip();
break;
}
case 6: {
menu_transport_route();
break;
}
case 0: {
return;
}
}
}
return;
}
int main() {
connectionToDb("localhost", "rgr", "alex", "1111");
menu();
return 0;
}