The JDBC statement is used to execute queries against the database. Statement is an interface which provides the methods to execute queries. We can get a statement object by invoking the createStatement() method of Connection interface.
Syntax:
Statement stmt=conn.createStatement();
Commonly used methods of Statement interface:
1. execute(String SQL): It is used to execute SQL DDL statements.
Syntax:
public boolean execute(String SQL)
2. executeQuery(String SQL): It is used to execute the select query and returns an object of ResultSet.
Syntax:
public ResultSet executeQuery(String SQL)
3. executeUpdate(String SQL): It is used to execute the query like inset, update, delete etc. It returns the no. of affected rows.
Syntax:
public int executeUpdate(String SQL)
4. executeBatch(): It is used to execute the batch of commands.
Syntax:
public int[] executeBatch()
JDBC Statement examples:
1. JDBC Statement creates a table example.
2. JDBC Statement inserts a record example.
3. JDBC Statement updates a record example.
4. JDBC Statement select records example.
5. JDBC Statement deletes a record example.
6. JDBC Statement batch update example.
Next Topic: JDBC Statement creates a table example.
Previous Topic: Connect to MySql database with JDBC driver.