Java Statement Interface

Last Updated : 8 Apr 2026

The Statement interface is an important part of JDBC used to execute SQL queries in a Java application. It helps in sending commands to the database and getting results.

In this chapter, you will learn about the Statement interface, its methods, and how to use it to execute SQL queries in Java.

What is Statement Interface?

The Statement interface provides methods to execute SQL queries with the database. It acts as a factory for ResultSet, which means it helps in retrieving data from the database.

It is mainly used to execute simple SQL queries like SELECT, INSERT, UPDATE, and DELETE.

Importing / Using Statement Interface

To use the Statement interface in a Java program, we need to import it from the java.sql package.

Here is the syntax to import Statement interface:

Or we can use:

Methods of Statement Interface

The following table lists the important methods of the Statement interface.

Method	Description
public ResultSet executeQuery(String sql):	Executes a SELECT query and returns a ResultSet object.
public int executeUpdate(String sql):	Executes queries like INSERT, UPDATE, DELETE, CREATE, DROP, etc.
public boolean execute(String sql):	Executes SQL statements that may return multiple results.
public int[] executeBatch():	Executes a batch of SQL commands.

Fields of Statement Interface

The Statement interface does not define commonly used constant fields like the Connection interface. It mainly provides methods to execute queries.

Example of Statement interface

The following example demonstrates how to use the Statement interface to delete a record from a database.

import java.sql.*;

class FetchRecord {
    public static void main(String args[]) throws Exception {
        Class.forName("oracle.jdbc.driver.OracleDriver");

        Connection con = DriverManager.getConnection(
            "jdbc:oracle:thin:@localhost:1521:xe","system","oracle");

        Statement stmt = con.createStatement();

        //stmt.executeUpdate("insert into emp765 values(33,'Irfan',50000)");
        //int result = stmt.executeUpdate("update emp765 set name='Vimal',salary=10000 where id=33");

        int result = stmt.executeUpdate("delete from emp765 where id=33");

        System.out.println(result + " records affected");

        con.close();
    }
}

Output:

1 records affected

Explanation:

This example shows how to use the Statement interface to execute SQL queries. Here, a delete query is executed, and the number of affected records is displayed.

Next TopicResultSet-Interface

← prev next →

We deliver comprehensive tutorials, interview question-answers, MCQs, study materials on leading programming languages and web technologies like Data Science, MEAN/MERN full stack development, Python, Java, C++, C, HTML, React, Angular, PHP and much more to support your learning and career growth.