You're unlikely to get much of a response to such a general question, especially if you ask it every two hours.
If you want to call stored procedures from Java, you can use
JDBC's PreparedStatement. If you're talking about writing stored procedures
in Java you'll need to get the docs for your particular database.
In any case, you'll get more help if you try something out or tell us what you've researched up already. You also might have better luck in one of the JDBC- or database-centric forum here.