19.8. Inserting, Updating, and Deleting Records

Try these first

1. 1.

   What SQL command is used to insert a new record?

   Hint

   Think about how you add new items to a list.

2. 2.

   What is the purpose of PreparedStatement?

   Hint

   Remember how it helps prevent SQL injection.

3. 3.

   Which command is used to insert a record into a database?

   • SELECT
   • INSERT
   • DELETE

   Hint

   Consider which SQL command adds data.

4. 4.

   True or False: Using PreparedStatement prevents SQL injection.

   • True
   • False

   Hint

   Remember why we use parameterized queries.

5. 5.

   Design a complete method that performs insertion, updating, and deletion of student records based on user input. Outline error handling for invalid inputs.

   Hint

   Think about input validation and exception management.

6. 6.

   How would you handle a situation where multiple users are accessing and modifying the same student record? Discuss strategies.

   Hint

   Consider actions that might cause data discrepancies.