安卓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}@Overridepublic 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))");}@Overridepublic 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;   }      }}