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 blocke.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 blocke.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 blocke.printStackTrace();}};};

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