Can anyone please explain me how to use DAO pattern for calling stored procedure. MY scenario is mobile based application ,whenever customer calls it has to fetch the data from database using Stored Procedure and i am using MVC attern
Sun's description of the DAO pattern has sample code at the end. There's nothing special about using it for a stored procedure. Just use a CallableStatement rather than a PreparedStatement.