Android通过JSON读写Mysql（写）

来源：互联网发布：变脸软件有哪些编辑：程序博客网时间：2024/06/06 20:38

这里写图片描述
在我的数据库中有一张名为index的表，里面有三个字段，
ID int auto_increment,
TITLE text,
CONTENT text;

Android代码下面是一个封装的类

package com.example.jsontest;import java.io.BufferedReader;import java.io.IOException;import java.io.InputStream;import java.io.InputStreamReader;import java.io.UnsupportedEncodingException;import java.util.List;import org.apache.http.HttpEntity;import org.apache.http.HttpResponse;import org.apache.http.NameValuePair;import org.apache.http.client.ClientProtocolException;import org.apache.http.client.entity.UrlEncodedFormEntity;import org.apache.http.client.methods.HttpPost;import org.apache.http.impl.client.DefaultHttpClient;import org.apache.http.protocol.HTTP;import org.json.JSONException;import org.json.JSONObject;import android.util.Log;public class JSONParser {     static InputStream is = null;     static JSONObject jObj = null;     static String json = "";     public JSONParser() {    }     public JSONObject makeHttpRequest(String url, String method,     List<NameValuePair> params) {          try {                 DefaultHttpClient httpClient = new DefaultHttpClient();                 HttpPost httpPost = new HttpPost(url);                 //使用UTF-8进行数据格式编码                httpPost.setEntity(new UrlEncodedFormEntity(params,HTTP.UTF_8));                 HttpResponse httpResponse = httpClient.execute(httpPost);                 HttpEntity httpEntity = httpResponse.getEntity();                 is = httpEntity.getContent();                       } catch (UnsupportedEncodingException e){            e.printStackTrace();        } catch (ClientProtocolException e) {             e.printStackTrace();         } catch (IOException e) {             e.printStackTrace();         }      try{             BufferedReader reader = new BufferedReader(new InputStreamReader(             is, "UTF-8"));             StringBuilder sb = new StringBuilder();             String line = null;             while ((line = reader.readLine()) != null) {             sb.append(line + "\n");             }             is.close();             json = sb.toString();        } catch (Exception e) {             Log.e("Buffer Error", "Error converting result " + e.toString());             Log.d("json", json.toString());           }        // try parse the string to a JSON object         try {         jObj = new JSONObject(json);         } catch (JSONException e) {         Log.e("JSON Parser", "Error parsing data " + e.toString());         }         // return JSON String         return jObj;     } }

MainActivity

   //------------------------//        StrictMode.setThreadPolicy(new StrictMode.ThreadPolicy.Builder()            .detectDiskReads()            .detectDiskWrites()            .detectNetwork()   // or .detectAll() for all detectable problems            .penaltyLog()            .build());            StrictMode.setVmPolicy(new StrictMode.VmPolicy.Builder()            .detectLeakedSqlLiteObjects()            .detectLeakedClosableObjects()            .penaltyLog()            .penaltyDeath()            .build());          //------------------------//        List<NameValuePair> params = new ArrayList<NameValuePair>();         //这里可以替换成你自己程序中的一些键值对        String title = "xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";        String content = "00000000000000000000000000000000000000000000000";        params.add(new BasicNameValuePair("TITLE", ""+title));         params.add(new BasicNameValuePair("CONTENT", ""+ content));         JSONParser jsonParser = new JSONParser();        //这里是你自己的接收数据的php文件的路径        String url_up = "http://10.0.2.2/dipingxian/insertbeat.php";        try{         JSONObject json = jsonParser.makeHttpRequest(url_up,"POST", params);         Log.v("uploadsucceed", "uploadsucceed");         }catch(Exception e){         e.printStackTrace();         }

success

1 0