· 5 years ago · Feb 12, 2021, 10:44 PM
1// API
2
3public void update(String command) {
4 try {
5 PreparedStatement ps = SQL.con.prepareStatement(command);
6 ps.executeUpdate();
7 ps.close();
8 } catch (SQLException e) {
9 e.printStackTrace();
10 }
11 }
12
13// Tabelle erstellen
14 public void createTable(String tableName, String properties) {
15 update("CREATE TABLE IF NOT EXISTS " + tableName + " (" + properties + ");");
16 }
17
18// Bot
19
20package de.flash.auma.main;
21
22import de.flash.api.SQL.Manager;
23import de.flash.api.connection.SQL;
24
25public class MySQLConnector {
26
27 SQL SQL = new SQL();
28 Manager manager = new Manager();
29
30 public void connect() {
31 SQL.Connect("localhost", "3306", "AumaDC", "t9B1QdKGal7W5BOT", "aumadc", "Europe/Berlin", true);
32 }
33
34 public void setup() {
35 manager.createTable("dc_tickets",
36 "DBkey INT AUTO_INCREMENT PRIMARY KEY, UNAME varchar(64), UID varchar(64), TIME varchar(64)");
37 }
38
39}
40