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

public class DatabaseUpdate extends Window {

	/**
	 *
	 */
	private static final long serialVersionUID = 1L;

	DatabaseUpdate(String name) {
		super(name);
		// TODO Auto-generated constructor stub
	}

	public static Connection conn;
	private static String url = "jdbc:mysql://mysql4.gear.host/jpwp?autoReconnect=true&useSSL=false";
	private static String username = "jpwp";
	private static String password = "jpwp@wieczorek";
	//ranking dla poziomu latwego
	public static String querylatwy;
	//ranking dla poziomu sredniego
	public static String querysredni;
	//ranking dla poziomu trudnego
	public static String querytrudny;

	public static String top3nickname;
	public static int top3points;

	public static void connect() {
		try {
    		Class.forName("com.mysql.jdbc.Driver");
    	} catch (ClassNotFoundException e) {
    		throw new IllegalStateException("Cannot find the driver in the classpath!", e);
    	}

		try {
            conn = DriverManager.getConnection(url,username,password);
        } catch (Exception e) {
            System.err.println(e.getMessage());
        }
	}

	public static void addResult() throws SQLException{
		Statement statement = conn.createStatement();
		if(poziom.equals("łatwy")){
			querylatwy = "INSERT INTO ranking_latwy (nickname, punkty) VALUES ('"+nickname+"', "+punkty+")";
			statement.executeUpdate(querylatwy);
			}
		else if(poziom.equals("średni")){
			querysredni = "INSERT INTO ranking_sredni (nickname, punkty) VALUES ('"+nickname+"', "+punkty+")";
			statement.executeUpdate(querysredni);
			}
		else if(poziom.equals("trudny")){
			querytrudny = "INSERT INTO ranking_trudny (nickname, punkty) VALUES ('"+nickname+"', "+punkty+")";
			statement.executeUpdate(querytrudny);
			}
	}

	public static void getTop3(String level, int pos) throws SQLException{
		//pos - pozycja (0-top1, 1-top2, 2-top3)
		Statement statement = conn.createStatement();
		String get_results = "SELECT nickname, punkty FROM (SELECT nickname, punkty FROM ranking_"+level+" ORDER BY punkty DESC LIMIT 3) as X LIMIT "+pos+",1";
		ResultSet result = statement.executeQuery(get_results);
		while (result.next()) {
			  top3nickname = result.getString("nickname");
			  top3points = result.getInt("punkty");
			}
	}
}