.NET WEBSERVICE

 

[SoapRpcMethod(Action = "", RequestNamespace = "", ResponseNamespace = "", Use = SoapBindingUse.Literal)]

[WebMethod]

public string getCourseCount(string key,string id)

{

        if (getKeyIsPass(key).Equals("1"))

        {

            string sql = "select count(1) from USER_COURSE_LOG where DateDiff('n',LOGIN_TIME,LOGOUT_TIME)>30 and COURSEID="+id;

            string count = AccessHelper.ExecuteScalar(AccessHelper.conn, sql).ToString();

            return count;

        }

        else

        {

            return "不正确";

        }

} 

 

JAVA调用WEBSERVICE

 

 

 

    public void CourseCount()throws Exception

    {

         String key = "B0184719-C59E-4EB3-8495-BA3B3401E435;

         String id = "19";     

     

         String endpoint  =   "" ;

         Service service  =   new  Service();

         Call call  =  (Call) service.createCall();

         call.setTargetEndpointAddress( new  java.net.URL(endpoint));

         call.addParameter("key", org.apache.axis.encoding.XMLType.XSD_STRING, javax.xml.rpc.ParameterMode.IN);//参数

         call.addParameter("id", org.apache.axis.encoding.XMLType.XSD_STRING, javax.xml.rpc.ParameterMode.IN);//参数

         call.setOperationName( new  QName( ""));

         call.setUseSOAPAction( true );

         call.setSOAPActionURI("");

         String res  =  (String)call.invoke(new  Object[]{key,id}); //参数

         System.out.println(  " Result:  "   +  res);

    }