package osu.cse$3241.$options;

import java.util.Arrays;

import java.util.HashSet;

import java.util.Scanner;

import java.util.Set;

import osu.cse$3241.$utilities.Utilities;

import osu.cse$3241.$sql$.$SQL;

import osu.cse$3241.$GRS;

public class EditMenu $\{$

private static final Set MENU$\_$OPTIONS $=$ new HashSet$<>($Arrays$.$asList$(\text{'}1\text{'},\text{'}2\text{'},\text{'}3\text{'},\text{'}$x$\text{'}))$;

public static void menu$($Scanner cin$)\{$

Utilities.printDivider$()$;

System.out.print$("$EDIT MENU:

$"$

$+"1.$ Add Artist

$"$

$+"2.$ Delete Artist

$"$

$+"3.$ Update Artist

$"$

$+$ "Input numerical selection $($or $\text{'}$x$\text{'}$ to quit$)$: $")$;

String input $=$ cin.nextLine$()$;

char selection $=!$input.isEmpty$()?$ input.charAt$(0)$ : $\text{'}\text{'}$;

while$(!$MENU$\_$OPTIONS.contains$($selection$))\{$

System.out.print$("$Incorrect option specified! Try again: $")$;

input $=$ cin.nextLine$()$;

selection $=!$input.isEmpty$()?$ input.charAt$(0)$ : $\text{'}\text{'}$;

$\}$

switch$($selection$)\{$

case $\text{'}1\text{'}$:

addArtist$()$;

break;

case $\text{'}2\text{'}$:

deleteArtist$()$;

break;

case $\text{'}3\text{'}$:

updateArtist$()$;

default:

break;

$\}$

$\}$

$/*$

$*$ PART SEVEN:

$*$ Complete the method addArtist$()$ below and remove its placeholder.

$*$

$*$ Your implementation will follow the general procedure:

$*1)$ Prompt the user for values for each column in the ARTIST table.

$*2)$ Call a method in SQL$.$java which will handle the insertion of data

$*$ via PreparedStatement and will print out a confirmation message

$*$ upon successful insertion. You will need to define this method in SQL$.$java!

$*$

$*$ Note: since this query is not returning anything $($like a SELECT query$),$ we need to use

$*$ a different method here $($see JDBC$\_$API slide deck$)$: PreparedStatement.executeUpdate$().$ This also has the possibility to

$*$ throw a SQL Exception $($like many other methods you have already used$),$ so make sure it is

$*$ handled in much the same way as the other Statement$/$PreparedStatement methods are handled!

$*$

$*$ You are free to design the input prompt, and the method on SQL$.$java to insert the data, etc.

$*/$

private static void addArtist$()\{$

Utilities.placeholder$()$;

$/*$ TODO $*/$

$\}$

private static void deleteArtist$()\{$

Utilities.placeholder$()$;

$\}$

private static void updateArtist$()\{$

Utilities.placeholder$()$;

$\}$

$\}$

fill in the todo