本章主要介绍(C#)webservice返回json返回并显示表格,也参考了一些资料
界面定义不做重点了
1.调用返回
btn4.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
list2.clear();
adapter.notifyDataSetChanged();
String s = txt1.getText().toString();
String ss = txt2.getText().toString();
flag = 1;
// GetBoolValue(s,ss);
Map<String, String> values = new HashMap<String, String>();
values.put("p1", s);
values.put("p2", ss);
values.put("p2", ss);
Request(GetUser, null, 2);//2这里就是不同的标记值解析不同的方法,handle里面要用
}
});
public void Request(Object... params2) {
new AsyncTask<Object, Object, String>() {
@SuppressWarnings("unchecked")
@Override
protected String doInBackground(Object... params) {
if (params != null) {
Log.i("MY", "111111111111111111111111111111111111111111");
return ServiceClass.CallWebService((String) params[0],
(Map<String, String>) params[1], handler,
(Integer) params[2]);
} else
return "";
}
}.execute(params2);
}
//3.解析并显示 这里注意
private Handler handler = new Handler() {
@Override
public void handleMessage(Message msg) {
// findViewById(R.id.Btn_Login).setEnabled(true);
// progressDialog.dismiss();
switch (msg.what) {
case 2:
// login success
// MessageHelper.AlertDialog(this, "操作提示",msg.obj.toString());
list2.clear();
lv.setAdapter(adapter);
String str = msg.obj.toString();
JSONArray jsonArray = null;
try {
jsonArray = new JSONObject(str).getJSONArray("ds");
// 获得json字符串里名字为ds的数组,如果ds不是最外层,请通过ds的父对象来取
// JSONObject joJsonObject=new
// JSONObject(str).getJSONObject("dss").getJSONArray("ds");//dss是ds的外层
int count = jsonArray.length();
for (int index = 0; index < count; index++) {
//解析对应数据库字段
String id = jsonArray.optJSONObject(index)
.getString("id").toString();
String userid = jsonArray.optJSONObject(index)
.getString("userid").toString();
String username = jsonArray.optJSONObject(index)
.getString("username").toString();
//如下几行就是list填充
HashMap<String, Object> map = new HashMap<String, Object>();
map.put("id", id);
map.put("userid", userid);
map.put("username", username);
list2.add(map);
}
} catch (JSONException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
break;
default:
break;
}
}
};
2.类封装
public class ServiceClass {
//如下4个是对应的webservice方法名
final static String METHOD_HELLO_WORLD = "HelloWorld";
final static String GetNum = "GetNum";
final static String GetString="GetString";
final static String GetStringAnd="GetStringAnd";
final static String func = "http://tempuri.org/HelloWorld2";
// 服务器链接
final static String WEB_SERVICE_URL = "http://192.168.199.156:8020/Service.asmx";// 改自己的webservice地址
final static String Namespace = "http://tempuri.org/";// 命名空间
/**
* 调用WebService
*
* @return WebService的返回值
*
*/
public static String CallWebService(String MethodName, Map<String, String> Params,Handler handler,int waitflag) {
Message msg = new Message();
// 1、指定webservice的命名空间和调用的方法名
try {
SoapObject request = new SoapObject(Namespace, MethodName);
// 2、设置调用方法的参数值,如果没有参数,可以省略,
if (Params != null) {
Iterator iter = Params.entrySet().iterator();
while (iter.hasNext()) {
Map.Entry entry = (Map.Entry) iter.next();
request.addProperty((String) entry.getKey(),
(String) entry.getValue());
}
}
// 3、生成调用Webservice方法的SOAP请求信息。该信息由SoapSerializationEnvelope对象描述
SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(
SoapEnvelope.VER12);
envelope.bodyOut = request;
// c#写的应用程序必须加上这句
envelope.dotNet = true;
HttpTransportSE ht = new HttpTransportSE(WEB_SERVICE_URL);// WEB_SERVICE_URL
// 使用call方法调用WebService方法
try {
ht.call(null, envelope);
} catch (HttpResponseException e) {
e.printStackTrace();
return "";
} catch (IOException e) {
e.printStackTrace();
return "";
} catch (XmlPullParserException e) {
e.printStackTrace();
return "";
}
final SoapObject result = (SoapObject) envelope.bodyIn;
if (result != null) {
Log.d("----收到的回复----", result.toString());
msg.obj = result.getProperty(0).toString();
msg.what =waitflag;
} else {
msg.obj = "返回为空";
msg.what = 0;
}
return "";
} catch (Exception e) {
msg.obj = "异常";
msg.what = -1;
return "";
}
finally{
handler.sendMessage(msg);
}
}
}
3,WEBSERVICE后台转换json
// 将dataTable数据构造成Json格式的字符串
public static string DataTable2Json(DataTable dt)
{
if (dt != null && dt.Rows.Count > 0)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{");
jsonBuilder.Append("\"ds\"");
jsonBuilder.Append(":[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"" + dt.Columns[j].ColumnName + "\"");
jsonBuilder.Append(":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
else
{
return "{\"ds\":{}}";
}
}