Untitled

Get the count value in android app from webservice
PreparedStatement statement =  con.prepareStatement("select * from orders where status='Q' AND date = CURDATE()");

        ResultSet result = statement.executeQuery();

       while(result.next()){

   int count=0;
   count++;
  System.out.println(count);
   }
   }

   catch(Exception exc){
     System.out.println(exc.getMessage());
      }

    return customerInfo;
    }

HttpTransportSE ht = new HttpTransportSE(URL);
        try {
        ht.call(SOAP_ACTION, envelope);
        SoapPrimitive response = (SoapPrimitive)envelope.getResponse();
        SoapPrimitive s = response;
        String str = s.toString();
        String resultArr[] = str.split("&");//Result string will split & store in an array

        TextView tv = new TextView(this);

        for(int i = 0; i<resultArr.length;i++){
        tv.append(resultArr[i]+"nn");
       }
        setContentView(tv);

    } catch (Exception e) {
        e.printStackTrace();
    }

int count=0;
while(result.next()){
   count++;
}
System.out.println(count);