Re: java and ms-server

New to the group to sorry if this has been asked before.
I am learniing Java at Uni and so far I have connected to a MS Server
and I have read data ok. Now I want to connect to the stored
procedures already in place.

Below is a procedure in question -
CREATE PROCEDURE record_count
(
@cnt int OUTPUT
)
AS
BEGIN
  /* Procedure body */
  SELECT @cnt = count(8)
  From curry
END

Nice and easy returns number of records in table.
Here is my working c# code

    public int recCount()
    {
        try
        {
            openCon();
        //not sure from here peeps SqlCommand cmd = new
SqlCommand("record_count", con);
            cmd.CommandType = CommandType.StoredProcedure;
            SqlParameter countParameter = new SqlParameter("@cnt", 0);
            countParameter.Direction = ParameterDirection.Output;
            cmd.Parameters.Add(countParameter);
            cmd.ExecuteNonQuery();
            int rc =
Int32.Parse(cmd.Parameters["@cnt"].Value.ToString());
            if (con.State == ConnectionState.Open) con.Close();
            return rc;
        }
        catch (Exception ex)
        {
            string exx = ex.Message ;
            return 0;
        }
    }

Can anyone point me in the correct direction for the Java method please.
Many thankings in advance.