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

                  db.update(PublicDataCost.Tb_Name_1, cv, sqlwhere ,null);
                  db.close();
                  onCreate(savedInstanceState);
                  Toast.makeText( todayspend.this, "修改成功！", Toast.LENGTH_SHORT).show();
                 
              }
            }
        };
        //将事件绑定到按钮
        bt_addspend.setOnClickListener(sqlc.dbl_add);
        //绑定列表
        Cursor c = db.query( PublicDataCost.Tb_Name_1 , newString[] {PublicDataCost.Field_1_6}, null, null, null, null, null);
        c.moveToFirst();
        CharSequence[] cslist = newCharSequence[c.getCount()];
        for(inti=0;i<cslist.length;i++)
        {
            cslist[i]=c.getString(0);
            c.moveToNext();
        }
        c.close();
        Spinner sp = (Spinner)findViewById(R.id.spinner1);
        sp.setAdapter(newArrayAdapter<CharSequence>(this,android.R.layout.simple_dropdown_item_1line,cslist));
        sp.setSelection(cslist.length-1);
        //注册事件
        sp.setOnItemSelectedListener(newOnItemSelectedListener() {
            publicvoidonItemSelected(AdapterView<?> parent ,View view, intposition, longid){
                String todaydatetime = ((Spinner)parent).getSelectedItem().toString();
                Cursor c = db.query(PublicDataCost.Tb_Name_1, AllFeild, "DateTimes='" + todaydatetime + "'", null, PublicDataCost.Field_1_6, null, PublicDataCost.Field_1_6);