package osu.cse$3241.$options;

import java.sql$.$Connection;

import java.sql$.$PreparedStatement;

import java.sql$.$ResultSet;

import java.sql$.$SQLException;

import java.util.Arrays;

import java.util.HashSet;

import java.util.Scanner;

import java.util.Set;

import osu.cse$3241.$GRS;

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

public class SearchArtistTrack $\{$

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

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

Utilities.printDivider$()$;

System.out.print$("$SEARCH:

$"$

$+"1.$ Artists

$"$

$+"2.$ Tracks

$"$

$+$ "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{'}$:

searchArtists$($cin$)$;

break;

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

searchTracks$($cin$)$;

break;

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

System.out.println$("$Exiting$...")$;

System.exit$(0)$;

break;

default:

break;

$\}$

$\}$

$/**$

$*$ Search tracks in the database according to input track name.

$*$

$*$ @param cin scanner

$*/$

private static void searchTracks$($Scanner cin$)\{$

System.out.print$("$Input track name $($or $\text{'}$x$\text{'}$ to quit$)$: $")$;

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

if $(!$trackName.equals$("$x$")$ && $!$trackName.trim$().$isEmpty$())\{$

String sql $=$ "SELECT track$\_$name FROM tracks WHERE track$\_$name LIKE $?"$;

try $($Connection conn $=$ GRS$.$getConnection$()$;

PreparedStatement pstmt $=$ conn.prepareStatement$($sql$))\{$

pstmt$.$setString$(1,"\%"+$ trackName $+"\%")$;

ResultSet rs $=$ pstmt$.$executeQuery$()$;

System.out.println$("$Matching tracks:"$)$;

while $($rs$.$next$())\{$

System.out.println$($rs$.$getString$("$track$\_$name"$))$;

$\}$

$\}$ catch $($SQLException e$)\{$

System.out.println$("$Error executing SQL query: $"+$ e$.$getMessage$())$;

$\}$

$\}$

$\}$

$/**$

$*$ Search artists in the database according to input artist name.

$*$

$*$ @param cin scanner

$*/$

private static void searchArtists$($Scanner cin$)\{$

Utilities.placeholder$()$;

$/*$ TODO: Implement searching artists by artist name $*/$

$/*$ Example:

System.out.print$("$Input artist name $($or $\text{'}$x$\text{'}$ to quit$)$: $")$;

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

if $(!$artistName.equals$("$x$")$ && $!$artistName.trim$().$isEmpty$())\{$

String sql $=$ "SELECT artist$\_$name FROM artists WHERE artist$\_$name LIKE $?"$;

try $($Connection conn $=$ GRS$.$getConnection$()$;

PreparedStatement pstmt $=$ conn.prepareStatement$($sql$))\{$

pstmt$.$setString$(1,"\%"+$ artistName $+"\%")$;

ResultSet rs $=$ pstmt$.$executeQuery$()$;

System.out.println$("$Matching artists:"$)$;

while $($rs$.$next$())\{$

System.out.println$($rs$.$getString$("$artist$\_$name"$))$;

$\}$

$\}$ catch $($SQLException e$)\{$

System.out.println$("$Error executing SQL query: $"+$ e$.$getMessage$())$;

$\}$

$\}$

$*/$

$\}$

public static void main$($String$[]$ args$)\{$

Scanner cin $=$ new Scanner$($System$.$in$)$;

while $($true$)\{$

menu$($cin$)$;

$\}$

$\}$

fill in the todo