techFAQ

Statement : Statement every time compile the SQL and Execute.

Example: String sql="select * from emp where emp_id = 1";

Statement stmt = conn.createStatement(sql);



PreparedStatement :

If we are using PreparedStatement the execution time will be less. First time RDBMS comiple the SQL and PreparedStatement is executed then other calls doesn't compile the SQL only execute the SQL within the connection live.



you must use a PreparedStatement object if you want to use large objects like BLOBs or CLOBs.



PreparedStatement is its support for batching



Example :

String sql="select * from emp where emp_id = ?";

PreparedStatement pStmt = conn.prepareStatement(sql);

pStmt.setLong(1, profile.getUserId());



CallableStatement :CallableStatement is for call to a stored procedure.

Example :

CallableStatement cs =

con.prepareCall("{call SHOW_CUSTOMER}");

ResultSet rs = cs.executeQuery();