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

//将事件绑定到按钮
        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);
                c.moveToFirst();
                spinnerid = Integer.parseInt(c.getString(0));
                tv_Morning.setText(c.getString(1));
                tv_noon.setText(c.getString(2));
                tv_Night.setText(c.getString(3));
                tv_OtherSpend.setText(c.getString(4));
                tv_DailySpend.setText(c.getString(5));
                c.close();