e0xZWGT4

1import java.sql.Connection;
2import java.sql.DriverManager;
3import java.sql.SQLException;
4import java.sql.Statement;
5
6public class Match 
7{
8    public static void main(String[] args) 
9    {
10        String nuoroda = "jdbc:mysql://localhost:3306/match";
11        String login = "root";
12        String password = "";
13 
14        try
15        {
16            Connection jungtis = DriverManager.getConnection(nuoroda, login, password);
17            Statement sakinys = jungtis.createStatement();
18 
19            String vyrai = "CREATE TABLE IF NOT EXISTS Vyrai ( " + 
20                    "id INT(4) UNSIGNED AUTO_INCREMENT, " + 
21                    "Vardas VARCHAR(20) NOT NULL, " + 
22                    "Pavarde VARCHAR(20) NOT NULL, " + 
23                    "PRIMARY KEY( id ))";
24 
25            String moterys = "CREATE TABLE IF NOT EXISTS Moterys ( " + 
26                    "id INT(4) UNSIGNED AUTO_INCREMENT, " + 
27                    "Vardas VARCHAR(20) NOT NULL, " + 
28                    "Pavarde VARCHAR(20) NOT NULL, " + 
29                    "PRIMARY KEY( id ))";
30 
31            String match = "CREATE TABLE IF NOT EXISTS Match ( " + 
32                    "vid INT(4) UNSIGNED NOT NULL, " + 
33                    "mid INT(4) UNSIGNED NOT NULL, " + 
34                    "FOREIGN KEY( vid ) REFERENCES Vyrai( id ), " + 
35                    "FOREIGN KEY( mid ) REFERENCES Moterys( id ))";
36
37            sakinys.execute(vyrai);
38            sakinys.execute(moterys);
39            sakinys.execute(match);
40 
41            String vyruIdejimas =
42                    "INSERT INTO Vyrai (Vardas, Pavarde) VALUES " + 
43                            "('Mantas', 'Mantas'), " + 
44                            "('Matas', 'Matauskas'), " + 
45                            "('Mantas', 'Kalnas'), " + 
46                            "('Rokas', 'Rokevicius'), " + 
47                            "('Mantas', 'Mantinavicius'), " + 
48                            "('Lukas', 'Lukas'), " + 
49                            "('Jogaila', 'Jog'), " + 
50                            "('Vakaris', 'Rytas'), " + 
51                            "('Mantas', 'Kalnas') ";
52
53            sakinys.execute(vyruIdejimas);
54
55            String moteruIdejimas =
56                    "INSERT INTO Moterys (Vardas, Pavarde) VALUES " + 
57                            "('Virga', 'Vvv'), " + 
58                            "('Karolina', 'Kkk'), " + 
59                            "('Eva', 'Evauska') " + 
60                            "('Karolina', 'Kkkk') ";
61
62            sakinys.execute(moteruIdejimas);
63 
64            String matchuIdejimas =
65                    "INSERT INTO Match (vid, mid) VALUES " + 
66                            "(1, 1), " + 
67                            "(2, 2), " + 
68                            "(2, 3), " + 
69                            "(3, 4), " + 
70                            "(4, 2), " + 
71                            "(5, 3), " + 
72                            "(6, 3), " + 
73                            "(7, 3), " + 
74                            "(8, 1), " + 
75                            "(9, 4) ";
76
77            sakinys.execute(matchuIdejimas);
78 
79        }
80        catch (SQLException e)
81        {
82            e.printStackTrace();
83            System.out.println("ĮVYKO KLAIDA!");
84        }
85    }
86}