19.9. Handling Exceptions and Closing Resources

Try these first

1. 1.

   What is the purpose of closing JDBC resources?

   Hint

   Think about what happens if resources aren't closed.

2. 2.

   What does SQLException indicate?

   Hint

   Relate this to interactions with databases.

3. 3.

   What is the recommended way to manage resources in JDBC?

   • Using manual close statements
   • Try-with-resources
   • Ignoring resource closure

   Hint

   Consider which method simplifies coding.

4. 4.

   True or False: It is safe to ignore closing JDBC resources.

   • True
   • False

   Hint

   Think about the consequences of leaving resources open.

5. 5.

   Implement JDBC code with resource management that connects to a MySQL database and executes a query using try-with-resources while handling SQLEdception.

   Hint

   Don't forget to include the SQL statements and handle the connection properly.

6. 6.

   Discuss how an unclosed Statement might affect the performance of a Java application in a multi-user environment.

   Hint

   Consider what happens to system resources when they're not being freed up.