使用SimpleCursorAdapter绑定显示listview

来源:互联网 发布:微网站系统源码 编辑:程序博客网 时间:2024/06/11 16:31
public class SettingsActivity extends AppCompatActivity {    private SimpleCursorAdapter adapter;    private ListView listView;    private Cursor cursor;    private String putUsername;    private String putUserauthority;    private String putTitle;    private int putUserid;    @Override    protected void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.activity_settings);        ActivityManagerApplication.addActivity(this);//将activity在List中进行登记        /*获取上页传来数据*/        Intent intent = getIntent();        putUsername = intent.getStringExtra("putUsername");        putUserauthority = intent.getStringExtra("putUserauthority");        putUserid = intent.getIntExtra("putUserid", 0);        putTitle = intent.getStringExtra("putTitle");        String Str_sql="select settingid as _id,texttitle from setting where parentid=1";        ChangeDatabase cdb=new ChangeDatabase(SettingsActivity.this);        cursor=cdb.SelectTable(Str_sql);        listView=(ListView) this.findViewById(R.id.settinglistview);        if (cursor.getCount()>0){            adapter = new SimpleCursorAdapter(this,R.layout.settinglistview,cursor,new String[]{"texttitle"},new int[]{R.id.setting_text_title});            listView.setAdapter(adapter);        }    }    protected void onDestroy() {        super.onDestroy();        cursor.close();  //我们在onCreate()中没有关闭游标,因为需要和ListView进行数据关联,关闭curosr,会导致List无数据,故在最后释放资源        //db.close(); //断开和数据库的连接,释放相关资源    }
 }

原创粉丝点击