The Statement interface provides methods to execute queries with the database. The statement interface is a factory of ResultSet i.e. it provides factory method to get the object of ResultSet.

Commonly used methods of Statement interface:

1. public ResultSet executeQuery(String sql): is used to execute SELECT query. It returns the object of ResultSet.
2. public int executeUpdate(String sql): is used to execute specified query, it may be create, drop, insert, update, delete etc.
3. public boolean execute(String sql): is used to execute queries that may return multiple results.
4. public int[] executeBatch(): is used to execute batch of commands.

For example of statement interface follow below links:

• 5 JDBC Steps to Connect with Database
• JDBC Connection with MySQL Database
• JDBC: Connection With Oracle Database

See Also :

• JDBC: Difference between Statement, PreparedStatement and CallableSatement

More on JDBC

Follow below links to learn more on JDBC and solving JDBC related issues :

• JDBC Tutorial
• JDBC Sample Code
• JDBC Issues and Solutions
• JDBC Interview Questions And Answers
• JDBC Coding Best Practices