In this article, we will use JDBC API to call stored function in MySQL database from Java application i.e.; using CallableStatement Interface

1. Pre-requisite:

Java JDK 1.8.0_77

MySQL database 5.5.16

Eclipse Luna IDE 4.4.0

mysql-connector-java-5.1.38.jar file

2. Database parameters:

Let us move on and code an example to connect MySQL database from Java application to invoke or call database stored function using JDBC API. But before that, we will list down required things to connect database

database server IP or address (localhost)

sever port (3306)

database name (PLAYER_INFO)

username (root)

password (root@123)

Note: All bold are database values to connect MySQL database

3. Stored Function

This is similar to stored procedure with one difference

That stored function always returns a value

Whereas for stored procedure we must register OUT parameter

3.1 Advantages of using stored function

Increases performance, as these are pre-compiled

Faster execution

Business logic completely inside database with extra-level of security

If there are any changes in business logic, all changes need to be done at database end and not making Java code dirty