Using mySQL workbench, tried to share the csv file itself but does not show up so instead the csv file is down below in the link and can be imported to mysqlworkbench. https://www.kaggle.com/datasets/prasertk/historical-daily-oil-and-natural-gas-prices

please devise a way of connecting this to java/bluej alongside having some code and a few methods that can search or insert data in regards to the table/database records. if possible, include explanations for the code and its connection.

CoursHeroTranscribedText

Result Grid | ELB Symbol Brent Oil Brent Oil Brent Oil Brent Oil Brent Oil Brent Oil Brent Oil Brent Oil Brent Oil Brent Oil Brent Oil Filter Rows: Open Edit: | Export/Import: Close Volume Currency test Date 1/4/2000 23.9 1/5/2000 24.25 24.37 23.7 23.73 30310 USD 1/6/2000 23.55 24.22 23.35 23.62 44662 USD 1/7/2000 23.57 23.98 23.05 23.09 34826 USD 23.04 23.78 23.04 23.73 26388 USD 21.53 22.15 37832 USD USD USD USD USD LISD High Low 24.7 23.89 24.39 32509 USD 1/10/2000 10/4/2001 21.65 22.38 1/11/2000 23.9 24.67 23.83 24.62 17410 23.97 24.81 1/12/2000 24.35 25.1 28455 1/13/2000 24.84 24.7 24.98 22307 25.25 1/14/2000 24.98 25.56 24.98 25.47 8822 1/17/2000 25.55 25.75 25 47 25.65 16286 123 + 2 3 4 5 6 7 8 9 10 11