如何将SQLite数据从Android发送到MySQL服务器? [英] How can I send SQLite data from Android to a MySQL server?
问题描述
我试图用在线MySQL服务器发送我的SQLite数据,但无济于事。当然,我跑到谷歌,很幸运地找到了这个。显然它应该工作,它确实有效,但我没有收到我服务器上的数据。
I am trying to send my SQLite data with online MySQL server but to no avail. Naturally, I ran to Google and was lucky enough to find this. Apparently it's supposed to work and it does but I am not receiving the data on my server.
我知道这个问题已被提出在哪里和 ,但我无法使用给出的建议对其进行补丁。
I know this question has been asked here and here, but I haven't been able to patch it up using the suggestions given.
这是我尝试过的。这是我使用GSON将SQLite数据转换为JSON的方式:
Here is what I have tried. This is how I convert my SQLite data into JSON using GSON:
public String composeJSONfromSQLite() {
ArrayList<HashMap<String, String>> offlineList;
offlineList = new ArrayList<HashMap<String, String>>();
String selectQuery = "SELECT * FROM offlineTable ";
SQLiteDatabase database = this.getWritableDatabase();
Cursor cursor = database.rawQuery(selectQuery, null);
if (cursor.moveToFirst()) {
do {
HashMap<String, String> map = new HashMap<String, String>();
map.put("zip", cursor.getString(1));
map.put("phone", cursor.getString(2));
map.put("uid", cursor.getString(3));
offlineList.add(map);
} while (cursor.moveToNext());
}
database.close();
Gson gson = new GsonBuilder().create();
//Use GSON to serialize Array List to JSON
return gson.toJson(offlineList);
}
这就是我将它发送到服务器的方式:
And this is how I send it to my server:
public void syncSQLiteMySQLDB() {
AsyncHttpClient client = new AsyncHttpClient();
RequestParams params = new RequestParams();
params.put("offline",loadCheckoutDB.composeJSONfromSQLite());
Log.d("offline data log", loadCheckoutDB.composeJSONfromSQLite());
client.addHeader("session_id", getapikey());
client.addHeader("Content-Type", "application/json");
client.post("http://example.com/offline/api", params, new AsyncHttpResponseHandler() {
@Override
public void onSuccess(int statusCode, Header[] headers, byte[] responseBody) {
String s = new String(responseBody);
Log.d("response to sync", s);
try {
JSONObject obj = new JSONObject(s);
if (obj.getBoolean("success")) {
String success = obj.getString("message");
//Toast.makeText(getApplicationContext(), success, Toast.LENGTH_LONG).show();
} else {
String failure = obj.getString("message");
//Toast.makeText(getApplicationContext(), failure, Toast.LENGTH_LONG).show();
}
} catch (JSONException e) {
}
}
@Override
public void onFailure(int statusCode, Header[] headers, byte[] responseBody, Throwable error) {
// Toast.makeText(getApplicationContext(), "Failed to sync with server", Toast.LENGTH_LONG).show();
Log.d("sqlite sync error", String.valueOf(error));
progbar.setVisibility(View.INVISIBLE);
}
});
}
当我从Android记录JASON的样子时,我得到以下格式:
And when I log what the JASON looks like from Android I get this format:
[{
"zip": "325,
"phone": "78291849",
"uid": "14538177211"
}]
但在我的服务器上我仍然得到一个空数组。我做错了什么?
But on my server I still get an empty array. What am I doing wrong?
这就是我的请求格式应该是这样的:
This is how my request format should look like:
{
"offline":[
{
"zip": "325,
"phone": "78291849",
"uid": "14538177211"
}
]
}
以下是我收到请求的方式:
Here is how I receive the request:
public function massData()
// offline sync
{
$input = Input::all();
return $input;
推荐答案
以下是我的表现:
public void syncSQLiteMySQLDB() {
//i get my json string from sqlite, see the code i posted above about this
final String json = loadCheckoutDB.composeJSONfromSQLite();
new Thread() {
public void run() {
makeRequest("http://myexample/offline/api", json);
}
}.start();
}
public void makeRequest(String uri, String json) {
try {
HttpClient client = new DefaultHttpClient();
HttpPost httpPost = new HttpPost(uri);
httpPost.setEntity(new StringEntity(json));
httpPost.setHeader("Accept", "application/json");
httpPost.setHeader("session_id", getapikey());
httpPost.setHeader("Content-type", "application/json");
HttpResponse response = client.execute(httpPost);
if (response != null) {
String responseBody = EntityUtils.toString(response.getEntity());
Log.d("response to sync", responseBody);
Object jsonObj = new JSONTokener(responseBody).nextValue();
if (jsonObj instanceof JSONObject) {
JSONObject jsonObject = (JSONObject) jsonObj;
//further actions on jsonObjects
} else if (jsonObj instanceof JSONArray) {
//further actions on jsonArray
JSONArray jsonArray = (JSONArray) jsonObj;
}
}
} catch (UnsupportedEncodingException e) {
e.printStackTrace();
} catch (ClientProtocolException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} catch (JSONException e) {
e.printStackTrace();
}
}
从记录众多回复中我发现我没有发送content-type使用我以前的方法。尝试完这段代码后,它就可以了。
From logging numerous responses I discovered that I was not sending content-type using my previous method. After trying out this code, it worked.
这篇关于如何将SQLite数据从Android发送到MySQL服务器?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!