What are different types of Statement?

This is another classical JDBC interview question. Variants are Difference between Statement, PreparedStatemetn and CallableStatement in Java. Statement object is used to send SQL query to database and get result from database, and we get statement object from connection object.

 

There are three types of statement:

1. Statement: it’s a commonly used for getting data from database useful when we are using static SQL statement at runtime. it will not accept any parameter.

              Statement   stmt = conn.createStatement( );

      ResultSet rs = stmt.executeQuery();

 

2. PreparedStatement: when we are using same SQL statement multiple time its is useful and it will accept parameter at runtime.

  

              String SQL = "Update stock SET limit = ? WHERE stockType = ?";

      PreparedStatement  pstmt = conn.prepareStatement(SQL);

      ResultSet rs = pstmt.executeQuery();

 

 

3. Callable Statement: when we want to access stored procedures then callable statement are useful and they also accept runtime parameter. It is called like this

          

      CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");

      ResultSet rs = cs.executeQuery();