java服务在数据库上的插入超出预期
我从CallLog获取联系人,并使用ContentObserver服务将其插入数据库。因此,ContentObserver会继续监视调用日志是否发生了一些新的更改,如果是,它会在方法onChange()中调用在调用日志中获取数据并将其插入数据库的方法
但是,问题是,如果我打一个新的电话,有一个新的数据,所以,它必须插入到数据库中,只有一个新行,但它插入了3行。我不知道为什么。我在Android 2.3 Emulator上测试了它,在Emulator上它还可以,但在真正的2.3设备上它会发生。在2.1模拟器中,这种情况也会发生
这是我的代码。该服务已发布。谢谢
这是我的应用服务。java
public class MyApplicationService extends Service {
private Handler handler = new Handler();
private SQLiteDatabase db;
private OpenHelper helper;
class MyApplicationContentObserver extends ContentObserver {
public MyApplicationContentObserver(Handler h) {
super(h);
helper = new OpenHelper(getApplicationContext());
db = helper.getWritableDatabase();
}
@Override
public boolean deliverSelfNotifications() {
return true;
}
@Override
public void onChange(boolean selfChange) {
super.onChange(selfChange);
searchInsert();
}
}
@Override
public IBinder onBind(Intent arg0) {
return null;
}
@Override
public void onCreate() {
db = DataHandlerDB.createDB(this);
registerContentObservers();
}
@Override
public void onDestroy() {
db.close();
}
private void searchInsert() {
Cursor cursor = getContentResolver().query(
安卓.provider.CallLog.Calls.CONTENT_URI, null, null, null,
安卓.provider.CallLog.Calls.DATE + " DESC ");
if (cursor.moveToFirst()) {
int numberColumnId = cursor
.getColumnIndex(安卓.provider.CallLog.Calls.NUMBER);
int durationId = cursor
.getColumnIndex(安卓.provider.CallLog.Calls.DURATION);
int contactNameId = cursor
.getColumnIndex(安卓.provider.CallLog.Calls.CACHED_NAME);
int numTypeId = cursor
.getColumnIndex(安卓.provider.CallLog.Calls.CACHED_NUMBER_TYPE);
int callTypeId = cursor
.getColumnIndex(安卓.provider.CallLog.Calls.TYPE);
Date dt = new Date();
int hours = dt.getHours();
int minutes = dt.getMinutes();
int seconds = dt.getSeconds();
String currTime = hours + ":" + minutes + ":" + seconds;
SimpleDateFormat dateFormat = new SimpleDateFormat("M/d/yyyy");
Date date = new Date();
cursor.moveToFirst();
String contactNumber = cursor.getString(numberColumnId);
String contactName = (null == cursor.getString(contactNameId) ? ""
: cursor.getString(contactNameId));
String duration = cursor.getString(durationId);
String numType = cursor.getString(numTypeId);
String callType = cursor.getString(callTypeId);
ContentValues values = new ContentValues();
values.put("contact_id", 1);
values.put("contact_name", contactName);
values.put("number_type", numType);
values.put("contact_number", contactNumber);
values.put("duration", duration);
values.put("date", dateFormat.format(date));
values.put("current_time", currTime);
values.put("cont", 1);
values.put("type", callType);
if (!db.isOpen()) {
db = getApplicationContext()
.openOrCreateDatabase(
"/data/data/com.myapp.app/databases/my_database.db",
SQLiteDatabase.OPEN_READWRITE, null);
}
db.insert(DataHandlerDB.TABLE_NAME_2, null, values);
cursor.close();
}
}
public void registerContentObservers() {
this.getApplicationContext()
.getContentResolver()
.registerContentObserver(
安卓.provider.CallLog.Calls.CONTENT_URI, true,
new MyApplicationContentObserver(handler));
}
}
共 (0) 个答案