如何在Sq-lite和MYSQL中保存和同步android数据 [英] how to save and synchronize android data in Sq-lite as well as MYSQL

问题描述

我想保存我的移动数据，比如contectid，firstname，lastname，mobile no，存储在SQlite数据库中的电子邮件，使用jsp进入Mysql数据库，请发给我解决方案.......

解决方案

package com.example.upload;



import java.io.ByteArrayOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java。 net.HttpURLConnection;

import java.net.URL;

import java.util.ArrayList;

import java.util.Scanner;



import org.apache.http.HttpEntity;

import org.apache.http.HttpResponse;

import org.apache.http.NameValuePair;

import org.apache.http.client.HttpClient;

import org.apache.http.client.entity.UrlEncodedFormEntity;

import org.apache.http.client.methods.HttpPost;

import org.apache.http.impl.client.DefaultHttpClie nt;

import org.apache.http.message.BasicNameValuePair;



导入android.os.Bundle;

import android.app.Activity;

import android.graphics.Bitmap;

import android.graphics.Bitmap.CompressFormat;

import android.graphics.BitmapFactory;

导入android.util.Base64;

导入android.util.Log;

导入android.view.Menu ;

公共类MainActivity扩展活动{



InputStream是;



@Override



public void onCreate（Bundle icicle）{



super.onCreate（icicle）; < br $>


setContentView（R.layout.activity_main）;





ArrayList<的NameValuePair> nameValuePairs = new



ArrayList< namevaluepair>（）;



nameValuePairs.add（new BasicNameValuePair（姓名，我的名字））;



nameValuePairs.add（new BasicNameValuePair（Age，23））;

..............

...............

.... .......



试试{



HttpClient httpclient = new DefaultHttpClient（）; < br $>


HttpPost httppost = new



HttpPost（http：// ........ .....你的php文件网址）;



httppost.setEntity（new urlEncodedFormEntity（nameValuePairs））;



HttpResponse response = httpclient.execute（httppost）;



HttpEntity entity = response.getEntity（）;



= = entity.getContent（）;



} catch（例外e）{



Log.e（log_tag，http连接错误+ e.toString（））;



}





..........这里写android代码插入数据到SQLite数据库.........

......... .........

..............

..........

}

}

并在php中通过帮助这个PHP代码我们可以得到它

name =

< blockquote> _REQUEST [''name''];

i want to save my mobile data like contectid,firstname,lastname,mobile no,emails which is stored in SQlite database,into the Mysql data base using jsp than please send me solution.......

解决方案

package com.example.upload;

import java.io.ByteArrayOutputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
import java.net.HttpURLConnection;
import java.net.URL;
import java.util.ArrayList;
import java.util.Scanner;

import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.HttpClient;
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.message.BasicNameValuePair;

import android.os.Bundle;
import android.app.Activity;
import android.graphics.Bitmap;
import android.graphics.Bitmap.CompressFormat;
import android.graphics.BitmapFactory;
import android.util.Base64;
import android.util.Log;
import android.view.Menu;
public class MainActivity extends Activity {

InputStream is;

@Override

public void onCreate(Bundle icicle) {

super.onCreate(icicle);

setContentView(R.layout.activity_main);


ArrayList<namevaluepair> nameValuePairs = new

ArrayList<namevaluepair>();

nameValuePairs.add(new BasicNameValuePair("Name","My Name"));

nameValuePairs.add(new BasicNameValuePair("Age","23"));
..............
...............
...........

try{

HttpClient httpclient = new DefaultHttpClient();

HttpPost httppost = new

HttpPost("http://.............your php file url ");

httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));

HttpResponse response = httpclient.execute(httppost);

HttpEntity entity = response.getEntity();

is = entity.getContent();

}catch(Exception e){

Log.e("log_tag", "Error in http connection "+e.toString());

}


..........Here write the android code to inset data into SQLite database.........
..................
..............
..........
}
}

And in php by the help of this php code we can get it

name=

_REQUEST[''name''];

这篇关于如何在Sq-lite和MYSQL中保存和同步android数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！