bF6G2za9

1import java.sql.Connection;
2import java.sql.DriverManager;
3import java.sql.SQLException;
4import java.sql.Statement;
5
6public class Matchinimas
7{
8    public static void main (String[] args)
9    {
10        String nuorodaIDB = "jdbc:mysql://localhost:3306/matchinimas";
11        String loginDB = "root";
12        String passwordDB = "";
13
14        try
15        {
16            Connection jungtis = DriverManager.getConnection(nuorodaIDB, loginDB, passwordDB);
17            Statement sakinys = jungtis.createStatement();
18
19            String vyraiLent = "CREATE TABLE IF not EXISTS Vyrai " +
20                    "(vyrai_id INTEGER(6) UNSIGNED AUTO_INCREMENT not NULL, " +
21                    " vardas VARCHAR(20) not NULL, " +
22                    " pavarde VARCHAR(20) not NULL, " +
23                    " PRIMARY KEY ( vyrai_id ))";
24
25            String moterysLent = "CREATE TABLE IF not EXISTS Moterys " +
26                    "(moterys_id INTEGER(6) UNSIGNED AUTO_INCREMENT not NULL, " +
27                    " vardas VARCHAR(20) not NULL, " +
28                    " pavarde VARCHAR(20) not NULL, " +
29                    " PRIMARY KEY ( moterys_id ))";
30
31            String matchedLent = "CREATE TABLE IF not EXISTS Sumatchinti " +
32                    "(id INTEGER(6) UNSIGNED AUTO_INCREMENT not NULL, " +
33                    " vyrai_id INTEGER(6) UNSIGNED not NULL, " +
34                    " moterys_id INTEGER(6) UNSIGNED not NULL, " +
35                    " PRIMARY KEY ( id ))";
36
37
38            sakinys.execute(vyraiLent);
39            sakinys.execute(moterysLent);
40            sakinys.execute(matchedLent);
41
42            String sqlIdetiVyrai =
43                    "INSERT INTO Vyrai (vardas, pavarde) " +
44                            "VALUES " +
45                            "('Mantas', 'Mantas'), " +
46                            "('Matas', 'Matauskas'), " +
47                            "('Mantas', 'Kalnas'), " +
48                            "('Rokas', 'Rokevicius'), " +
49                            "('Mantas', 'Mantinavicius'), " +
50                            "('Lukas', 'Lukas'), " +
51                            "('Jogaila', 'Jog'), " +
52                            "('Vakaris', 'Rytas'), " +
53                            "('Mantas', 'Kalnas') ";
54            sakinys.execute(sqlIdetiVyrai);
55
56
57            String sqlIdetiMoterys =
58                    "INSERT INTO Moterys (vardas, pavarde) " +
59                            "VALUES " +
60                            "('Virga', 'Vvv'), " +
61                            "('Karolina', 'Kkk'), " +
62                            "('Eva', 'Evauska') ";
63            sakinys.execute(sqlIdetiMoterys);
64
65
66            String sqlIdetiSumatchinti =
67                    "INSERT INTO Sumatchinti (vyrai_id, moterys_id) " +
68                            "VALUES " +
69                            "(1, 1), " +
70                            "(2, 2), " +
71                            "(2, 3), " +
72                            "(3, 2), " +
73                            "(4, 2), " +
74                            "(5, 3), " +
75                            "(6, 3), " +
76                            "(7, 3), " +
77                            "(8, 1), " +
78                            "(9, 2) ";
79            sakinys.execute(sqlIdetiSumatchinti);
80
81
82
83        }
84        catch (SQLException e)
85        {
86            e.printStackTrace();
87            System.out.println("IVYKO KLAIDA");
88        }
89    }
90}