编写一个从数据库里查询数据展示到listview上的案例
运行结果:点击find按钮,会将数据库中添加的数据显示在List View上
结果如下:
创建如图所示:
代码如下:
PersonAdapter
package cn.edu.bzu.datashow.adapter; import android.content.Context; import android.view.LayoutInflater; import android.view.View; import android.view.ViewGroup; import android.widget.ArrayAdapter; import android.widget.TextView; import java.util.List; import cn.edu.bzu.datashow.R; import cn.edu.bzu.datashow.entity.Person; public class PersonAdapter extends ArrayAdapter<Person> { private int resourceId; public PersonAdapter(Context context, int textViewResourceId, List<Person> objects) { super(context, textViewResourceId, objects); resourceId = textViewResourceId; } @Override public View getView(int position, View convertView, ViewGroup parent) { Person person= getItem(position); View view; ViewHolder viewHolder; if (convertView == null) { //任务 补充完整 view = LayoutInflater.from(getContext()).inflate(resourceId, null); viewHolder = new ViewHolder(); viewHolder.tvName = (TextView) view.findViewById(R.id.tvName); viewHolder.tvPhone = (TextView) view.findViewById(R.id.tvPhone); view.setTag(viewHolder); } else { view = convertView; viewHolder = (ViewHolder) view.getTag(); } viewHolder.tvName.setText(person.getName()); viewHolder.tvPhone.setText(person.getPhone()); return view; } class ViewHolder { TextView tvName; TextView tvPhone; } }
PersonDao:
package cn.edu.bzu.datashow.dao; import android.content.ContentValues; import