android listview 调用sqlsite数据库显示数据

本文介绍了一款病历笔记应用的设计与实现过程,详细阐述了如何使用ListView展示病患记录,通过点击事件获取SQLite数据库中的具体条目ID,并实现了记录的查看与删除功能。此外,还提供了创建新记录的选项。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

package com.b509.activity.patient;

import java.util.ArrayList;
import java.util.List;
import com.b509.tools.CornerListView;
import com.b509.R;
import com.b509.activity.patient.mydoctors.service.OtherPersonService;
import com.b509.activity.patient.mydoctors.service.Person;

import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.os.Bundle;
import android.view.Gravity;
import android.view.KeyEvent;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.BaseAdapter;
import android.widget.LinearLayout;
import android.widget.TextView;

public class IllnessNoteActivity extends Activity  {
	CornerListView note;
	List<Person> persons;
	List<String> illness_list;
	List<String> illness_time;
	List<Integer> illness_id;
	private OnItemClickListener itemClickListener;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		// TODO Auto-generated method stub
		super.onCreate(savedInstanceState);
		setContentView(R.layout.illnessnote);
		illness_list = new ArrayList<String>();
		illness_time = new ArrayList<String>();
		illness_id = new ArrayList<Integer>();
		note = (CornerListView) findViewById(R.id.lv_note);
		persons = updatalist();
		System.out.println(persons.size() + "??????????????????????");
		for (int i = 0; i < persons.size(); i++) {
			String time = persons.get(i).getTime();
			System.out.println(time);
			String illness = persons.get(i).getIllness();
			System.out.println(illness);
			Integer id = persons.get(i).getId();
			System.out.println(id);
			illness_list.add(illness);
			illness_time.add(time);
			illness_id.add(id);
		}

		initListView();

	}
	@Override
	public boolean onCreateOptionsMenu(Menu menu) {
		// TODO Auto-generated method stub
		
		  menu.add(0, 1, 1, "新建记录");    
		 
		return super.onCreateOptionsMenu(menu);
	}
	
	
	
	@Override
	public boolean onOptionsItemSelected(MenuItem item) {
		// TODO Auto-generated method stub
		Intent intent = new Intent();
		Bundle bubdle = new Bundle();
		bubdle.putInt("flag", 1);
		intent.putExtras(bubdle);
		intent.setClass(IllnessNoteActivity.this, EditNoteActivity.class);
		startActivity(intent);
		
		return super.onOptionsItemSelected(item);
		
		
		
	}
	private void initListView() {
		itemClickListener = new OnItemClickListener() {
			public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
					long arg3) {
				
				System.out.println("-----------------------");
				final int a = arg2;
				AlertDialog.Builder builder = new AlertDialog.Builder(
						IllnessNoteActivity.this);
				builder.setTitle("选项");
				final String[] messages = { "查看", "删除", };
				builder.setItems(messages,
						new DialogInterface.OnClickListener() {

							public void onClick(DialogInterface dialog,
									int which) {
								// TODO Auto-generated method stub

								switch (which) {

								case 0:

									Intent intent = new Intent();
									int item_all = illness_list.size();
									Bundle bubdle = new Bundle();
									bubdle.putInt("all_nub", item_all);
									bubdle.putInt("item_", a);
									bubdle.putInt("flag", 2);
									intent.putExtras(bubdle);

									intent.setClass(IllnessNoteActivity.this,
											EditNoteActivity.class);
									startActivity(intent);

									break;
								case 1:

									int item_all2 = illness_list.size();
									int id = item_all2 - a;

									OtherPersonService personService = new OtherPersonService(
											IllnessNoteActivity.this);
									personService.delete(id);
									illness_list.remove(a);
									illness_time.remove(a);

									// 重新加载listView
									BaseAdapter ba = new BaseAdapter() {
										public int getCount() {
											return illness_list.size();

										}

										public Object getItem(int position) {
											return null;
										}

										public long getItemId(int position) {
											return 0;
										}

										public View getView(int position,
												View convertView,
												ViewGroup parent) {
											LinearLayout ll = new LinearLayout(
													IllnessNoteActivity.this);
											ll.setOrientation(LinearLayout.HORIZONTAL);
											ll.setPadding(5, 5, 5, 5);

											TextView tv = new TextView(
													IllnessNoteActivity.this);

											tv.setText(illness_list
													.get(position));
											tv.setTextSize(24);
											tv.setPadding(5, 5, 5, 5);
											tv.setGravity(Gravity.LEFT);
											ll.addView(tv);

											TextView tv2 = new TextView(
													IllnessNoteActivity.this);
											// tv.setText(getResources().getText(data[position]));

											tv2.setText(illness_time
													.get(position));
											tv2.setTextSize(24);
											tv2.setPadding(5, 5, 5, 5);
											tv2.setGravity(Gravity.RIGHT);
											ll.addView(tv2);
											return ll;
										}

									};
									note.removeAllViewsInLayout();
									ba.notifyDataSetChanged();
									note.setAdapter(ba);
									note.setOnItemClickListener(itemClickListener);

									break;

								}

							}
						});
				builder.show();
				

			}
		};
		BaseAdapter ba = new BaseAdapter() {
			public int getCount() {
				return illness_list.size();
			}

			public Object getItem(int position) {
				return null;
			}

			public long getItemId(int position) {
				return 0;
			}

			public View getView(int position, View convertView, ViewGroup parent) {
				LinearLayout ll = new LinearLayout(IllnessNoteActivity.this);
				ll.setOrientation(LinearLayout.HORIZONTAL);
				ll.setPadding(5, 5, 5, 5);

				TextView tv = new TextView(IllnessNoteActivity.this);

				tv.setText(illness_list.get(position));
				tv.setTextSize(24);
				tv.setPadding(5, 5, 5, 5);
				tv.setGravity(Gravity.LEFT);
				ll.addView(tv);

				TextView tv2 = new TextView(IllnessNoteActivity.this);

				tv2.setText(illness_time.get(position));
				tv2.setTextSize(24);
				tv2.setPadding(5, 5, 5, 5);
				tv2.setGravity(Gravity.RIGHT);
				ll.addView(tv2);
				return ll;
			}

		};
		note.setAdapter(ba);
		note.setOnItemClickListener(itemClickListener);
	}

	public List<Person> updatalist() {
		OtherPersonService personService = new OtherPersonService(
				IllnessNoteActivity.this);

		List<Person> lists = personService.getScrollData(0, 1);
		System.out.println(lists + "??????????????????????????");
		return lists;

	}

	public boolean onKeyDown(int keycode, KeyEvent event) {
		if (keycode == KeyEvent.KEYCODE_BACK) {

			this.finish();
			return true;
		}
		return super.onKeyDown(keycode, event);

	}
}

person 是操作sqllite类 令一篇文章会贴代码

通过点击listview相应sqllite中的相应数据,关键是怎么得到相应的id    通过点击事件获得sqllite的id   这一步非常重要!

因为点击onclick中有一个args2参数  这个参数是从零开始依次向下排   因为大多数都是最新的在第一个,以此类推...

可以得到arg2和id 的转化关系  arg2+id=数据总数 ,把arg2和数据总数传到另一个activity  就可以计算出id 就可以取出相应的

数据!这一步非常重要!

转载于:https://my.oschina.net/sunglasscat/blog/336550

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值