Dbutils

package com.example.dbutils;

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

import com.lidroid.xutils.DbUtils;
import com.lidroid.xutils.exception.DbException;

import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.View;

public class MainActivity extends Activity {

	private DbUtils create;

	@Override
	protected void onCreate(Bundle savedInstanceState) {
		super.onCreate(savedInstanceState);
		setContentView(R.layout.activity_main);
		//根据第一个参数进行删改
		create = DbUtils.create(this, "android.db");
		try {
			//当没有这张表的时候自动创建
			create.createTableIfNotExist(Android.class);
		} catch (DbException e) {
			e.printStackTrace();
		}
	}

	public void add(View v) {
		try {
			create.save(new Android(1, "张三", "23", "北京"));
		} catch (DbException e) {
			e.printStackTrace();
		}

	}

	public void delete(View v) {

		try {
			create.delete(new Android(3, null, null, null));
		} catch (DbException e) {
			e.printStackTrace();
		}
	}

	public void update(View v) {

		try {
			create.update(new Android(5, "李四", "18", "上海"));
		} catch (DbException e) {
			e.printStackTrace();
		}
	}

	public void select(View v) {

		try {
			List<Android> findAll = create.findAll(Android.class);
			for (Android a : findAll) {
				Log.i("android", a.toString());
			}
		} catch (DbException e) {
			e.printStackTrace();
		}
	}
}