@H_301_1@/**
@H_301_1@* *Title:selectAllPhone *Description:查询所有的Phone对象 *@return *@see
@H_301_1@* com.sms.ntlm.dao.PhoneDao#selectAllPhone()
@H_301_1@*/
@H_301_1@@SuppressLint("SimpleDateFormat")
@H_301_1@@SuppressWarnings("deprecation")
@H_301_1@@Override
@H_301_1@public List<Phone> selectAllPhone() {
@H_301_1@Cursor cursor=null;
@H_301_1@List<Phone> list=new ArrayList<Phone>();
@H_301_1@String sql="select * from "+PhonesqlConstant.TABLE_NAME+";";
@H_301_1@db=mOpenHelper.getWritableDatabase();
@H_301_1@if(mOpenHelper!=null && db.isOpen()){
@H_301_1@// cursor=db.query(PhonesqlConstant.TABLE_NAME,null,null);
@H_301_1@cursor=db.rawQuery(sql,null);
@H_301_1@}
if (cursor != null) {//原因就是这个地方出错了：我在这个地方加了个if (cursor != null && cursor.moveToFirst()) {
@H_301_1@while (cursor.moveToNext()) {
@H_301_1@Phone phone=new Phone();

@H_301_1@phone.setPhoneId(cursor.getInt(cursor.getColumnIndex(PhonesqlConstant.PHONE_ID)));
@H_301_1@phone.setPhoneNum(cursor.getString(cursor.getColumnIndex(PhonesqlConstant.PHONE_NUM)));
@H_301_1@phone.setPhoneDate(cursor.getString(cursor.getColumnIndex(PhonesqlConstant.PHONE_DATE)));

@H_301_1@list.add(phone);
@H_301_1@}
@H_301_1@}
@H_301_1@this.closeCursorDB(cursor);
@H_301_1@return list;

}

@H_301_1@

@H_301_1@控制台输出的结果是:05-15 03:12:44.017: I/System.out(12634): testselectAllPhone.size()..............0

@H_301_1@我在数据库中查询的结果是：

D:\zzz>sqlite3 PhoneMassage.db sqlite version 3.7.11 2012-03-20 11:35:50 Enter ".help" for instructions Enter sql statements terminated with a ";" sqlite> .table MyPhone Phone android_Metadata sqlite> select * from MyPhone ...> ; 1|1234|2015-05-15 sqlite> ^C