android listview和适配器adapter的使用_android studio中listview和adapter的使用-CSDN博客

本文链接：https://blog.csdn.net/hello2me/article/details/7946417

该案例是字db http://blog.csdn.net/hxy01245120/article/details/7941237 的基础上完成的

修改personservice业务类增加字段amount 和添加一个分页查询返回类型为Cursor

修改save方法:

	public void savePerson(Person person) {
		SQLiteDatabase db = dbOpenHelp.getWritableDatabase();
		dbOpenHelp.getReadableDatabase();
		db.execSQL("insert into person(name,amount) values(?,?)", new Object[] { person.getName(), person.getAmount() });
	}

修改分页查询的方法:

public List<Person> findPersonForPage(int offset, int maxResult) {
		List<Person> persons = new ArrayList<Person>();
		SQLiteDatabase db = dbOpenHelp.getReadableDatabase();
		Cursor cursor = db.rawQuery("select * from person limit?,?", new String[] { String.valueOf(offset), String.valueOf(maxResult) });
		while (cursor.moveToNext()) {
			Person person = new Person();
			person.setId(cursor.getInt(cursor.getColumnIndex("id")));
			person.setName(cursor.getString(cursor.getColumnIndex("name")));
			person.setAmount(cursor.getInt(cursor.getColumnIndex("amount")));
			persons.add(person);
		}
		cursor.close();
		return persons;

添加发布会cursor对象的分页查询方法:

public Cursor findCursorPersonForPage(int offset, int maxResult) {
		List<Person> persons = new ArrayList<Person>();
		SQLiteDatabase db = dbOpenHelp.getReadableDatabase();
		return db.rawQuery("select id as _id,name,amount from person limit?,?", new String[] { String.valueOf(offset), String.valueOf(maxResult) });
	}

主布局文件:

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="fill_parent"
    android:orientation="vertical" >
<!-- 设置标题 -->
    <LinearLayout
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal" >

        <TextView
            android:id="@+id/name"
            android:layout_width="100dip"
            android:layout_height="wrap_content"
            android:gravity="center"
            android:text="姓名"
            android:textSize="25dip" />

        <TextView
            android:id="@+id/id"
            android:layout_width="100dip"
            android:layout_height="wrap_content"
            android:gravity="center"
            android:text="編號"
            android:textSize="25dip" />

        <TextView
            android:id="@+id/amount"
            android:layout_width="fill_parent"
            android:layout_height="wrap_content"
            android:gravity="center"
            android:text="金額"
            android:textSize="25dip" />
    </LinearLayout>

    <ListView
        android:id="@+id/listView"
        android:layout_width="fill_parent"
        android:layout_height="fill_parent" >
    </ListView>

</LinearLayout>

控制显示的布局文件:

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:orientation="horizontal" >

    <TextView
        android:id="@+id/id"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:gravity="center"
        android:textSize="20dip" />

    <TextView
        android:id="@+id/name"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:gravity="center"
        android:textSize="20dip" />

    <TextView
        android:id="@+id/amount"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:gravity="center"
        android:textSize="20dip" />

</LinearLayout>

1,使用sampleadapter

package com.itcast.db;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import com.itcast.db.R;
import com.itcast.model.Person;
import com.itcast.service.PersonService;

import android.os.Bundle;
import android.app.Activity;
import android.database.Cursor;
import android.support.v4.widget.SimpleCursorAdapter;
import android.view.Menu;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.Toast;

public class MainActivity extends Activity {
	private PersonService personService;

	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		personService = new PersonService(this);
		ListView listView = (ListView) findViewById(R.id.listView);

		List<Person> persons = personService.findPersonForPage(0, 5);
		List<HashMap<String, Object>> data = new ArrayList<HashMap<String, Object>>();
		for (Person person : persons) {
			HashMap<String, Object> map = new HashMap<String, Object>();
			map.put("itemId", person.getId());
			map.put("itemName", person.getName());
			map.put("itemAmount", person.getAmount());
			data.add(map);
		}
		/**
		 * 1:context对象<br>
		 * 2:填充的数据<br>
		 * 3:指定控制显示的xml文件<br>
		 * 4:与上面数据来源中的hashmap中的key相对应,里面的值要跟key值一样<br>
		 * 5:在控制显示xml中文件中对应控件的id值
		 */
		SimpleAdapter adapter = new SimpleAdapter(this, data, R.layout.itemview, new String[] { "itemId", "itemName", "itemAmount" }, new int[] { R.id.id, R.id.name, R.id.amount });
		listView.setAdapter(adapter);
		listView.setOnItemClickListener(new OnItemClickListener() {

			@Override
			public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
				ListView listView = (ListView) parent;
				HashMap<String, Object> map = (HashMap<String, Object>) listView.getItemAtPosition(position);
				Toast.makeText(MainActivity.this, String.valueOf(map.get("itemName")) + ":" + String.valueOf(map.get("itemAmount")), Toast.LENGTH_SHORT).show();
			}
		});
	}

	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		getMenuInflater().inflate(R.menu.activity_main, menu);
		return true;
	}
}

2,使用simplecursoradapter

package com.itcast.db;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;

import com.itcast.db.R;
import com.itcast.model.Person;
import com.itcast.service.PersonService;

import android.os.Bundle;
import android.app.Activity;
import android.database.Cursor;
import android.support.v4.widget.SimpleCursorAdapter;
import android.view.Menu;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.Toast;

public class MainActivity extends Activity {
	private PersonService personService;

	@Override
	public void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		personService = new PersonService(this);
		ListView listView = (ListView) findViewById(R.id.listView);
		Cursor cursor = personService.findCursorPersonForPage(0, 5);
		/**
		 * 1:当前activitiy对象<br>
		 * 2:控制显示的布局问价<br>
		 * 3:cursor数据源<br>
		 * 4:查找数据语句是的列明 因为返回的cursor 所以要用select语句的列名<br>
		 * 5:在控制显示xml中文件中对应控件的id值<br>
		 * 用SimpleCursorAdapter的时候 要保证表中有_id字段
		 * android内定表明的主键的列名必须是_id,所以在查询的时候可以把id字段起个别名<br>
		 * 如 select id as _id,name,amount from person limit?,?
		 */
		SimpleCursorAdapter cursorAdapter = new SimpleCursorAdapter(this, R.layout.itemview, cursor, new String[] { "_id", "name", "amount" }, new int[] { R.id.id, R.id.name, R.id.amount });
		listView.setAdapter(cursorAdapter);
		listView.setOnItemClickListener(new OnItemClickListener() {
			@Override
			public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
				ListView listView = (ListView) parent;
				Cursor cursor = (Cursor) listView.getItemAtPosition(position);
				Toast.makeText(MainActivity.this, String.valueOf(cursor.getString(cursor.getColumnIndex("name"))) + ":" + cursor.getInt(cursor.getColumnIndex("amount")), Toast.LENGTH_SHORT).show();
			}
		});
	}

	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		getMenuInflater().inflate(R.menu.activity_main, menu);
		return true;
	}
}

使用simplecursoradapter 是获取数据的sql中要有_id的列或者别名在new String的时候把_id替换掉原来的列名不然的话程序会报错