JAVA DATABASE CONNECTIVITY
9 programming challenges to help you master the fundamentals of CORE JAVA PROGRAMMING.
1
Create the connection with MySQL Database and manage the driver.
2
Create the table in the database from Java API.
3
Insert the row in the table in the database from Java API.
4
Update the row in the table in the database from Java API.
5
Delete the row in the table in the database from Java API.
6
Select multiple rows from the database table in Java API and show the result on the screen.
7
Create a Scrollable Readonly Resultset and ask the row number from the user and display that row on the screen.
8
Create a Scrollable Updateable Resultset and insert a new row, update an existing row and delete the row from Resultset and also the changes should be made to the database also. The values should be inserted, updated and deleted by the user only.
9