Solution:NIIT/GNIIT Sonugiri0032@gmail.com

Wednesday, February 10, 2016

Statement interface

Statement interface

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:

The important methods of Statement interface are as follows:
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.

Example of Statement interface

Let’s see the simple example of Statement interface to insert, update and delete the record.
  1. import java.sql.*;  
  2. class FetchRecord{  
  3. public static void main(String args[])throws Exception{  
  4.   
  5. Class.forName("oracle.jdbc.driver.OracleDriver");  
  6. Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","system","oracle");  
  7. Statement stmt=con.createStatement();  
  8.   
  9. //stmt.executeUpdate("insert into emp765 values(33,'Irfan',50000)");  
  10. //int result=stmt.executeUpdate("update emp765 set name='Vimal',salary=10000 where id=33");  
  11. int result=stmt.executeUpdate("delete from emp765 where id=33");  
  12.   
  13. System.out.println(result+" records affected");  
  14. con.close();  
  15. }}  
Share:

0 comments:

GNIITSOLUTION GNIIT SOLUTION. Powered by Blogger.

Translate

Blog Archive

Unordered List