19.13. Best Practices in JDBC

Try these first

1. 1.

   What is the purpose of using PreparedStatement in JDBC?

   Hint

   Think about how it deals with user inputs.

2. 2.

   What should you always do after executing a database operation?

   Hint

   Why is this important for the application?

3. 3.

   What is the main advantage of using PreparedStatement over Statement?

   • Prevent SQL injection
   • Simpler syntax
   • Faster execution

   Hint

   Consider security vs. ease of use.

4. 4.

   True or False: Connection pooling decreases the load on the database.

   • True
   • False

   Hint

   Think about how many connections you open per user.

5. 5.

   You are tasked to refactor a legacy Java application that uses raw SQL queries with Statement. Implement the necessary changes to secure it using PreparedStatement.

   Hint

   Remember to replace concatenated inputs with placeholders.

6. 6.

   Design a simple application that connects to a database and implements connection pooling using HikariCP. Describe your implementation steps.

   Hint

   Think about what properties are needed for HikariCP setup.