两个apk之间广播互相通信及ContentProvider监听数据库的变换

package com.util; import android.content.Context; import android.database.Cursor; import android.database.SQLException; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.util.Log; public class SQLiteHelp extends SQLiteOpenHelper { public final static int VERSION = 1;// 版本号 public SQLiteHelp(Context context) { super(context, "login.db", null, VERSION); // TODO Auto-generated constructor stub } @Override public void onCreate(SQLiteDatabase db) { // TODO Auto-generated method stub try { db.execSQL("create table IF NOT EXISTS user (id INTEGER PRIMARY KEY AUTOINCREMENT,Name String,Password String)"); } catch (SQLException ex) { Log.i("sqlliteHelp", "数据库创建失败"); } } @Override public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { // TODO Auto-generated method stub try { db.execSQL("drop table if exists user"); this.onCreate(db); } catch (SQLException ex) { Log.i("sqlliteHelp", ""); } } /** * 用于执行增删改操作 * * @param sql * 以insert,update,delete打头的sql语句 */ public void ExecuteSQL(String sql) { SQLiteDatabase db = this.getWritableDatabase(); try { Log.i("sqlliteHelp", sql); db.execSQL(sql); } catch (SQLException ex) { throw ex; } finally { db.close(); } } /** * 用于完成数据的查询操作 * * @param sql * 以Select打头的SQL语句 * @return Cursor * @throws SQLException */ public Cursor SELECTUser(String condition) throws SQLException { SQLiteDatabase db = this.getReadableDatabase(); Cursor cursor = null; cursor = db.query("user", new String[] { "id", "name", "password" }, condition, null, null, null, null); return cursor; } }