JDBC Callable Statement Theory

  • 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 birth date, one may create a function that receives date as INPUT and returns age of the student as the OUTPUT.