1
JavaIntermediate#jdbc
JavaIntermediate#jdbc
What is a CallableStatement used for?
It's used to execute stored procedures in the database, supporting IN, OUT, and INOUT parameters, unlike PreparedStatement which is for standard SQL statements.
Example
CallableStatement cs = conn.prepareCall("{call getUserById(?, ?)}");
cs.setInt(1, 5);
cs.registerOutParameter(2, Types.VARCHAR);
cs.execute();
String name = cs.getString(2);