安卓SQLite轻量级数据库（增、删、改、查）

数量库的创建（）

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;

public class MySQL extends SQLiteOpenHelper {

	public MySQL(Context context) {
		super(context, "1510d", null, 1);
		// TODO Auto-generated constructor stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
        db.execSQL("create table user (id Integer primary key autoincrement,name varchar(20),age varchar(20))");
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		// TODO Auto-generated method stub

	}

}

//创建个工具类，方便使用时候的调用（）

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

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

public class UserDao {

	private SQLiteDatabase database;

	public UserDao(Context context) {

		// 创建数据库

		MySQL mySQL = new MySQL(context);

		database = mySQL.getWritableDatabase();
	}

	// 添加
	public boolean add(String name, String age, String geyan) {

		ContentValues values = new ContentValues();

		values.put("name", name);
		values.put("age", age);
		values.put("geyan", geyan);

		long a = database.insert("student", null, values);

		if (a != -1) {
			return true;
		} else {
			return false;
		}
	}

	// 查询
	public List<User> select() {
		List<User> list = new ArrayList<User>();

		Cursor cursor = database.query("student", null, null, null, null, null,
				null, null);

		while (cursor.moveToNext()) {
			String name = cursor.getString(cursor.getColumnIndex("name"));
			String age = cursor.getString(cursor.getColumnIndex("age"));
			String geyan = cursor.getString(cursor.getColumnIndex("geyan"));

			User user = new User(name, age, geyan);

			list.add(user);

		}

		return list;

	}
   //删除
   public boolean delete(String names){
	   
	   int i = database.delete("student", "name=?", new String[]{names});
	   
	   if(i!=-1){
		   return true;
	   }else{
		   return false;
	   }
	
	   
   }
}