FvMux1ab

1package laprendeles;
2
3import java.io.BufferedReader;
4import java.io.FileInputStream;
5import java.io.InputStreamReader;
6import java.sql.*;
7
8public class Laprendeles {
9    
10    static Connection kapcsolat;
11    static Statement parancs;
12    static ResultSet eredmeny;
13    
14    void lap(){
15        try{
16            parancs.execute("drop table if exists lap");
17            String sql = "create table if  not exists lap (id integer primary key, tema text, cim text, havi integer, negyedeves integer, feleves integer, eves integer, gyakorisag integer)";
18            //System.out.println(sql);
19            parancs.execute(sql);
20            FileInputStream fis = new FileInputStream("lap.txt");
21            InputStreamReader isr = new InputStreamReader(fis, "UTF-8");
22            BufferedReader br = new BufferedReader(isr);
23            br.readLine();
24            parancs.execute("begin transaction");
25            //id, tema, cim, havi, negyedeves, feleves, eves, gyakorisag
26            //0   1     2    3     4           5        6     7
27            while(br.ready()){
28                String s = br.readLine();
29                //System.out.println(s);
30                String[] t = s.split("\t");
31                sql= "insert into lap values (";
32                sql += t[0] + ", '" + t[1] + "', '" + t[2] + "'";
33                String d = t[3].equals("") ? "null" : t[3];
34                sql += ", " + d;
35                d = t[4].equals("") ? "null" : t[4];
36                sql += ", " + d;
37                d = t[5].equals("") ? "null" : t[5];
38                sql += ", " + d;
39                sql += ", " + t[6] + ", " + t[7];
40                sql += ")";
41                //System.out.println(sql);
42                parancs.execute(sql);
43            }
44            parancs.execute("commit"); //rollback
45            br.close();
46        }catch(Exception e){
47            e.printStackTrace();
48        }
49    }
50    
51    void elofizetes(){
52        try {
53            parancs.execute("drop table if exists elofizetes");
54            String sql = "create table if  not exists elofizetes (id integer primary key autoincrement, eloid integer, lapid integer)";
55            //System.out.println(sql);
56            parancs.execute(sql);
57            FileInputStream fis = new FileInputStream("elofizetes.txt");
58            InputStreamReader isr = new InputStreamReader(fis, "UTF-8");
59            BufferedReader br = new BufferedReader(isr);
60            br.readLine();
61            parancs.execute("begin transaction");
62            //eloid, lapid
63            //0      1
64            while(br.ready()){
65                String s = br.readLine();
66                //System.out.println(s);
67                String[] t = s.split("\t");
68                sql= "insert into elofizetes values (";
69                sql +=  "null, " + t[0] + ", " + t[1];
70                sql += ")";
71                //System.out.println(sql);
72                parancs.execute(sql);
73            }
74            parancs.execute("commit"); //rollback
75            br.close();
76        }catch(Exception e){
77            e.printStackTrace();
78        }
79    }
80    
81    void elofizeto(){
82        try {
83            parancs.execute("drop table if exists elofizeto");
84            String sql = "create table if  not exists elofizeto (id integer primary key, nev text, utca text, hazszam integer)";
85            //System.out.println(sql);
86            parancs.execute(sql);
87            FileInputStream fis = new FileInputStream("elofizeto.txt");
88            InputStreamReader isr = new InputStreamReader(fis, "UTF-8");
89            BufferedReader br = new BufferedReader(isr);
90            br.readLine();
91            parancs.execute("begin transaction");
92            //id, nev, utca, hazszam
93            //0   1    2     3
94            while(br.ready()){
95                String s = br.readLine();
96                //System.out.println(s);
97                String[] t = s.split("\t");
98                sql= "insert into elofizeto values (";
99                sql += t[0] + ", '" + t[1] + "', '" + t[2] + "', " + t[3];
100                sql += ")";
101                //System.out.println(sql);
102                parancs.execute(sql);
103            }
104            parancs.execute("commit"); //rollback
105            br.close();
106        }catch(Exception e){
107            e.printStackTrace();
108        }
109    }
110    
111    void importok(){
112        lap();
113        elofizetes();
114        elofizeto();
115    }
116    
117    void kapcsolodas(){
118        try{
119            kapcsolat = DriverManager.getConnection("jdbc:sqlite:kezbesito.db");
120            parancs = kapcsolat.createStatement();
121        }catch(Exception e){
122            e.printStackTrace();
123        }
124    }
125    
126    static void bezaras(){
127        try {
128            kapcsolat.close();
129        }catch(Exception e) {
130            e.printStackTrace();
131        }
132    }
133    
134    Laprendeles(){
135        kapcsolodas();
136        //importok();
137        new Ablak().setVisible(true);
138        //bezaras();
139    }
140    
141    public static void main(String[] args) {
142        new Laprendeles();
143    }
144    
145}