Android应用之个人应用软件开发(3)【SQLite数据库及理财功能实现(13)

        }
        else{
            jrzkx_0.setText("今日未记账");
            jrzkx_01.setText("");
            jrzkx_02.setText("");
            jrzkx_03.setText("");
        }
        c2.close();

        if(yesterday>0)
        {
            Cursor c3 = db.query( PublicDataCost.Tb_Name_1, AllFeild , "DateTimes='" + laststrday + "'" , null, null, null, null);
            c3.moveToFirst();
            if(c3.getCount()>0)
            {
                intlastspend = Integer.parseInt(c3.getString(1))+Integer.parseInt(c3.getString(2))+Integer.parseInt(c3.getString(3))+Integer.parseInt(c3.getString(4))+Integer.parseInt(c3.getString(5));
                Zrzkx_01.setText("早:" + c3.getString(1) + " 中:"+ c3.getString(2)+" 晚:"+c3.getString(3));
                Zrzkx_02.setText("购置:"+ c3.getString(4)+"  日常:"+c3.getString(5));
                Zrzkx_03.setText("昨日总消费金额："+ lastspend);
            }
            else{
                Zrzkx_0.setText("昨日未记账");
                Zrzkx_01.setText("");
                Zrzkx_02.setText("");
                Zrzkx_03.setText("");
            }
            c3.close();
        }
        else