pNR6nV6z

1public static void vymaz_stlpce(){
2     String sql = "CREATE TABLE if not exists kat (id integer PRIMARY KEY AUTOINCREMENT, nazov text);";
3     String sql1 = "INSERT INTO kat SELECT id, nazov FROM Kategorie;";
4     String sql2 = "DROP TABLE Kategorie;";
5     String sql3 = "CREATE TABLE if not exists Kategorie (id integer PRIMARY KEY AUTOINCREMENT, nazov text);";
6     String sqlk = "INSERT INTO Kategorie SELECT id, nazov FROM kat;";
7     String sqll = "DROP TABLE kat;";
8     
9     String sql4 = "CREATE TABLE if not exists odd (id integer PRIMARY KEY AUTOINCREMENT, nazov text);";
10     String sql5 = "INSERT INTO odd SELECT id, nazov FROM Oddiely;";
11     String sql6 = "DROP TABLE Oddiely;";
12     String sql7 = "CREATE TABLE if not exists Oddiely (id integer PRIMARY KEY AUTOINCREMENT, nazov text);";
13     String sqlm = "INSERT INTO Oddiely SELECT id, nazov FROM odd;";
14     String sqln = "DROP TABLE odd;";
15     
16     String sql8 = "CREATE TABLE if not exists pouz (id integer PRIMARY KEY AUTOINCREMENT, id_kmen_clen integer, id_oddiel integer, meno text, priezvisko text, os_i_c text, cip text, poznamka text, uspech text);";
17     String sql9 = "INSERT INTO pouz SELECT id, id_kmen_clen, id_oddiel, meno, priezvisko, os_i_c, cip, poznamka, uspech FROM Pouzivatelia;";
18     String sqla = "DROP TABLE Pouzivatelia;";
19     String sqlb = "CREATE TABLE if not exists Pouzivatelia (id integer PRIMARY KEY AUTOINCREMENT, id_kmen_clen integer, id_oddiel integer, meno text, priezvisko text, os_i_c text, cip text, poznamka text, uspech text);";
20     String sqlo = "INSERT INTO Pouzivatelia SELECT id, id_kmen_clen, id_oddiel, meno, priezvisko, os_i_c, cip, poznamka, uspech FROM pouz;";
21     String sqlp = "DROP TABLE pouz;";
22     
23     String sqlc = "CREATE TABLE if not exists pret (id integer PRIMARY KEY AUTOINCREMENT, nazov text, datum text, deadline text, aktiv integer, poznamka text);";
24     String sqld = "INSERT INTO pret SELECT id, nazov, datum, deadline, aktiv, poznamka FROM Preteky;";
25     String sqle = "DROP TABLE Preteky;";
26     String sqlf = "CREATE TABLE if not exists Preteky (id integer PRIMARY KEY AUTOINCREMENT, nazov text, datum text, deadline text, aktiv integer, poznamka text);";
27     String sqlq = "INSERT INTO Preteky SELECT id, nazov, datum, deadline, aktiv, poznamka FROM pret;";
28     String sqlr = "DROP TABLE pret;";
29     
30     String sqlg = "CREATE TABLE if not exists prihl (id integer PRIMARY KEY AUTOINCREMENT, id_pouz integer, id_pret integer, id_kat integer, poznamka text);";
31     String sqlh = "INSERT INTO prihl SELECT id, id_pouz, id_pret, id_kat, poznamka FROM Prihlaseni;";
32     String sqli = "DROP TABLE Prihlaseni;";
33     String sqlj = "CREATE TABLE if not exists Prihlaseni (id integer PRIMARY KEY AUTOINCREMENT, id_pouz integer, id_pret integer, id_kat integer, poznamka text);";
34     String sqls = "INSERT INTO Prihlaseni SELECT id, id_pouz, id_pret, id_kat, poznamka FROM prihl;";
35     String sqlt = "DROP TABLE prihl;";
36     
37     try (Connection conn = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\t430\\Documents\\Å¡kola\\TIS\\database.db");
38                Statement stmt = conn.createStatement()) {
39            // create a new table
40            stmt.execute(sql);
41            stmt.execute(sql1);
42            stmt.execute(sql2);
43            stmt.execute(sql3);
44            stmt.execute(sqlk);
45            stmt.execute(sqll);
46            stmt.execute(sql4);
47            stmt.execute(sql5);
48            stmt.execute(sql6);
49            stmt.execute(sql7);
50            stmt.execute(sqlm);
51            stmt.execute(sqln);
52            stmt.execute(sqlc);
53            stmt.execute(sqld);
54            stmt.execute(sqle);
55            stmt.execute(sqlf);
56            stmt.execute(sqlq);
57            stmt.execute(sqlr);
58            stmt.execute(sql8);
59            stmt.execute(sql9);
60            stmt.execute(sqla);
61            stmt.execute(sqlb);
62            stmt.execute(sqlo);
63            stmt.execute(sqlp);
64            stmt.execute(sqlg);
65            stmt.execute(sqlh);
66            stmt.execute(sqli);
67            stmt.execute(sqlj);
68            stmt.execute(sqls);
69            stmt.execute(sqlt);
70            
71        } catch (SQLException e) {
72            System.out.println(e.getMessage());
73        }
74    }