XUtils中的dbUtils用法

package com.example.dbutils;

import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import com.lidroid.xutils.DbUtils;
import com.lidroid.xutils.db.sqlite.Selector;
import com.lidroid.xutils.db.sqlite.WhereBuilder;
import com.lidroid.xutils.exception.DbException;

import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.view.ViewGroup;
import android.widget.BaseAdapter;
import android.widget.ListView;
import android.widget.TextView;

public class MainActivity extends Activity {

 private ListView lv;
 private DbUtils db;
 private List<User> list;

 @Override
 protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);
  lv = (ListView) findViewById(R.id.listView1);
  db = DbUtils.create(this, "dapiliang");
  try {
   db.createTableIfNotExist(User.class);
  } catch (DbException e) {
   e.printStackTrace();
  }
  // lv.setAdapter(adapter);
 }

 public void add(View v) {
  List<User> entities = new ArrayList<User>();
  for (int i = 0; i < 5; i++) {
   entities.add(new User(i, "白海超" + i, i, "男", "1306176415" + i,
     "祖州神仙居"));
  }
  try {
   db.saveAll(entities);
  } catch (DbException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }

 public void delete(View v) {
  /*for (int i = 0; i < 3; i++) {
   entities.add(new User(i, "白爷" + i, i, "男", "1306176415" + i,
     "神州诸神殿"));
  }*/
  try {
   List<User> entities = db.findAll(User.class);
   WhereBuilder whereBuilder=WhereBuilder.b("id", ">", "2");
   db.deleteAll(entities);
   //db.delete(User.class, whereBuilder);
  } catch (Exception e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }

 public void update(View v) {
  List<User> entities = new ArrayList<User>();
  for (int i = 0; i < 3; i++) {
   entities.add(new User(i, "白爷" + i, i, "男", "1306176415" + i,
     "神州诸神殿"));
  }
  WhereBuilder whereBuilder=WhereBuilder.b("id", ">", "2");
  
  try {
   db.updateAll(entities, whereBuilder, "name","address");
  } catch (DbException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }

 public void query(View v) {
  try {
   if (list != null) {
    list.clear();
   }
   list = db.findAll(Selector.from(User.class).orderBy("age", true));
   lv.setAdapter(new Adapter());
  } catch (DbException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  }
 }

 class Adapter extends BaseAdapter {

  @Override
  public int getCount() {
   // TODO Auto-generated method stub
   return list.size();
  }

  @Override
  public Object getItem(int position) {
   // TODO Auto-generated method stub
   return list.get(position);
  }

  @Override
  public long getItemId(int position) {
   // TODO Auto-generated method stub
   return position;
  }

  @Override
  public View getView(int position, View convertView, ViewGroup parent) {
   // TODO Auto-generated method stub
   User u = list.get(position);
   convertView = View.inflate(MainActivity.this, R.layout.list, null);
   TextView tv1 = (TextView) convertView.findViewById(R.id.textView1);
   TextView tv2 = (TextView) convertView.findViewById(R.id.textView2);
   TextView tv3 = (TextView) convertView.findViewById(R.id.textView3);
   tv1.setText(u.getName());
   tv2.setText(u.getPhone());
   tv3.setText(u.getAddress());
   return convertView;
  }

 }
}