Android:SQLite数据绑定ListView

public void showDbUpdata(){
        mContext = MainActivity.this;
        myDBHelper = new DbOpenHelper(mContext, "note.db", null, 1);

        TextView note_main_content = (TextView) findViewById(R.id.content_main_textView_1);

        mydb = myDBHelper.getWritableDatabase();
        mydbcontent = new StringBuilder();

        Cursor cursor = mydb.query("note", null, null, null, null, null, null);
        //int columnsSize = cursor.getColumnCount();获取长度
        List<Map<String, Object>> listitem = new ArrayList<Map<String, Object>>();
        if (cursor.moveToFirst()) {
            do {

                int noteid = cursor.getInt(cursor.getColumnIndex("noteid"));
                String title = cursor.getString(cursor.getColumnIndex("title"));
                String fenlei = cursor.getString(cursor.getColumnIndex("fenlei"));
                String date = cursor.getString(cursor.getColumnIndex("date"));
                //mydbcontent.append( noteid + ":" + title+":" + fenlei+":" + date + "\n");

                Map<String, Object> showitem = new HashMap<String, Object>();
                showitem.put("icon", fenbie_icon_list[1]);
                showitem.put("title", title);
                showitem.put("fenlei", fenlei);
                showitem.put("date", date);
                showitem.put("number", 1);
                listitem.add(showitem);
            } while (cursor.moveToNext());
        }
        cursor.close();
        //创建一个simpleAdapter
        SimpleAdapter myAdapter = new SimpleAdapter(getApplicationContext(), listitem, R.layout.main_list_item, new String[]{"icon","title", "date","number"}, new int[]{R.id.imageView_note_icon,R.id.textView_title, R.id.textView_date,R.id.textView_number});
        ListView listView = (ListView) findViewById(R.id.main_note_list);
        listView.setAdapter(myAdapter);

       // note_main_content.setText(mydbcontent);
    }
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

AiFool

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付:¥1
获取中
扫码支付

您的余额不足,请更换扫码支付或充值

打赏作者

实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值