import java.sql.*;

public class JDBCStoredProc {
    public static void main(String[] args) throws Exception {

        Connection con = null;
        CallableStatement proc_stmt = null;

        try {
            Class.forName("com.sun.sql.jdbc.sqlserver.SQLServerDriver");
            con = DriverManager.getConnection("jdbc:sun:sqlserver://129.145.133.124:1433;databaseName=dbsmpl1", "dbuser", "dbpassword");
            proc_stmt = con.prepareCall("{ call ADDDISH(? , ?) }");
            proc_stmt.setString(1, "BBQ ribs");
            proc_stmt.setString(2, "BBQ and ribs");
            int rt = proc_stmt.executeUpdate();
            System.out.println("Execution Return : " + rt);
        } catch (ClassNotFoundException ex) {
            ex.printStackTrace();
        } catch (SQLException ex) {
            ex.printStackTrace();
        } finally {
            try {
                proc_stmt.close();
                con.close();
            } catch (SQLException ex) {
                ex.printStackTrace();
            }
        }
    }
   }