xml备份短信和sqlite备份短信
package com.example.copymsm; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.util.ArrayList; import java.util.List; import org.xmlpull.v1.XmlSerializer; import android.net.Uri; import android.os.Bundle; import android.os.Environment; import android.app.Activity; import android.database.Cursor; import android.util.Xml; import android.view.Menu; import android.view.View; import android.view.View.OnClickListener; import android.widget.Toast; public class MainActivity extends Activity { private List<Mess> list; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); list = new ArrayList<Mess>(); Cursor result = getContentResolver().query(Uri.parse("content://sms/"), null, null, null, null); while (result.moveToNext()) { Mess m = new Mess(); m.setBody(result.getString(result.getColumnIndex("body"))); m.setDate(result.getString(result.getColumnIndex("date"))); m.setType(result.getString(result.getColumnIndex("type"))); m.setPhone(result.getString(result.getColumnIndex("address"))); list.add(m); } findViewById(R.id.button1).setOnClickListener(new OnClickListener() { @Override public void onClick(View v) { // TODO Auto-generated method stub if (Environment.getExternalStorageState().equals( Environment.MEDIA_MOUNTED)) { Toast.makeText(MainActivity.this, "点击了", 0).show(); File file = new File(Environment .getExternalStorageDirectory() + File.separator + "sms.xml"); try { FileOutputStream fos = new FileOutputStream(file); XmlSerializer xs = Xml.newSerializer(); xs.setOutput(fos, "utf-8"); xs.startDocument("utf-8", true); xs.startTag(null, "message"); for (int i = 0; i < list.size(); i++) { xs.startTag(null, "msm"); xs.startTag(null, "body"); xs.text(list.get(i).getBody()); xs.endTag(null, "body"); xs.startTag(null, "type"); xs.text(list.get(i).getType()); xs.endTag(null, "type"); xs.startTag(null, "date"); xs.text(list.get(i).getDate()); xs.endTag(null, "date"); xs.startTag(null, "phone"); xs.text(list.get(i).getPhone()); xs.endTag(null, "phone"); xs.endTag(null, "msm"); } xs.endTag(null, "message"); xs.endDocument(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } } } }); } }
package com.example.copymsm; public class Mess { private String body; private String type; private String date; private String phone; public String getBody() { return body; } public void setBody(String body) { this.body = body; } public String getType() { return type; } public void setType(String type) { this.type = type; } public String getPhone() { return phone; } public void setPhone(String phone) { this.phone = phone; } public String getDate() { return date; } public void setDate(String date) { this.date = date; } public Mess(){} @Override public String toString() { return "Mess [body=" + body + ", type=" + type + ", date=" + date + ", phone=" + phone + "]"; } }
数据库备份短信
package com.example.copymsm1; import android.content.Context; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class Myhelp extends SQLiteOpenHelper { public Myhelp(Context context) { super(context, "data.db", null, 1); // TODO Auto-generated constructor stub } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub String sql = "create table msg(" + "_id integer primary key," + "body varchar(255)," + "type varchar(10)," + "address varchar(50)," + "date varchar(50)" + ")"; db.execSQL(sql); } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub } }
package com.example.copymsm1; import android.net.Uri; import android.os.Bundle; import android.app.Activity; import android.content.ContentValues; import android.database.Cursor; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; public class MainActivity extends Activity { private SQLiteOpenHelper help; private SQLiteDatabase db; @Override protected void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.activity_main); help = new Myhelp(this); db = help.getWritableDatabase(); Cursor result = getContentResolver().query(Uri.parse("content://sms/"), null, null, null, null); while (result.moveToNext()) { String body = result.getString(result.getColumnIndex("body")); String date = result.getString(result.getColumnIndex("date")); String type = result.getString(result.getColumnIndex("type")); String address = result.getString(result.getColumnIndex("address")); ContentValues cv = new ContentValues(); cv.put("body", body); cv.put("type", type); cv.put("date", date); cv.put("address", address); db.insert("msg", null, cv); } } }