calling stored procedure through java

[KTR]

How to call stored procedure with arguments in mysql through java

[prabitha]

Its very easy.
Just try this sample code.
try
{

String var="var";
Connection c=(Connection) new DBConnection().getConnection();
CallableStatement cstmt=(CallableStatement) c.prepareCall("{call databsename`.`procedure_name`('"+var+"')}");
cstmt.execute();

cstmt.close(); c.close();

}

catch(Exception ex)
{
JOptionPane.showMessageDialog(null,"Message");
ex.printStackTrace();
}

[KTR]

thank you.....prabitha