package se.umu.cs.apjava.Model;
import java.sql.*;

import static javax.swing.text.html.HTML.Tag.SELECT;

public class Database {
    private Connection con = null;
    private Statement stmt = null;
    private ResultSet rs;


    public Database (){
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://mysql.cs.umu.se:3306/v135h17g28", "v135h17g28", "JcPZHDXGWcfd0WNH");
            stmt = con.createStatement();
        }catch(ClassNotFoundException e){
            System.err.println("Class not found "+ e);
        }catch(SQLException e){
            System.err.println("SQL exception occured" + e);
        }
        addHighScore("pelle",10);
    }
    public void addHighScore (String nickname,int highScore){
        try {
            stmt.executeUpdate("INSERT INTO highscore_list (Nickname,highscore) "
                    +"values('"+nickname+"','"+highScore+"')");

        }catch(SQLException e) {
            System.err.println("SQL exception occured" + e);
            e.printStackTrace();
        }
    }

}