JDBC Statement: types of Statement

[Introduction]

In order to Execute different queries in java program, we need a Statement that is Interface and represents the SQL query.

• Interface is part of the java.sql package.
• An object of Connection Interface is used to create a statement. 

 There are three types of statements.

1. Statement-> This Statement is used to implement simple queries like creating a table and other which have no parameter means query of table creation "CREATE TABLE DEMO (ID int)".This is a static query so we can use a Statement to implement it.
String query = "create table employee(id int, name varchar(20),salary int)"; Statement st = conn.createStatement(); 
2. PreparedStatement-> PreparedStatement is used when we need a dynamic query, suppose you created a search box. The value of this box will fetch the details of that. so it is not possible to write a search query for every value. the possible way is to pass a different value in the query.
String query = "select * from employee where id=?"; PreparedStatement ps = conn.prepareStatement(query); ps.setInt(1,5);



always excited

here I have used ? which is very important. It shows that the value of the argument will be replaced with ? symbol.  The question is how to set the arguments in the query. By using setXXX(arg_no, value) we can set the value at ? in the query. setXXX(arg_no, value) is a general form. we can replace it according to the data type. ex. setInt(1, 5) , setString(2,"demo")   first argument of the method is the number of the argument. the number starts with 1.
3. CallableStatement-> Used to execute stored procedures(function) that may contain both input and output parameters.

con.prepareCall("{call function_name}");
[connection code]

Posted by : Denes Vaghani February 24, 2020 Tags : JDBC

Subscribe by Email

Follow Updates Articles from This Blog via Email