android使用json数据格式同时上传图片和文本

最近看到一个题目,android端要将图片和文本一起上传给服务器端的sql server数据库,同时也要实现获取sql server数据库上的数据。

为了让这些数据区分开来(哪个字符串是哪个字段),我用了json数据格式,最麻烦的是image,它应该怎么被传输呢,最后查阅了一些资料,最后我用base64编码来实现

首先imageview上的图片是通过拍照的照片得来的,所以要把imageview上的图片获取下来并转换成bitmap

 so,drawable转换成bitmap的代码为:

	private String getJsonString(String name, String age, String cardId,
			Bitmap mBitmap) {
		try {
			JSONObject object = new JSONObject();
			object.put("name", name);
			object.put("age", age);
			object.put("cardId", cardId);
			byte[] data = BitmapToByte(mBitmap);
			object.put("image", Base64.encodeToString(data, 0));
			return object.toString();
		} catch (JSONException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}

再把文本和image一起放在json数据中:

	private String getJsonString(String name, String age, String cardId,
			Bitmap mBitmap) {
		try {
			JSONObject object = new JSONObject();
			object.put("name", name);
			object.put("age", age);
			object.put("cardId", cardId);
			byte[] data = BitmapToByte(mBitmap);
			object.put("image", Base64.encodeToString(data, 0));
			return object.toString();
		} catch (JSONException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return null;
	}

  c#服务器端解析并存入数据库中:

        public void ProcessRequest(HttpContext context)
        {
            try
            {
                StreamReader s = new StreamReader(context.Request.InputStream, Encoding.UTF8);
                string content = "";
                StringBuilder builder = new StringBuilder();
                while ((content = s.ReadLine()) != null)
                {
                    builder.Append(content);
                }
                JavaScriptSerializer ser = new JavaScriptSerializer();
                jsonObject ob = ser.Deserialize<jsonObject>(builder.ToString());
                byte[] imageBytes = Convert.FromBase64String(ob.image);
                exeSql(ob.name, ob.age, ob.cardId, imageBytes);
                context.Response.Write(ob.name+","+ob.age+","+ob.cardId+","+ob.image);
            }
            catch (Exception ex)
            {
                context.Response.Write(ex.Message.ToString());   
            }
        }
        public void exeSql(string name,string age,string cardid,byte[] data)
        {
            SqlConnection conn = new SqlConnection("server=.;database=Images;uid=sa;pwd=123456;");
            conn.Open();
            SqlCommand comm = new SqlCommand();
            comm.CommandText = string.Format("insert into RegisterTable values('{0}','{1}','{2}',@image)", name,age,cardid);
            comm.Connection = conn;
            comm.Parameters.Add("@image", System.Data.SqlDbType.Image, data.Length);
            comm.Parameters["@image"].Value = data;
            comm.ExecuteNonQuery();
            conn.Close();
        }

服务器端展示数据库中所有的数据:

   public void ProcessRequest(HttpContext context)
        {
            DataTable dt =  getSqlData();
            List<jsonObject> list=new List<jsonObject>();
            if (dt.Rows.Count==0)
            {
                context.Response.Write("无数据");
                return; 
            }
            foreach (DataRow dr in dt.Rows)
	        {
		        jsonObject ob = new jsonObject();
                ob.name = dr[1].ToString();
                ob.age = dr[2].ToString();
                ob.cardId = dr[3].ToString();
                byte[] data=(byte[])dr[4];
                ob.image = Convert.ToBase64String(data, 0, data.Length);
                list.Add(ob);
	        }
            JavaScriptSerializer ser = new JavaScriptSerializer();
            string jsonstring=ser.Serialize(list);
            context.Response.Write(jsonstring+"\r\n");
        }
        public DataTable getSqlData()
        {
            SqlDataAdapter comm = new SqlDataAdapter("select * from RegisterTable", "server=.;database=Images;uid=sa;pwd=123456;");
            DataTable dt = new DataTable();
            comm.Fill(dt);
            return dt;
        }

JsonObject类结构:

    public class jsonObject
    {
        public string name { get; set; }
        public string age { get; set; }
        public string cardId { get; set; }
        public string image { get; set; }
    }

android端解析服务器端的数据库数据并展示在listview中:

	private Handler handler = new Handler() {
		public void handleMessage(android.os.Message msg) {
			String result = (String) msg.obj;//result是获取到的服务器的数据,然后通过hander传递到handleMessage方法中
			try {
				JSONArray array = new JSONArray(result);
				List<DataBean> mList = new ArrayList<DataBean>();
				for (int i = 0; i < array.length(); i++) {
					JSONObject object = array.getJSONObject(i);
					String name = object.getString("name");
					String age = object.getString("age");
					String cardid = object.getString("cardId");
					String image = object.getString("image");
					byte[] data = Base64.decode(image, 0);
					DataBean bean = new DataBean(name, age, cardid
							, BitmapFactory.decodeByteArray(data, 0, data.length));
					mList.add(bean);
				}
				MyAdapter adapter = new MyAdapter(ListActivity.this, mList);
				lv1.setAdapter(adapter);
			} catch (JSONException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		};
	};

剩下的都都是填充数据的部分,我就不贴代码咯~These sentence are core.