JDBC Callable Statement Example (Gujarati)
CallableStatement interface is used to call the stored procedures or functions.
We can have business logic on the database by the use of stored procedures and functions that will make the performance better because they are precompiled.
For example we need to retrieve the age of the student based on birthdate, one may create a function that receives date as INPUT and returns age of the student as the OUTPUT.
Three types of parameters:
IN : It contains data that is passed to the procedure.
OUT : It is the value returned by the procedure, the result parameter must be registered as an OUT parameter
INOUT : It can be used for both input or output.
Follow me @
🌐 http://www.raviroza.com/
✍️ https://raviroza.wordpress.com/
✍️ https://raviroza.blogspot.com/
✍️ / ravi.oza.it
✍️ / raviozait
📹 / ravioza101
LinkedIN : www.linkedin.com/in/ravi-oza
#RaviROza #JavaEE #Gujarati