import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.*;

public class Connect
{
    public static void main(String[] args) throws Exception
    {
        //Sets up the JDBC driver
        Class.forName("com.mysql.jdbc.Driver");

        //Initialise database connection
        Connection con = DriverManager.getConnection("jdbc:mysql://82.7.15.102/joss_LaserGame","joss_USERNAME","PASSWORD");

        Scanner in = new Scanner(System.in);
        System.out.println("Enter a forename: ");
        String forename = in.nextLine();
        System.out.println("Enter a surname: ");
        String surname = in.nextLine();

        //Prepare SQL statements
        PreparedStatement append = con.prepareStatement("INSERT INTO  `default_test`.`test` (`forename`, `surname`) VALUES ('"+forename+"', '"+surname+"')");
        PreparedStatement state = con.prepareStatement("select * from test");

        //Execute Statements
        append.executeUpdate();
        ResultSet result = state.executeQuery();

        //Iterate through records
        while (result.next())
        {
            System.out.println(result.getString(1) + " " + result.getString(2));
        }



    }

}