19.6.1. Statement Interface

The Statement Interface Used to execute static SQL statements.

Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM students");

The Statement Interface in JDBC is designed to execute simple SQL queries that do not require any input parameters. To create a Statement object, the connection object (con) is used to call the createStatement() method. Once you have a Statement object (stmt), you can execute queries such as SELECT, INSERT, UPDATE, or DELETE using methods on the Statement object. The example provided queries the database to select all records from the 'students' table, returning the results in a ResultSet (rs).

Think of the Statement Interface as a waiter in a restaurant. Just like a waiter takes your order directly to the kitchen without needing to customize it, the Statement Interface simply sends your SQL query to the database for execution, asking for the data prepared in the predetermined format.

Creating a Statement object for executing SQL queries.

Statement stmt = con.createStatement();

When you establish a connection to a database using JDBC, the next step often involves creating a Statement object. The method con.createStatement() is called on the Connection object (con), which prepares the statement for querying the database. This is similar to preparing a tool you need to perform a task—in this case, executing a SQL query.

Imagine you're a chef preparing a meal. Before you can cook, you need to gather your tools (knives, pans, etc.). Similarly, before executing a query, you must create a Statement object to interact with the database.

Executing a SQL query using the Statement object.

ResultSet rs = stmt.executeQuery("SELECT * FROM students");

After creating the Statement object, you can execute SQL queries by invoking methods on this object. The executeQuery() method is specifically used for SQL SELECT statements. It takes the SQL query as a parameter and returns a ResultSet, which contains the data fetched from the database. In the example, SELECT * FROM students retrieves all rows in the 'students' table.

If we continue the restaurant analogy, this step is akin to the waiter delivering your order to the kitchen. The kitchen processes the request (the SQL query) and sends back the food (ResultSet) to the waiter, which will eventually serve it to you.

--