Java Database connectivity(JDBC) doubt ?

General discussion on technical and managerial topics
no avatar
ravindrareddy.ganji
 
Posts: 1
Joined: Sun Oct 14, 2012 9:54 am

Java Database connectivity(JDBC) doubt ?

by ravindrareddy.ganji » Sun Oct 14, 2012 10:24 am

what is the return type of callable statement in JDBC

no avatar
daniel88
 
Posts: 11
Joined: Thu Dec 27, 2012 12:37 pm
Location: VIET NAM

»

by daniel88 » Fri Dec 28, 2012 10:41 am

A Simple Example of callable statement is give below which calls the stored procedure HI() from database student.

At first create a database student in MySql Then Create a Stored procedure in the database as

DELIMITER //
REATE PROCEDURE `HI`()
BEGIN
SELECT 'HI FRIEND !' AS MESSAGE;
END //
DELIMITER;

Return to General Discussion

cron