Hey, Ich arbeite das erste mal mit "MySQL" Und ich komme grade nicht Weiter,
Datenbank (DB):
Hauptklasse (Main):
onEnable (Plugin geladen):
Vllt. sieht ihr den Fehler.
Datenbank (DB):
Code:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.SQLException;
import java.util.Iterator;
import org.bukkit.Bukkit;
import org.bukkit.entity.Player;
public class DB {
public static Plugin00 plugin = Plugin00.instance;
public static Connection c;
public static String url;
public static void connect() {
try {
url = ("jdbc:mysql://" + Plugin00.host+"/"+Plugin00.db+"?user="+Plugin00.user+"&password="+Plugin00.password+"&autoReconnect=true");
c = DriverManager.getConnection(url);
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void close() {
try {
if (c != null) {
c.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
public static ResultSet Update(String qry)
{
try {
Statement stmt = c.createStatement();
stmt.executeUpdate(qry);
stmt.close();
} catch (Exception ex) {
connect();
}
return null;
}
public static ResultSet query(String qry) {
ResultSet rs = null;
try {
Statement stmt = c.createStatement();
rs = stmt.executeQuery(qry);
}
catch (Exception ex) {
connect();
}
return rs;
}
}Hauptklasse (Main):
Code:
public static String host = "";
public static String password = "";
public static String user = "";
public static String db = "";
public static String port = "";onEnable (Plugin geladen):
Code:
host = getConfig().getString("DB.Host");
password = getConfig().getString("DB.Password");
user = getConfig().getString("DB.User");
db = getConfig().getString("DB.DB");
getConfig().addDefault("DB.Host", "//Host//");
getConfig().addDefault("DB.Password", "//Password//");
getConfig().addDefault("DB.User", "//User");
getConfig().addDefault("DB.DB", "//DB//");
getConfig().options().copyDefaults(true);
saveConfig();Vllt. sieht ihr den Fehler.
