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;@Overrideprotected 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);}@Overridepublic 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<PersonDomain> persons = ylineTable.findAll();List<HashMap<String, Object>> data = new ArrayList<HashMap<String,Object>>();for(PersonDomain m : persons){HashMap<String, Object> item = new HashMap<String, Object>();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<PersonDomain> persons = ylineTable.findAll();for(PersonDomain m : persons){System.out.println(m);}}}

  // activity_mian.xml 

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"    android:layout_width="fill_parent"    android:layout_height="fill_parent" >    <EditText        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" >        <requestFocus />    </EditText>    <EditText        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" />    <Button        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" />    <Button        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" />    <Button        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" />    <Button        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" />    <ListView        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" >    </ListView></RelativeLayout>

运行图：

可运行代码下载链接：

http://pan.baidu.com/s/1i3kSJqP