private void selectLibrarian(){
    	int choice;
    	boolean quit;

    	quit = false;
    	
    	try 
    	{
    	    // disable auto commit mode
    	    con.setAutoCommit(false);

    	    while (!quit)
    	    {
    		System.out.print("\n\nPlease choose one of the following: \n");
    		System.out.print("1.  Add Book\n");
    		System.out.print("2.  Generate Report - Checked Out Books\n");
    		System.out.print("3.  Generate Report - Popular Books\n");
    		System.out.print("4.  Back to Main Menu\n");
    		System.out.print("5.  Quit\n>> ");

    		choice = Integer.parseInt(in.readLine());
    		
    		System.out.println(" ");

    		switch(choice)
    		{
    		   case 1:  addNewBook(); break;
    		   case 2:  generateReportCheckedOut(); break;
    		   case 3:  generateReportPopular(); break;
    		   case 4:  showMenu(); break;
    		   case 5:  quit = true;
    		}
    	    }

    	    con.close();
           // in.close();
            showMenu();
    	}
    	catch (IOException e)
    	{
    	    System.out.println("IOException!");

    	    try
    	    {
    		con.close();
    		System.exit(-1);
    	    }
    	    catch (SQLException ex)
    	    {
    		 System.out.println("Message: " + ex.getMessage());
    	    }
    	}
    	catch (SQLException ex)
    	{
    	    System.out.println("Message: " + ex.getMessage());
    	}
}