如何用listview显示sqlite里的数据？

Question

下个SQLite Database Browser之类的，反正都是些很简单的小工具。你最好把你下载的例子贴出来，别人能给你纠正一下错误。

Answer 1

public class Firm_List extends ListActivity{

ListView listView;
firm_infoService firm_infoService;
OnItemClickListener listViewListener;
public void onCreat(Bundle savedInstanceState){
super.onCreate(savedInstanceState);
setContentView(R.layout.list_test);
listViewListener = new OnItemClickListener(){
public void onItemClick(AdapterView<?>parent, View view, int position, long id){
ListView listView = (ListView)parent;
//firm_info firm_info = (firm_info)listView.getItemAtPosition(position);
//Toast.makeText(getApplicationContext(), firm_info.toString(), Toast.LENGTH_LONG).show();

//Cursor cursor = (Cursor)listView.getItemAtPosition(position);
//int firm_id = cursor.getInt(cursor.getColumnIndex("_id"));
//Toast.makeText(getApplicationContext(), firm_id+"", Toast.LENGTH_LONG).show();

@SuppressWarnings("unchecked")
    Map<String,Object> map = (Map)listView.getItemAtPosition(position);
    String name = map.get("name").toString();
    String personid = map.get("personid").toString();
    Toast.makeText(getApplicationContext(), personid +"-"+ name, Toast.LENGTH_LONG).show();
}
};
listView = (ListView) this.findViewById(R.id.listView);
listView.setOnItemClickListener(listViewListener);
firm_infoService = new firm_infoService(this);
showList();

Button b1 = (Button) findViewById(R.id.button1);
b1.setOnClickListener(new Button.OnClickListener()
     {
     public void onClick(View v)
     {
     jumpToHome();
     }
     });
}

public void jumpToHome(){
Intent intent = new Intent();
     intent.setClass(Firm_List.this, PeActivity.class);
     startActivity(intent);
     Firm_List.this.finish();
}

private void showList(){
List<firm_info>firm_infos = firm_infoService.getScrollData(0,50);
List<HashMap<String,Object>>data = new ArrayList<HashMap<String,Object>>();
for(firm_info firm_info:firm_infos){
HashMap<String,Object>item = new HashMap<String,Object>();
item.put("firm_name",firm_info.getName());
item.put("firm_time",firm_info.getTime());
item.put("firm_address",firm_info.getAdd());
item.put("firm_controller",firm_info.getController());
item.put("controller_phone",firm_info.getControllerPhone());
item.put("contact_people",firm_info.getContactPeople());
item.put("contact_phone",firm_info.getContactPhone());
data.add(item);
}
    SimpleAdapter adapter = new SimpleAdapter(this,data,R.layout.item, new String[]{"fimr_name","firm_time","firm_address","firm_controller","controller_phone","contact_people","contact_phone"},new int[]{R.id.firm_name,R.id.firm_time,R.id.firm_address,R.id.firm_controller,R.id.controller_phone,R.id.contact_people,R.id.contact_phone});
    listView.setAdapter(adapter);
}
//public void showList2(){
//   Cursor cursor = firm_infoService.getCursorScrollData(0, 50);
  //该适配器要求返回的结果集cursor必须包含_id字段，所以需要对取得结果集进行处理
//   SimpleCursorAdapter adapter = new SimpleCursorAdapter(this,R.layout.item,cursor,new String[]{"fimr_name","firm_time","firm_address","firm_controller","controller_phone","contact_people","contact_phone"}, new int[]{R.id.firm_name,R.id.firm_time,R.id.firm_address,R.id.firm_controller,R.id.controller_phone,R.id.contact_people,R.id.contact_phone} );
//   listView.setAdapter(adapter);
//  }

// public void showList3(){
//  List<firm_info> firm_infos = firm_infoService.getScrollData(0, 50);
  ///**
   //* 第一个参数：上下文context，第二个参数：要显示的数据，第三个参数：绑定的条目界面
   //*/
  //Firm_infoAdapter adapter = new Firm_infoAdapter(this, firm_infos, R.layout.item);
  //listView.setAdapter(adapter);
 //}

}

Answer 2

import java.util.ArrayList;
import java.util.List;import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;import ezpe.pe.firm_info;
import ezpe.pe.dbHelper;public class firm_infoService { private dbHelper dbOperateHelper;
 
 
 public firm_infoService (Context context) {
  this.dbOperateHelper = new dbHelper(context);
 }
    /**
     * 保存记录
     * @param person
     */
 public void save(firm_info firm_info){
  //得到数据库实例，里面封装了数据库操作方法
  SQLiteDatabase sqldb =  dbOperateHelper.getWritableDatabase();
     //sqldb.execSQL("insert into person(name,phone) values('"+person.getName()+"','"+person.getPhone()+"')");
  //利用占位符可以避免注入，但是注意数组参与与占位符对应的字段要一一对应
  sqldb.execSQL("insert into firm_info(firm_name,firm_time,firm_address,firm_controller,controller_phone,contact_people,contact_phone) values(?,?,?,?,?,?,?)",new Object[]{firm_info.getName(),firm_info.getTime(),firm_info.getAdd(),firm_info.getController(),firm_info.getControllerPhone(),firm_info.getContactPeople(),firm_info.getContactPhone()});
     //关闭数据库
  sqldb.close();
 }
 
 /**
  * 删除记录
  * @param id
  */
 public void delete(Integer id){
  SQLiteDatabase sqldb = dbOperateHelper.getWritableDatabase();
  sqldb.execSQL("delete from firm_info where firm_id=?",new Object[]{id});
  sqldb.close();
 }
 
 /**
  * 更新记录
  * @param person
  */
 public void update(firm_info firm_info){
  SQLiteDatabase sqldb = dbOperateHelper.getWritableDatabase();
  sqldb.execSQL("update firm_info set firm_name=?,firm_time=?,firm_add=?,firm_controller=?,controller_phone=?,contact_people=?,contact_phone=? where firm_id=?",new Object[]{firm_info.getName(),firm_info.getTime(),firm_info.getAdd(),firm_info.getController(),firm_info.getControllerPhone(),firm_info.getContactPeople(),firm_info.getContactPhone()});
  sqldb.close();
 }
 
 /**
  * 通过ID查询记录
  * @param id
  * @return
  */
 public firm_info find(Integer id){
  /**
   * getWritableDatabase 与  getReadableDatabase 的区别：
   * getReadableDatabase会先返回getWritableDatabase(可写)，如果调用getWritableDatabase失败
   * 则才会调用getReadableDatabase后续方法，使数据库只读
   * 当写入的数据超过数据库大小则调用getWritableDatabase会失败
   * 所以只读时则可以使用此方法，其它情况(只要不是超过数据库大小)也可以使用此方法
   */  
  SQLiteDatabase sqldb = dbOperateHelper.getReadableDatabase();
  Cursor cursor = sqldb.rawQuery("select * from firm_info where firm_id=?", new String[]{String.valueOf(id)});
  int firm_id;
  String firm_name;
  String firm_time;
  String firm_address;
  String firm_controller;
  String controller_phone;
  String contact_people;
  String contact_phone;
  firm_info firm_info = null;
  if(cursor.moveToFirst()){
   firm_id = cursor.getInt(cursor.getColumnIndex("firm_id"));
   firm_name = cursor.getString(cursor.getColumnIndex("firm_name"));
   firm_time = cursor.getString(cursor.getColumnIndex("firm_time"));
   firm_address = cursor.getString(cursor.getColumnIndex("firm_address"));
   firm_controller = cursor.getString(cursor.getColumnIndex("firm_controller"));
   controller_phone = cursor.getString(cursor.getColumnIndex("controller_phone"));
   contact_people = cursor.getString(cursor.getColumnIndex("contact_people"));
   contact_phone = cursor.getString(cursor.getColumnIndex("contact_phone"));
   firm_info = new firm_info(firm_id,firm_name,firm_time,firm_address,firm_controller,controller_phone,contact_people,contact_phone);
  }
  cursor.close();
  return firm_info;
 }
 
 /**
  * 返回指定长度记录，limit 3,5,适用于分页
  * @param offset 起始
  * @param maxResult 长度
  * @return
  */
 public List<firm_info> getScrollData(int offset,int maxResult){
  
  SQLiteDatabase sqldb = dbOperateHelper.getReadableDatabase();
  Cursor cursor = sqldb.rawQuery("select * from firm_info order by firm_id asc limit ?,?", new String[]{String.valueOf(offset),String.valueOf(maxResult)});
  int firm_id;
  String firm_name;
  String firm_time;
  String firm_address;
  String firm_controller;
  String controller_phone;
  String contact_people;
  String contact_phone;
  firm_info firm_info = null;
  List<firm_info> firm_infos = new ArrayList<firm_info>();
  while(cursor.moveToNext()){
  firm_id = cursor.getInt(cursor.getColumnIndex("firm_id"));
   firm_name = cursor.getString(cursor.getColumnIndex("firm_name"));
   firm_time = cursor.getString(cursor.getColumnIndex("firm_time"));
   firm_address = cursor.getString(cursor.getColumnIndex("firm_address"));
   firm_controller = cursor.getString(cursor.getColumnIndex("firm_controller"));
   controller_phone = cursor.getString(cursor.getColumnIndex("controller_phone"));
   contact_people = cursor.getString(cursor.getColumnIndex("contact_people"));
   contact_phone = cursor.getString(cursor.getColumnIndex("contact_phone"));
   firm_info = new firm_info(firm_id,firm_name,firm_time,firm_address,firm_controller,controller_phone,contact_people,contact_phone);
       firm_infos.add(firm_info);
  }
  cursor.close();
  return firm_infos;  
 }
 
 /**
  * 返回cursor
  * @param offset 起始
  * @param maxResult 长度
  * @return
  */
 public Cursor getCursorScrollData(int offset,int maxResult){
  
  SQLiteDatabase sqldb = dbOperateHelper.getReadableDatabase();
  Cursor cursor = sqldb.rawQuery("select firm_id as _firm_id,firm_name,firm_time,firm_address,firm_controller,controller_phone,contact_people,contact_phone from firm_info order by firm_id asc limit ?,?", new String[]{String.valueOf(offset),String.valueOf(maxResult)});
  
  return cursor;  
 }
 
 /**
  * 返回总记录数
  * @return
  */
 public long getCount(){
  SQLiteDatabase sqldb = dbOperateHelper.getReadableDatabase();
  
  Cursor cursor = sqldb.rawQuery("select count(*) from firm_info", null);
  //该查询语句值返回一条语句
  cursor.moveToFirst();
  long result = cursor.getLong(0);
  cursor.close();
  return result;
 }
 
 /*
 public void payment(){
  SQLiteDatabase sqldb = dbOperateHelper.getWritableDatabase();
  sqldb.beginTransaction();//开启事务
  try{
   sqldb.execSQL("update person set amount = amount -10 where personid=1");
   sqldb.execSQL("update person set amount = amount + 10 where personid=2");
   sqldb.setTransactionSuccessful();//设置事务标志位true
  } finally {
   //结束事务：有两种情况：commit\rollback，事务提交或者回滚是由事务的标识决定的
   //事务为ture则提交，事务为flase则回滚，默认为false
   sqldb.endTransaction();
  }
 }*/
}public class firm_info {

private Integer firm_id;
private String firm_name;
private String firm_time;
private String firm_address;
private String firm_controller;
private String controller_phone;
private String contact_people;
private String contact_phone;

public Integer getId(){
return firm_id;
}

public void setId(Integer id){
this.firm_id=id;
}

public String getName(){
return firm_name;
}

public void setName(String name){
this.firm_name=name;
}

public String getTime(){
return firm_time;
}

public void setTime(String time){
this.firm_time=time;
}

public String getAdd(){
return firm_address;
}

public void setAdd(String add){
this.firm_address=add;
}

public String getController(){
return firm_controller;
}

public void setController(String controller){
this.firm_controller=controller;
}

public String getControllerPhone(){
return controller_phone;
}

public void setControllerPhone(String controllerphone){
this.firm_name=controllerphone;
} public String getContactPeople(){
return contact_people;
}

public void setContactPeople(String contactpeople){
this.contact_people=contactpeople;
}
public String getContactPhone(){
return contact_phone;
}

public void setContactPhone(String contactphone){
this.contact_phone=contactphone;
}

public firm_info(int id, String name, String time, String add, String controller, String controllerphone, String contact, String contactphone)
{
this.firm_id=id;
this.firm_name=name;
this.firm_time=time;
this.firm_address=add;
this.firm_controller=controller;
this.controller_phone=controllerphone;
this.contact_people=contact;
this.contact_phone=contactphone;

}

public firm_info(String name, String time, String add, String controller, String controllerphone, String contact, String contactphone)
{
this.firm_name=name;
this.firm_time=time;
this.firm_address=add;
this.firm_controller=controller;
this.controller_phone=controllerphone;
this.contact_people=contact;
this.contact_phone=contactphone;
}

public firm_info(){
super();
}


public String toString(){
return "firm_info [firm_id="+firm_id+",firm_name="+firm_name+",firm_time="+firm_time+"firm_address="+firm_address+"firm_controller="+firm_controller+"controller_phone="+controller_phone+"contact_people="+contact_people+"contact_phone="+contact_phone+"]";
}
}

Answer 3

import android.content.ContentValues;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteDatabase;
import android.database.Cursor;
import android.database.sqlite.SQLiteOpenHelper;public class dbHelper extends SQLiteOpenHelper{

private final static String DATABASE_NAME="pe_db";
private final static int DATABASE_VERSION=1;
private final static String TABLE_NAME="firm_info";
public final static String FIRM_ID="firm_id";
    public final static String FIRM_NAME="firm_name"; 
    public final static String FIRM_TIME="firm_time";
    public final static String FIRM_ADDRESS="firm_address";
    public final static String FIRM_CONTROLLER="firm_controller";
    public final static String CONTROLLER_PHONE="controller_phone";
    public final static String CONTACT_PEOPLE="contact_people";
    public final static String CONTACT_PHONE="contact_phone";

public dbHelper (Context context)
{
super(context, DATABASE_NAME,null,DATABASE_VERSION);
}


public void onCreate(SQLiteDatabase db){
String sql="Create table "+TABLE_NAME+"("+FIRM_ID+" char primary key autoincrement,"
        +FIRM_NAME+"char,"+FIRM_TIME+" char,"+FIRM_ADDRESS+" char, "+FIRM_CONTROLLER+" char,"+CONTROLLER_PHONE+" char,"+CONTACT_PEOPLE+" char,"+CONTACT_PHONE+" char, );";
        db.execSQL(sql);
}

 @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        String sql=" DROP TABLE IF EXISTS "+TABLE_NAME;
        db.execSQL(sql);
        onCreate(db);
    }     public Cursor select()
    {
        SQLiteDatabase db=this.getReadableDatabase();
        Cursor cursor=db.query(TABLE_NAME, null, null, null, null, null,  " firm_name");
        return cursor;
    }
    
    public long insert(String Title)
    {
        SQLiteDatabase db=this.getWritableDatabase();
        ContentValues cv=new ContentValues(); 
        cv.put(FIRM_TIME, Title);
        cv.put(CONTACT_PEOPLE, Title);
        cv.put(FIRM_ADDRESS, Title);
        cv.put(FIRM_CONTROLLER, Title);
        cv.put(CONTROLLER_PHONE, Title);
        cv.put(CONTACT_PEOPLE, Title);
        cv.put(CONTACT_PHONE, Title);
        long row=db.insert(TABLE_NAME, null, cv);
        return row;
    }
    
    public void delete(int id)
    {
        SQLiteDatabase db=this.getWritableDatabase();
        String where=FIRM_NAME+"=?";
        String[] whereValue={Integer.toString(id)};
        db.delete(TABLE_NAME, where, whereValue);
    }
    
    public void update(int id,String Title)
    {
        SQLiteDatabase db=this.getWritableDatabase();
        String where=FIRM_NAME+"=?";
        String[] whereValue={Integer.toString(id)};
        ContentValues cv=new ContentValues(); 
        cv.put(FIRM_TIME, Title);
        cv.put(CONTACT_PEOPLE, Title);
        cv.put(FIRM_ADDRESS, Title);
        cv.put(FIRM_CONTROLLER, Title);
        cv.put(CONTROLLER_PHONE, Title);
        cv.put(CONTACT_PEOPLE, Title);
        cv.put(CONTACT_PHONE, Title);
        db.update(TABLE_NAME, cv, where, whereValue);
    }
    }<?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:layout_width="fill_parent"
    android:layout_height="wrap_content"
    android:orientation="horizontal" >    <TextView
        android:id="@+id/firm_name"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/firm_name" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/firm_time"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/firm_time" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/firm_address"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/firm_address" 
        android:gravity="center"/>
     <TextView
        android:id="@+id/firm_controller"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/firm_controller" 
        android:gravity="center"/>
      <TextView
        android:id="@+id/controller_phone"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/controller_phone" 
        android:gravity="center"/>
       <TextView
        android:id="@+id/contact_people"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/contact_people" 
        android:gravity="center"/>
        <TextView
        android:id="@+id/contact_phone"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/contact_phone" 
        android:gravity="center"/></LinearLayout>
    <ListView
        android:id="@+id/listView"
        android:layout_width="fill_parent"
        android:layout_height="fill_parent" >
    </ListView></LinearLayout>
<?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:id="@+id/firm_name"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/firm_name" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/firm_time"
        android:layout_width="100dip"
        android:layout_height="wrap_content"
        android:text="@string/firm_time" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/firm_address"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/firm_address" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/firm_controller"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/firm_controller" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/controller_phone"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/controller_phone" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/contact_people"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/contact_people" 
        android:gravity="center"/>
    <TextView
        android:id="@+id/contact_phone"
        android:layout_width="fill_parent"
        android:layout_height="wrap_content"
        android:text="@string/contact_phone" 
        android:gravity="center"/></LinearLayout>

Answer 4

private void showList(){
        List<firm_info>firm_infos = firm_infoService.getScrollData(0,50);
        List<HashMap<String,Object>>data = new ArrayList<HashMap<String,Object>>();
        for(firm_info firm_info:firm_infos){
            HashMap<String,Object>item = new HashMap<String,Object>();
            item.put("firm_name",firm_info.getName());
            item.put("firm_time",firm_info.getTime());
            item.put("firm_address",firm_info.getAdd());
            item.put("firm_controller",firm_info.getController());
            item.put("controller_phone",firm_info.getControllerPhone());
            item.put("contact_people",firm_info.getContactPeople());
            item.put("contact_phone",firm_info.getContactPhone());
            data.add(item);
        }    //--看data有没有值，下面一行“fimr_name”拼写错误。
        SimpleAdapter adapter = new SimpleAdapter(this,data,R.layout.item, new String[]{"fimr_name","firm_time","firm_address","firm_controller","controller_phone","contact_people","contact_phone"},new int[]{R.id.firm_name,R.id.firm_time,R.id.firm_address,R.id.firm_controller,R.id.controller_phone,R.id.contact_people,R.id.contact_phone});
        listView.setAdapter(adapter);
    }

Answer 5

我后来改了个实现的方法。
但是发现sqlite创建的时候没问题，插入的时候没有反应，也不报错。
在DDMS里导出那个db文件查看里面有创建的表，但是没有插入的数据。创建tablepublic void onCreate(SQLiteDatabase db){
String sql="Create table "+TABLE_NAME+"("+BaseColumns._ID+" integer primary key autoincrement,"
        +FIRM_NAME+" char(50),"+FIRM_TIME+" char(50),"+FIRM_ADDRESS+" char(100), "+FIRM_CONTROLLER+" char(50),"+CONTROLLER_PHONE+" char(50),"+CONTACT_PEOPLE+" char(50),"+CONTACT_PHONE+" char(50));";



db.execSQL(sql);

         }
insertpublic static void InsertFirmInfo()  
     {  
    
  //String name="FIRM_INFO";
  //String f_id="firm_id";
      try
      {
      //String sql="insert into firm_info values('"+"null',"+"'"+PeActivity.firm_name+"','"+PeActivity.firm_time+"'," +
       //    "'"+PeActivity.firm_address+"','"+PeActivity.firm_controller+"','"+PeActivity.controller_phone+"'," +
       //   "'"+PeActivity.contact_people+"','"+PeActivity.contact_phone+"');";
          dbUtil.getWritableDatabase();
      ContentValues v = new ContentValues();
          v.put("firm_name", PeActivity.firm_name);
          v.put("firm_time", PeActivity.firm_time);
          v.put("firm_address", PeActivity.firm_address);
          v.put("firm_controller", PeActivity.firm_controller);
          v.put("controller_phone", PeActivity.controller_phone);
          v.put("contact_people", PeActivity.contact_people);
          v.put("contact_phone", PeActivity.contact_phone);
         
         
      db.insertOrThrow("firm_info",null,v);
       // String sql= "insert into firm_info(firm_name,firm_time,firm_address,firm_controller,controller_phone,contact_people,contact_phone) values(?,?,?,?,?,?,?)";
       // db.execSQL(sql, new Object[]{mFirm_info.getName(),FIRM_INFO.getTime(),FIRM_INFO.getAdd(),FIRM_INFO.getController(),FIRM_INFO.getControllerPhone(),FIRM_INFO.getContactPeople(),FIRM_INFO.getContactPhone()});
      }
  catch(Exception e)
  {
  e.printStackTrace();
  }
     }

Answer 6

亲，新手求问firm_infoService = new firm_infoService(this);中的firm_infoService是自己定义的类么，这个类怎么写呀？