EP46..2.2 - Bukkit/Spigot Base de données

package fr.src.peco;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;


public class SQL
{
    public Peco plugin;

    public SQL(Peco main)
    {
        this.plugin = main;
    }

    private String url = "jdbc:mysql://localhost/youtube";
    private String user = "user_name";
    private String password = "paswword";
    public Connection conn;
    public ResultSet result;
    public Statement state;

    public void connect()
    {
        try{
            Class.forName("com.mysql.jdbc.Driver");
        }catch(ClassNotFoundException CNFE)
        {
            CNFE.printStackTrace();
        }

        try{
            this.conn = DriverManager.getConnection(url, user, password);
            System.out.println("Connexion établie ! :)");
        }catch(SQLException SQLE)
        {
            SQLE.printStackTrace();
        }
    }

    // INSERT INTO VALUES SELECT FROM WHERE SET UPDATE -- mots clés importants

    public void CreateAccount(String pseudo, double money, double banque)
    {
        try{
            Statement state = this.conn.createStatement();
            state.executeUpdate("INSERT INTO youtube (pseudo, money, banque) VALUES ('"+ pseudo +"', "+ money +", "+ banque +")");
            state.close();
        }catch(SQLException SQLE)
        {
            SQLE.printStackTrace();
        }
    }

    public String getName(String pseudo)
    {
        try{
            this.state = this.conn.createStatement();
            this.result = this.state.executeQuery("SELECT * FROM youtube WHERE pseudo = '"+pseudo+"'");

            while(this.result.next())
            {
                return this.result.getString(1);
            }
            //state.close();
        }catch(SQLException SQLE)
        {
            SQLE.printStackTrace();
        }
        return "null";
    state.close();// - correctif
    }

}

// author: Pixpeez | version : 0.1 | date : 07/05/16 |
youtube : http://youtube.com/pixpeez
twitter : http://twitter.com/@Cosmonocx