19.8.1. Update Example

Try these first

1. 1.

   What method do you use to execute an update with PreparedStatement?

   Hint

   Think about the method we call to apply changes to the database.

2. 2.

   What are the risks of not using PreparedStatement?

   Hint

   Consider the implications of allowing direct SQL commands to be executed.

3. 3.

   Which method is used to execute an update in JDBC?

   • executeQuery()
   • executeUpdate()
   • runQuery()

   Hint

   Look for the method specifically handling updates.

4. 4.

   True or False: PreparedStatement can help prevent SQL injection.

   • True
   • False

   Hint

   Consider the importance of input handling in security.

5. 5.

   Create a Java method that updates the names of multiple students in a single database transaction. Ensure proper exception handling.

   Hint

   Consider how to handle errors during the update process.

6. 6.

   Discuss the implications of not validating user input before executing an update statement in JDBC.

   Hint

   Think about security practices in development.