Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package me.plugindevelopper.mysql;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- import me.plugindevelopper.File.ConfigManager;
- public class MySQLHandler {
- public static ResultSet mySQLConnection(String Tabelle, String Spalte, String wert,String TYPE,String nameplayer) {
- ConfigManager cm = new ConfigManager();
- // Diese Eintraege werden zum
- // Verbindungsaufbau benoetigt.
- final String hostname = cm.mysqlHost();
- final String port = cm.mysqlPort();
- final String dbname = cm.mysqlDB();
- final String user = cm.mysqlUser();
- final String password = cm.mysqlPassword();
- Connection conn = null;
- try {
- System.out.println("* Treiber laden");
- Class.forName("org.gjt.mm.mysql.Driver").newInstance();
- }
- catch (Exception e) {
- System.err.println("Unable to load driver.");
- e.printStackTrace();
- }
- try {
- System.out.println("* Verbindung aufbauen");
- String url = "jdbc:mysql://"+hostname+":"+port+"/"+dbname;
- conn = DriverManager.getConnection(url, user, password);
- if (TYPE == "SELECT"){
- ResultSet statment = conn.createStatement().executeQuery("SELECT * FROM "+Tabelle+" WHERE "+Spalte+" = '"+nameplayer+"'");
- String stmt=statment.getString(1);
- return statment;
- }else if(TYPE == "INSERT"){
- /*
- * INERT STUFF
- */
- }
- System.out.println("* Datenbank-Verbindung beenden");
- }
- catch (SQLException sqle) {
- System.out.println("SQLException: " + sqle.getMessage());
- System.out.println("SQLState: " + sqle.getSQLState());
- System.out.println("VendorError: " + sqle.getErrorCode());
- sqle.printStackTrace();
- }
- ResultSet statment = null;
- String stat = null;
- try {
- stat = statment.getString(0);
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- return statment;
- }
- }
Add Comment
Please, Sign In to add comment