public void HeBin() {
Cursor cursor=null;
cursor = dbInstance.query(DB_TABLENAME, new String[] { "_id", "mobphone" },null, null, null, null, null);
while (cursor.moveToNext()) {
int id = cursor.getInt(cursor.getColumnIndex("_id"));
String mob = cursor.getString(cursor.getColumnIndex("mobphone"));
System.out.println("我是第一个" + mob);
Cursor cursor2 = dbInstance.query(DB_TABLENAME, new String[] { "_id", "mobphone" },"_id!=?",new String[]{id+""},null, null, null);
while(cursor2.moveToNext()) {
//System.out.println("我是第一个" + mob);
int id1 = cursor.getInt(cursor.getColumnIndex("_id"));
String mob1 = cursor.getString(cursor.getColumnIndex("mobphone"));
System.out.println("我是第二个" + mob1 + ":" + id1);
if (mob.equals(mob1)) {
delete(id1);
}
}
cursor2.close();
}
cursor.close();
}