android 界面传递数据库,Android_sqlite数据库界面展示_141109

功能：

1)数据库的增删改查

2)可以显示在listView_item上

文件介绍：

// SampleActivity.java  增删改查操作，对应activity_mian布局文件

// activity_mian.xml 布局文件

代码：

// SampleActivity.java

package com.yline.sqlite.Sample;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import android.app.Activity;

import android.os.Bundle;

import android.view.View;

import android.view.View.OnClickListener;

import android.widget.Button;

import android.widget.EditText;

import android.widget.ListView;

import android.widget.SimpleAdapter;

import com.yline.sqlite.R;

import com.yline.sqlite.database.DataBaseOperateNoTool;

import com.yline.sqlite.database.PersonDomain;

import com.yline.sqlite.database.SQLiteOpenHelperYline;

public class SampleACtivity extends Activity implements OnClickListener{

private Button btn_add;

private Button btn_delete;

private Button btn_find;

private Button btn_update;

private EditText et_name;

private EditText et_number;

private String name;

private String number;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

CreateDB();

initView();

}

private void initView(){

btn_add = (Button) findViewById(R.id.btn_add);

btn_delete = (Button) findViewById(R.id.btn_delete);

btn_find = (Button) findViewById(R.id.btn_find);

btn_update = (Button) findViewById(R.id.btn_update);

et_name = (EditText) findViewById(R.id.et_name);

et_number = (EditText) findViewById(R.id.et_number);

btn_add.setOnClickListener(this);

btn_delete.setOnClickListener(this);

btn_find.setOnClickListener(this);

btn_update.setOnClickListener(this);

}

@Override

public void onClick(View v) {

name = et_name.getText().toString().trim();

number = et_number.getText().toString().trim();

switch (v.getId()) {

case R.id.btn_add:

add(name,number);

break;

case R.id.btn_delete:

delete(name);

break;

case R.id.btn_update:

update(1,name,number);

break;

case R.id.btn_find:

find(3);

break;

}

show();

}

/**

* 创建一个数据库

*/

private void CreateDB(){

SQLiteOpenHelperYline helper = new SQLiteOpenHelperYline(this);

helper.getWritableDatabase();

}

/**

* 在表中,添加 一条信息

* @param name 姓名

* @param number 号码

*/

private void add(String name,String number){

DataBaseOperateNoTool ylineTable = new DataBaseOperateNoTool(this);

ylineTable.addDBItem(name,number);

}

private void show(){

ListView lv_show = (ListView) findViewById(R.id.lv_show);

DataBaseOperateNoTool ylineTable = new DataBaseOperateNoTool(this);

List persons = ylineTable.findAll();

List> data = new ArrayList>();

for(PersonDomain m : persons){

HashMap item = new HashMap();

item.put("id", m.getId()+" ");

item.put("name", m.getName()+" ");

item.put("number", m.getNumber()+" ");

data.add(item);

}

String[] from = new String[]{"id","name","number"};

int[] to = new int[]{R.id.tv_id,R.id.tv_name,R.id.tv_number};

SimpleAdapter adapter = new SimpleAdapter(this, data, R.layout.listview_item, from, to);

lv_show.setAdapter(adapter);

}

/**

* 删除 姓名为name的 信息

* @param name

*/

private void delete(String name){

DataBaseOperateNoTool ylineTable = new DataBaseOperateNoTool(this);

ylineTable.deleteDBItem(name);

}

/**

* 更新数据

* @param id 待更新的编号

* @param name 新的姓名

* @param number 新的号码

*/

private void update(int id,String name,String number){

DataBaseOperateNoTool ylineTable = new DataBaseOperateNoTool(this);

ylineTable.updateDBItem(id,name,number);

}

/**

* 查询信息

* @param id 待查询信息的编号

*/

private void find(int id){

DataBaseOperateNoTool ylineTable = new DataBaseOperateNoTool(this);

ylineTable.findDBItem(id);

}

/**

* 遍历列表

*/

private void findAll(){

DataBaseOperateNoTool ylineTable = new DataBaseOperateNoTool(this);

List persons = ylineTable.findAll();

for(PersonDomain m : persons){

System.out.println(m);

}

}

}

// activity_mian.xml

android:layout_width="fill_parent"

android:layout_height="fill_parent" >

android:id="@+id/et_name"

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:layout_alignParentLeft="true"

android:layout_alignParentTop="true"

android:hint="id"

android:singleLine="true" >

android:id="@+id/et_number"

android:layout_width="fill_parent"

android:layout_height="wrap_content"

android:layout_alignParentLeft="true"

android:layout_below="@+id/et_name"

android:hint="number"

android:singleLine="true" />

android:id="@+id/btn_add"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignParentLeft="true"

android:layout_below="@+id/et_number"

android:text="add" />

android:id="@+id/btn_delete"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignBaseline="@+id/btn_add"

android:layout_alignBottom="@+id/btn_add"

android:layout_toRightOf="@+id/btn_add"

android:text="delete" />

android:id="@+id/btn_update"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignBaseline="@+id/btn_delete"

android:layout_alignBottom="@+id/btn_delete"

android:layout_toRightOf="@+id/btn_delete"

android:text="updata" />

android:id="@+id/btn_find"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_alignBaseline="@+id/btn_update"

android:layout_alignBottom="@+id/btn_update"

android:layout_toRightOf="@+id/btn_update"

android:text="find" />

android:id="@+id/lv_show"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_alignParentLeft="true"

android:layout_below="@+id/btn_add" >

运行图：

可运行代码下载链接：