Day 26 SELECT

package projectSamples;
import java.util.Scanner;

public class Day26EmpB {
    //para sa select at select where
    public static void main(String[] args) {
        Scanner sc = new Scanner(System.in);
        Day26Emp callQuery = new Day26Emp();
        String opt = "";
        String searchParam = "";

        callQuery.getRows();

        System.out.println("Do you want to search a row?");
        System.out.println("1 - by first name");
        System.out.println("2 - by last name");
        System.out.println("3 - by department");
        System.out.println("4 - by gender");
        System.out.print("Enter Choice: ");
        opt = sc.nextLine();
        System.out.println("");

        switch (opt) {
            case "1":
                System.out.print("Enter First Name: ");
                searchParam = sc.nextLine();
                callQuery.getRows(searchParam,"1");
                break;
            case "2":
                System.out.print("Enter Last Name: ");
                searchParam = sc.nextLine();
                callQuery.getRows(searchParam,"2");
                break;
            case "3":
                System.out.print("Enter Department ID: ");
                searchParam = sc.nextLine();
                callQuery.getRows(searchParam);
                break;

            case "4":
                System.out.print("Enter Gender: ");
                searchParam = sc.nextLine();
                callQuery.getRows(searchParam,"4");
                break;
            default:
                System.out.println("Option not found. Please try again.");
        }
    }
}