· 10 years ago · Mar 11, 2016, 09:15 AM
1package SomePackage;
2
3/**
4 * Created by A.V.Tsaplin on 03.03.2016.
5 */
6
7import java.sql.Connection;
8import java.sql.DriverManager;
9import java.sql.SQLException;
10import java.sql.Statement;
11import java.util.ArrayList;
12
13
14
15public class SqlInit {
16 // JDBC URL, username and password of MySQL server
17 private static final String url = "jdbc:mysql://localhost:3306/mydb";
18 private static final String user = "root";
19 private static final String password = "mercedesg55amg";
20
21 // JDBC variables for opening and managing connection
22 private static Connection con;
23 private static Statement stmt;
24
25 public void Init() {
26
27 final String queryDropTable = "Drop table mapnumberone";
28
29 final String queryCreateTable = "create table if not exists mapnumberone (id int(11) not null," +
30 " x int(11) not null, y int(11) not null, value int(11) not null, primary key(id))" +
31 " engine = INNODB default charset = latin1";
32
33
34
35 final String queryInsertData01 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (1, 0, 0, 1);";
36 final String queryInsertData02 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (2, 1, 0, 1);";
37 final String queryInsertData03 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (3, 2, 0, 0);";
38 final String queryInsertData04 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (4, 3, 0, 1);";
39 final String queryInsertData05 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (5, 4, 0, 1);";
40 final String queryInsertData06 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (6, 5, 0, 1);";
41 final String queryInsertData07 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (7, 0, 1, 1);";
42 final String queryInsertData08 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (8, 1, 1, 0);";
43 final String queryInsertData09 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (9, 2, 1, 0);";
44 final String queryInsertData10 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (10, 3, 1, 0);";
45 final String queryInsertData11 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (11, 4, 1, 0);";
46 final String queryInsertData12 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (12, 5, 1, 1);";
47 final String queryInsertData13 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (13, 0, 2, 1);";
48 final String queryInsertData14 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (14, 1, 2, 0);";
49 final String queryInsertData15 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (15, 2, 2, 1);";
50 final String queryInsertData16 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (16, 3, 2, 1);";
51 final String queryInsertData17 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (17, 4, 2, 2);";
52 final String queryInsertData18 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (18, 5, 2, 1);";
53 final String queryInsertData19 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (19, 0, 3, 1);";
54 final String queryInsertData20 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (20, 1, 3, 1);";
55 final String queryInsertData21 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (21, 2, 3, 1);";
56 final String queryInsertData22 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (22, 3, 3, 1);";
57 final String queryInsertData23 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (23, 4, 3, 1);";
58 final String queryInsertData24 = "INSERT INTO mydb.mapnumberone (id, x, y, value) VALUES (24, 5, 3, 1);";
59
60 ArrayList<String> queryArray = new ArrayList<String>() {{
61 add(queryInsertData01);
62 add(queryInsertData02);
63 add(queryInsertData03);
64 add(queryInsertData04);
65 add(queryInsertData05);
66 add(queryInsertData06);
67 add(queryInsertData07);
68 add(queryInsertData08);
69 add(queryInsertData09);
70 add(queryInsertData10);
71 add(queryInsertData11);
72 add(queryInsertData12);
73 add(queryInsertData13);
74 add(queryInsertData14);
75 add(queryInsertData15);
76 add(queryInsertData16);
77 add(queryInsertData17);
78 add(queryInsertData18);
79 add(queryInsertData19);
80 add(queryInsertData20);
81 add(queryInsertData21);
82 add(queryInsertData22);
83 add(queryInsertData23);
84 add(queryInsertData24);
85 }};
86
87
88 try {
89 // opening database connection to MySQL server
90 con = DriverManager.getConnection(url, user, password);
91 // getting Statement object to execute query
92 stmt = con.createStatement();
93 // executing drop query
94 stmt.executeUpdate(queryDropTable);
95 // executing create query
96 stmt.executeUpdate(queryCreateTable);
97 // executing insert queries
98 for (String query: queryArray) {
99 try {
100 stmt.executeUpdate(query);
101 } catch (Exception e) {
102
103 }
104 }
105 } catch (SQLException sqlEx) {
106 sqlEx.printStackTrace();
107 } finally {
108 //close connection ,stmt and resultset here
109 try { con.close(); } catch(SQLException se) { /*can't do anything */ }
110 try { stmt.close(); } catch(SQLException se) { /*can't do anything */ }
111 }
112 }
113}