· 9 years ago · Oct 07, 2016, 06:48 PM
1 public void createTables(Connection conn) {
2 try {
3 String sql = "CREATE TABLE IF NOT EXISTS Kits (UUID varchar(36),dsdDefault varchar(17),dsdZombie varchar(17), dsdSkeleton varchar(17), dsoDefault varchar(17), dsoMiner varchar(17), dsoArcher varchar(17))";
4 PreparedStatement ps = conn.prepareStatement(sql);
5 ps.executeUpdate();
6 ps.close();
7 } catch(SQLException err) {
8 System.err.println(err.getMessage());
9 }
10 }
11
12 public void createUser(Connection conn, UUID uuid) {
13 try {
14 String sql = "INSERT INTO Kits(UUID, dsdDefault, dsdZombie, dsdSkeleton, dsoDefault, dsoMiner, dsoArcher) VALUES ('" + uuid.toString() + "', 'true', 'false', 'false', 'true', 'false', 'false');";
15 PreparedStatement ps = conn.prepareStatement(sql);
16 ps.executeUpdate();
17 ps.close();
18 } catch(SQLException err) {
19 System.err.println(err.getMessage());
20 }
21 }