package chessleague;

import java.sql.*;
import java.io.*;
import java.util.Scanner;

public class SelectAllPlayers {

    public static void main(String[] args) throws SQLException, IOException {

        //Connecting to database

        String user, password, localhost, database;
        Scanner sc = new Scanner(System.in);
        System.out.println("Type userid, password, hostname and database: ");

        user = sc.next();
        password = sc.next();
        localhost = sc.next();
        database = sc.next();

        System.out.println(user+" "+password+" "+localhost);
        Connection con = DriverManager.getConnection("jdbc:mysql://"+localhost+":3306/"+database, user, password);
        Statement stmnt = con.createStatement();

        String createProcedure = "create procedure if not exists SelectAllPlayers() begin select * from player; end;";
        stmnt.executeUpdate(createProcedure);
        System.out.println("Procedure created");
        con.close();
        }
}