Book Image

Java 11 Cookbook - Second Edition

By : Nick Samoylov, Mohamed Sanaulla
Book Image

Java 11 Cookbook - Second Edition

By: Nick Samoylov, Mohamed Sanaulla

Overview of this book

For more than three decades, Java has been on the forefront of developing robust software that has helped versatile businesses meet their requirements. Being one of the most widely used programming languages in history, it’s imperative for Java developers to discover effective ways of using it in order to take full advantage of the power of the latest Java features. Java 11 Cookbook offers a range of software development solutions with simple and straightforward Java 11 code examples to help you build a modern software system. Starting with the installation of Java, each recipe addresses various problem by explaining the solution and offering insights into how it works. You’ll explore the new features added to Java 11 that will make your application modular, secure, and fast. The book contains recipes on functional programming, GUI programming, concurrent programming, and database programming in Java. You’ll also be taken through the new features introduced in JDK 18.3 and 18.9. By the end of this book, you’ll be equipped with the skills required to write robust, scalable, and optimal Java code effectively.
Table of Contents (18 chapters)

Using prepared statements


In this recipe, you will learn how to use a prepared statement—a statement template that can be stored in the database and executed efficiently with different input values.

Getting ready

An object of PreparedStatement—a subinterface of Statement—can be precompiled and stored in the database and then used to efficiently execute the SQL statement multiple times for different input values. Similar to an object of Statement (created by the createStatement() method), it can be created by the prepareStatement() method of the same Connection object.  

The same SQL statement that was used to generate Statement can be used to generate PreparedStatement too. In fact, it is a good idea to consider using PrepdaredStatement for any SQL statement that is called multiple times, because it performs better than Statement. To do this, all we need to change are these two lines in the sample code of the previous section:

try (Statement st = conn.createStatement()) {
boolean res = st.execute...