PreparedStatements or callableStatements

Question

I tried to understand the difference between PreparedStatements & CallableStatements and I couldn't get it. so please can anyone convert following sql Query to CallableStatement. I know how to convert Statement into a PreparedStatement but having problems with CallableStatements.

as a java.sql.Statement

SELECT * FROM Customer WHERE customerId = 'C001'

as a java.sql.PreparedStatement

SELECT * FROM Customer WHERE customerId = ? //set customerId using preparedStatement.setString(1,"C001")

How to write this same query in CallableStatements

Thanks in advance!

Possible duplicate of [JDBC - Statement, PreparedStatement, CallableStatement and caching](https://stackoverflow.com/questions/8371053/jdbc-statement-preparedstatement-callablestatement-and-caching) — rene, Oct 07 '17 at 20:58

score 6 · Accepted Answer · answered Mar 24 '13 at 18:40

6

As stated in the CallableStatement API:

The interface used to execute SQL stored procedures.

And as such, it can not be used to execute queries.

answered Mar 24 '13 at 18:40

MrLore

3,759
2
28
36

score 1 · Answer 2 · answered Mar 24 '13 at 18:42

Callable Statements are used for accessing stored procedures.

You have to write stored procedure in database

for

SELECT * FROM Customer WHERE customerId = 'C001'

And

please look into the following links to have help on callable statements -

1 > http://www.mkyong.com/jdbc/jdbc-callablestatement-stored-procedure-out-parameter-example/

2> http://www.tutorialspoint.com/jdbc/callablestatement-object-example.htm

Thanks

score 0 · Answer 3 · edited May 23 '17 at 11:57

0

check this

DIfference Between Stored Procedures and Prepared Statements..?

CallableStatement used for mainly StoredProcedure

edited May 23 '17 at 11:57

Community

1
1

answered Mar 24 '13 at 18:39

Akshay Joy

1,765
1
14
23

PreparedStatements or callableStatements

3 Answers3

Linked