saveGameDetails

public static void saveGameDetails(GameDetails gameDetails) {

        String database = "catchphrase";
        PreparedStatement ps = null;
        String sql = null;
        Connection conn = null;

        try {

            String propFileName = "spring.data-access";
            ResourceBundle rb = ResourceBundle.getBundle(propFileName);
            String dbUserName = rb.getString("jdbc.username");
            String dbPassword = rb.getString("jdbc.password");
            System.out.println("BJM-Set the database to " + database);

            DatabaseConnection newConnection = new DatabaseConnection(database, dbUserName, dbPassword);
            conn = ConnectionUtils.getConnection(newConnection);

            sql = "INSERT INTO `GameDetails` (`gameId`, `date`, `team1Name`, `team2Name`, `team1Score`, `team2Score`, `category`, `winningTeam`) " +
                    "VALUES (?,?,?,?,?,?,?,?)";

            ps = conn.prepareStatement(sql);

            ps.setInt(1, gameDetails.getGameId());
            ps.setString(2, gameDetails.getDate());
            ps.setString(3, gameDetails.getTeam1Name());
            ps.setString(4, gameDetails.getTeam2Name());
            ps.setInt(5, gameDetails.getTeam1Score());
            ps.setInt(6, gameDetails.getTeam2Score());
            ps.setString(7, gameDetails.getCategory());
            ps.setString(8, gameDetails.getWinningTeam());

            ps.executeUpdate();

        } catch (Exception e) {
            String errorMessage = e.getMessage();
            e.printStackTrace();
        } finally {
            DbUtils.close(ps, conn);
        }
    }