JDBC_MySQL_StoredFunction1
  • String dbURL = "jdbc:mysql://localhost/test?";
    String user = "Manas9"; String pwd = "Manas9237";
  • SQL string calling stored function:
    String sql1 = "{?=call ctof(28.25)}" ;
     
It works different from PHP

Note SQL workbench:

DROP FUNCTION IF EXISTS ctof;
DELIMITER $$

CREATE FUNCTION ctof (i NUMERIC(4,2))
RETURNS NUMERIC(4,2)
BEGIN
DECLARE t1 NUMERIC(4,2) ;
set t1 = ((i * 9/5)+32);
RETURN t1;

END$$
Code Snippet:

a)

b) Processing result set:

Complete Code :JDBC_MySQL_StoredFunction1.txt