Android ListView 数据绑定

第一步：写一个SqliteDBHelper类

package com.example.gzznproject;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

public class SqliteDBHelper extends SQLiteOpenHelper{
    public static final String  COLUMN_ID ="ID";
    public static final String  COLUMN_ConstrName ="ConstrName";
    public static final String  COLUMN_Enginer ="Enginer";
    public static final String  COLUMN_DepartID ="DepartID";
    public static final String  COLUMN_EnginerName ="EnginerName";
    public static final String  COLUMN_EnginerAddress ="EnginerAddress";
    public static final String  COLUMN_WorkContent ="WorkContent";
    public static final String  COLUMN_WorkRemark ="WorkRemark";
    public static final String  COLUMN_TodayPlan ="TodayPlan";
    public static final String  COLUMN_TorrowPlan ="TorrowPlan";
    public static final String  COLUMN_Remark ="Remark";
    public static final String  COLUMN_WorkTime ="WorkTime";
    public static final String  COLUMN_DeletionStateCode ="DeletionStateCode";
    public static final String  COLUMN_Enabled ="Enabled";
    public static final String  COLUMN_SortCode ="SortCode";
    public static final String  COLUMN_Description ="Description";
    public static final String  COLUMN_CreateOn ="CreateOn";
    public static final String  COLUMN_CreateUserId ="CreateUserId";
    public static final String  COLUMN_CreateBy ="CreateBy";
    public static final String  COLUMN_ModifiedOn ="ModifiedOn";
    public static final String  COLUMN_ModifiedUserId ="ModifiedUserId";
    public static final String  COLUMN_ModifiedBy ="ModifiedBy";
    public static final String  COLUMN_Crsign ="Crsign";
    public static final String  COLUMN_Telphone ="Telphone";
    public static final String  COLUMN_Departname ="Departname";
    public static final String  COLUMN_Itemid ="Itemid";
    public static final String  COLUMN_Itemname ="Itemname";
    public static final String     DATABASE_NAME = "TestDB.db";
    public static final String     USERS_TABLE = "myLog";
    
    public static final String  ADMIN_USERID="Id";
    public static final String  ADMIN_USERNAME="userName";
    public static final String  ADMIN_USERPWD="userPwd";
    public static final String  ADMIN_USERADDRESS="address";
    
    public static final String     TABLE_NAME="CREATE TABLE "+ USERS_TABLE +"("+ COLUMN_ID + " INTEGER PRIMARY KEY AUTOINCREMENT, " 
    +COLUMN_ConstrName+" text, "+COLUMN_Enginer+" text, "+COLUMN_DepartID+" text,"+COLUMN_EnginerName+" text,"+COLUMN_EnginerAddress+" text, "
    +COLUMN_WorkContent+" text, "+COLUMN_WorkRemark+" text, "+COLUMN_TodayPlan+" text,"+COLUMN_TorrowPlan+" text, "+COLUMN_Remark+" text,"
    +COLUMN_WorkTime+" text, "+COLUMN_DeletionStateCode+" text, "+COLUMN_Enabled+" text,"+COLUMN_SortCode+" text,"+COLUMN_Description+" text, "
    +COLUMN_CreateOn+" text,"+COLUMN_CreateUserId+" text, "+COLUMN_CreateBy+" text, "+COLUMN_ModifiedOn+" text, "+COLUMN_ModifiedUserId+" text, "
    +COLUMN_ModifiedBy+" text, "+COLUMN_Crsign+" text, "+COLUMN_Telphone+" text, "+COLUMN_Departname+" text, "+COLUMN_Itemid+" text, "
    +COLUMN_Itemname+" text);";
 
    private SQLiteDatabase  db;  
    public SqliteDBHelper(Context c) {
        super(c, DATABASE_NAME,null,1);
        // TODO Auto-generated constructor stub
    }    
    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub    
        this.db=db;
        db.execSQL(TABLE_NAME);        
    }
    public long Insert(ContentValues values)
    {
        SQLiteDatabase db=this.getWritableDatabase();
        long count= db.insert(USERS_TABLE, null, values);
        if(count==-1)
        {
            count=-1;
        }
        else
        {
            count=1;
        }
        db.close();
        return count;        
    }
    
    public Cursor query()
    {
        SQLiteDatabase db=this.getWritableDatabase();
        Cursor c=db.query(USERS_TABLE, null, null, null, null, null, null);
        return c;
    }
    public void Delete(int id)
    {    
        if(db==null)        
            db=this.getWritableDatabase();        
        db.execSQL("delete from myLog where ID="+id);
        db.close();
    }
    
    public void update(int id,ContentValues values) 
    { 
        SQLiteDatabase db = this.getWritableDatabase(); 
        String where = COLUMN_ID + " = ?"; 
        String[] whereValue = { Integer.toString(id) }; 
        db.update(USERS_TABLE, values, where, whereValue); 
    } 
        
    public void Close()
    {
        if(db!=null)
        {
            db.close();
        }
    }
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub    
        
    }
}

第二步：列表前台页面展示

<?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="fill_parent"
    android:orientation="vertical" >       
    <LinearLayout  
     android:orientation="horizontal"  
     android:layout_width="fill_parent"  
     android:layout_height="wrap_content"> 

     <TextView  
      android:layout_width="150dp"  
      android:textSize="15sp"
      android:layout_height="30dp" 
      android:gravity="center_vertical|left"
      android:text="@string/txt_Name"/>  
     <TextView  
      android:layout_width="160dp"
      android:textSize="15sp"  
      android:gravity="center_vertical|right"
      android:layout_height="30dp" 
      android:text="@string/txt_wokTime"/>  
     </LinearLayout> 
     <ListView    
       android:layout_width="fill_parent"  
       android:layout_height="fill_parent"
       android:id="@+id/listView"/> 
</LinearLayout>

注意：还需要建一个item.xml文件（item文件没有后台代码）

<?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="fill_parent"
    android:orientation="horizontal" >
    <TextView  
    android:layout_width="150dp"  
    android:gravity="center_vertical|left"
    android:textSize="15sp"
    android:layout_height="30dp"  
    android:id="@+id/txt_ConstrName"  
   />  
   <TextView  
    android:layout_width="160dp"  
    android:gravity="center_vertical|right"
    android:textSize="15sp"
    android:layout_height="30dp"  
    android:id="@+id/txt_WorkTime"  
   /> 
  
</LinearLayout>

第三步：展示loglist后台代码

package com.example.gzznproject;

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

import org.ksoap2.SoapEnvelope;
import org.ksoap2.serialization.SoapObject;
import org.ksoap2.serialization.SoapSerializationEnvelope;
import org.ksoap2.transport.AndroidHttpTransport;

import android.app.Activity;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.net.ConnectivityManager;
import android.os.Bundle;
import android.view.ContextMenu;
import android.view.ContextMenu.ContextMenuInfo;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnCreateContextMenuListener;
import android.widget.AdapterView.AdapterContextMenuInfo;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.Toast;

public class LogListActivity extends Activity {
    SimpleAdapter adapter;
    SqliteDBHelper helper;
    public ListView listview;
    public HashMap<String, Object> hashmap;
    public static ArrayList<HashMap<String, Object>> arrayList;
    public static int enegerid;
    public static int flagid;
    public static int userid;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.loglist);
        _getdataview();
        listview.setOnCreateContextMenuListener(listener);
    }

    // listview数据绑定
    public void _getdataview() {
        listview = (ListView) findViewById(R.id.listView);
        adapter = new SimpleAdapter(LogListActivity.this, getdata(),
                R.layout.item, new String[] { "ConstrName", "WorkTime" },
                new int[] { R.id.txt_ConstrName, R.id.txt_WorkTime });
        listview.setAdapter(adapter);
    }

    // 长按菜单
    OnCreateContextMenuListener listener = new OnCreateContextMenuListener() {
        @Override
        public void onCreateContextMenu(ContextMenu menu, View v,
                ContextMenuInfo menuInfo) {
            menu.setHeaderTitle("操作提示");
            menu.add(0, 2, 0, "文件上传");
            menu.add(0, 0, 0, "编辑");
            menu.add(0, 1, 0, "删除");
        }
    };

    @Override
    public boolean onContextItemSelected(MenuItem item) {
        final AdapterContextMenuInfo info = (AdapterContextMenuInfo) item
                .getMenuInfo();
        hashmap = arrayList.get((int) info.id);
        Object obj = hashmap.get("ID");
        int id = Integer.parseInt(String.valueOf(obj));
        if (item.getItemId() == 1) {
            if (id == -1) {
                Toast.makeText(getApplicationContext(), "没有选中数据！",
                        Toast.LENGTH_SHORT).show();
            } else {
                helper.Delete(id);
                _getdataview();
                Toast.makeText(getApplicationContext(), "数据删除成功！",
                        Toast.LENGTH_SHORT).show();
            }
        } else if (item.getItemId() == 0) {
            if (id == -1) {
                Toast.makeText(getApplicationContext(), "没有选中数据！",
                        Toast.LENGTH_SHORT).show();
            } else {
                LogManagerActivity.hashmap = hashmap;
                Intent intent = new Intent();
                intent.setClass(LogListActivity.this, LogManagerActivity.class);
                startActivity(intent);
            }
        } else if (item.getItemId() == 2) {
            String url = "http://117.34.91.186:8347/WebServices/InsertLog.asmx";
            String nameSpace = "http://tempuri.org/";
            String SOAP_ACTION = "http://tempuri.org/InserttionLog";
            String method = "InserttionLog";
            SoapObject request = new SoapObject(nameSpace, method);
            request.addProperty("Id", userid);
            request.addProperty("ConstrName", hashmap.get("ConstrName")
                    .toString() == null ? "" : hashmap.get("ConstrName")
                    .toString());
            request.addProperty("Enginer",
                    hashmap.get("Enginer").toString() == null ? "" : hashmap
                            .get("Enginer").toString());
            request.addProperty(
                    "DepartID",
                    hashmap.get("ID").toString() == null ? "" : hashmap.get(
                            "ID").toString());
            request.addProperty("EngineName", hashmap.get("EnginerName")
                    .toString() == null ? "" : hashmap.get("EnginerName")
                    .toString());
            request.addProperty("EnginerAddress", hashmap.get("EnginerAddress")
                    .toString() == null ? "" : hashmap.get("EnginerAddress")
                    .toString());
            request.addProperty("WorkContent", hashmap.get("WorkContent")
                    .toString() == null ? "" : hashmap.get("WorkContent")
                    .toString());
            request.addProperty("WorkRemark", hashmap.get("WorkRemark")
                    .toString() == null ? "" : hashmap.get("WorkRemark")
                    .toString());
            request.addProperty("TodayPlan", hashmap.get("TodayPlan")
                    .toString() == null ? "" : hashmap.get("TodayPlan")
                    .toString());
            request.addProperty("TorrowPlan", hashmap.get("TorrowPlan")
                    .toString() == null ? "" : hashmap.get("TorrowPlan")
                    .toString());
            request.addProperty("Remark",
                    hashmap.get("Remark").toString() == null ? "" : hashmap
                            .get("Remark").toString());
            request.addProperty("WorkTime",
                    hashmap.get("WorkTime").toString() == null ? "" : hashmap
                            .get("WorkTime").toString());

            SoapSerializationEnvelope envelope = new SoapSerializationEnvelope(

                    SoapEnvelope.VER11);
            envelope.bodyOut = request;
            envelope.dotNet = true;
            AndroidHttpTransport transport = new AndroidHttpTransport(url);
            try {
                if (isOpenNetwork()) {
                    transport.call(SOAP_ACTION, envelope);
                    if (envelope.getResponse() != null) {
                        Object object = envelope.getResponse();
                        boolean result = Boolean
                                .parseBoolean(object.toString());
                        if (result == true) {
                            Toast.makeText(getApplicationContext(), "上传成功！",
                                    Toast.LENGTH_SHORT).show();
                        } else {
                            Toast.makeText(getApplicationContext(), "上传失败！",
                                    Toast.LENGTH_SHORT).show();
                        }
                    }
                } else {
                    Toast.makeText(getApplicationContext(), "当前网络不可用不能上传文件！",
                            Toast.LENGTH_SHORT).show();
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        } else {
            return false;
        }
        return super.onContextItemSelected(item);
    }

    // 绑定listview的数据源
    public ArrayList<HashMap<String, Object>> getdata() {
        helper = new SqliteDBHelper(this);
        SQLiteDatabase mdb = helper.getReadableDatabase();
        Cursor c = mdb.rawQuery("select * from myLog", null);
        arrayList = new ArrayList<HashMap<String, Object>>();
        while (c.moveToNext()) {
            hashmap = new HashMap<String, Object>();
            hashmap.put("ID", c.getString(0));
            hashmap.put("ConstrName", c.getString(1));
            hashmap.put("Enginer", c.getString(2));
            hashmap.put("DepartID", c.getString(3));
            hashmap.put("EnginerName", c.getString(4));
            hashmap.put("EnginerAddress", c.getString(5));
            hashmap.put("WorkContent", c.getString(6));
            hashmap.put("WorkRemark", c.getString(7));
            hashmap.put("TodayPlan", c.getString(8));
            hashmap.put("TorrowPlan", c.getString(9));
            hashmap.put("Remark", c.getString(10));
            hashmap.put("WorkTime", c.getString(11));
            hashmap.put("DeletionStateCode", c.getString(12));
            hashmap.put("Enabled", c.getString(13));
            hashmap.put("SortCode", c.getString(14));
            hashmap.put("Description", c.getString(15));
            hashmap.put("CreateOn", c.getString(16));
            hashmap.put("CreateUserId", c.getString(17));
            hashmap.put("CreateBy", c.getString(18));
            hashmap.put("ModifiedOn", c.getString(19));
            hashmap.put("ModifiedUserId", c.getString(20));
            hashmap.put("ModifiedBy", c.getString(21));
            hashmap.put("Crsign", c.getString(22));
            hashmap.put("Telphone", c.getString(23));
            hashmap.put("Departname", c.getString(24));
            hashmap.put("Itemid", c.getString(25));
            hashmap.put("Itemname", c.getString(26));
            arrayList.add(hashmap);
        }
        return arrayList;
    }

    @Override
    public boolean onCreateOptionsMenu(Menu menu) {
        // getMenuInflater().inflate(R.menu.main, menu);
        menu.add(0, 1, 1, "添加数据");
        menu.add(0, 2, 1, "树形结构");
        return true;
    }

    @Override
    public boolean onOptionsItemSelected(MenuItem item) {
        if (item.getItemId() == 1) {
            Intent itent = new Intent();
            itent.setClass(LogListActivity.this, LogManagerActivity.class);
            startActivity(itent);
        } else {
            Intent itent = new Intent();
            itent.setClass(LogListActivity.this, TreeStructure.class);
            startActivity(itent);
        }
        return false;
    }

    // 监听网络状态
    private boolean isOpenNetwork() {
        ConnectivityManager connManager = (ConnectivityManager) getSystemService(Context.CONNECTIVITY_SERVICE);
        if (connManager.getActiveNetworkInfo() != null) {
            return connManager.getActiveNetworkInfo().isAvailable();
        }
        return false;
    }
}

这里还要注意需要在libs文件夹中导入：ksoap2-android-assembly-2.3-jar-with-dependencies.jar 包

还要在AndroidManifest.xml中加入这些权限：

<uses-permission android:name="android.permission.INTERNET"/>
<uses-permission android:name="android.permission.ACCESS_NETWORK_STATE"/>
<uses-permission android:name="android.permission.INTERNET"/>

 大功告成，Listview数据绑定成功！