Guest User

Untitled

a guest
Jan 21st, 2018
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.19 KB | None | 0 0
  1. package me.plugindevelopper.mysql;
  2.  
  3. import java.sql.Connection;
  4. import java.sql.DriverManager;
  5. import java.sql.ResultSet;
  6. import java.sql.SQLException;
  7. import java.sql.Statement;
  8.  
  9. import me.plugindevelopper.File.ConfigManager;
  10.  
  11.  
  12.  
  13.  
  14.  
  15.  
  16. public class MySQLHandler {
  17.     public static ResultSet mySQLConnection(String Tabelle, String Spalte, String wert,String TYPE,String nameplayer) {
  18.          ConfigManager cm = new ConfigManager();
  19.         // Diese Eintraege werden zum
  20.         // Verbindungsaufbau benoetigt.
  21.         final String hostname = cm.mysqlHost();
  22.         final String port = cm.mysqlPort();
  23.         final String dbname = cm.mysqlDB();
  24.         final String user = cm.mysqlUser();
  25.         final String password = cm.mysqlPassword();
  26.    
  27.         Connection conn = null;
  28.    
  29.         try {
  30.         System.out.println("* Treiber laden");
  31.             Class.forName("org.gjt.mm.mysql.Driver").newInstance();
  32.         }
  33.         catch (Exception e) {
  34.             System.err.println("Unable to load driver.");
  35.             e.printStackTrace();
  36.         }
  37.         try {
  38.         System.out.println("* Verbindung aufbauen");
  39.         String url = "jdbc:mysql://"+hostname+":"+port+"/"+dbname;
  40.         conn = DriverManager.getConnection(url, user, password);
  41.         if (TYPE == "SELECT"){
  42.          ResultSet statment = conn.createStatement().executeQuery("SELECT * FROM "+Tabelle+" WHERE "+Spalte+" = '"+nameplayer+"'");
  43.          String stmt=statment.getString(1);
  44.         return statment;
  45.         }else if(TYPE == "INSERT"){
  46.             /*
  47.              * INERT STUFF
  48.              */
  49.         }
  50.        
  51.         System.out.println("* Datenbank-Verbindung beenden");
  52.        
  53.         }
  54.         catch (SQLException sqle) {
  55.             System.out.println("SQLException: " + sqle.getMessage());
  56.             System.out.println("SQLState: " + sqle.getSQLState());
  57.             System.out.println("VendorError: " + sqle.getErrorCode());
  58.             sqle.printStackTrace();
  59.         }
  60.        
  61.         ResultSet statment = null;
  62.         String stat = null;
  63.         try {
  64.             stat = statment.getString(0);
  65.         } catch (SQLException e) {
  66.             // TODO Auto-generated catch block
  67.             e.printStackTrace();
  68.         }
  69.         return statment;
  70.        
  71.      }
  72. }
Add Comment
Please, Sign In to add comment