JAVA SPOT - Learn Programming

📋 JAVA DATABASE CONNECTIVITY

Welcome to the repository of Java programs.

💡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. Create a Java Program to show, insert, update, delete of the table in Java API through PreparedStatement