Android SQLiteDatabase 数据库操作（建立数据表，增删改查操作）

SQLiteDatabase接口操作建立数据表

public class BlackNumberDBHelper extends SQLiteOpenHelper {

	private static SQLiteOpenHelper mInstance;
	
	private final static String name = "xxx.db";
	
	public static SQLiteOpenHelper getInstance(Context context){
		if(mInstance == null){
			mInstance = new BlackNumberDBHelper(context, name, null, 1);
		}
		return mInstance;
	}
	
	private BlackNumberDBHelper(Context context, String name,
			CursorFactory factory, int version) {
		super(context, name, factory, version);
		// TODO Auto-generated constructor stub
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		// TODO Auto-generated method stub
        db.execSQL("create table xxx(_id integer primary key autoincrement,xx_1 text)");
	}

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

	}

}

SQLiteDatabase增删改查具体操作

public class Dao {

	private SQLiteOpenHelper mOpenHelper;
	
	public BlackNumberDao(Context context) {
		// TODO Auto-generated constructor stub
		mOpenHelper = BlackNumberDBHelper.getInstance(context);
	}
	
	//添加数据信息
	public void add(String xx_1){
		SQLiteDatabase db = mOpenHelper.getWritableDatabase();
		if(db.isOpen()){
			ContentValues values = new ContentValues();
			values.put("xx_1", xx_1);
			db.insert("xxx", "_id", values);
			db.close();
		}
	}
	
	//判断号码是否是数据信息
	public boolean isBlackNumber(String xx_1){
		boolean isExist = false;
		SQLiteDatabase db = mOpenHelper.getReadableDatabase();
		if(db.isOpen()){
			Cursor c = db.query("xxx", null, " xx_1= ? ", new String[]{xx_1}, null, null, null);
			if(c.moveToFirst()){
				isExist = true;
			}
			c.close();
			db.close();
		}
		return isExist;
	}
	
	//删除数据信息
	public void delete(String xx_1){
		SQLiteDatabase db = mOpenHelper.getWritableDatabase();
		if(db.isOpen()){
			db.delete("xxx", " xx_1= ? ", new String[]{xx_1});
			db.close();
		}
	}
	
	//更新数据信息
	public void update(int id,String xx_1){
		SQLiteDatabase db = mOpenHelper.getWritableDatabase();
		if(db.isOpen()){
			ContentValues values = new ContentValues();
			values.put("xx_1", xx_1);
			db.update("xxx", values, " _id = ? ", new String[]{id+""});
			db.close();
		}
	}
                //得到所有的数据记录	
    		public List<String> findAll(){
		List<String> xx_1= new ArrayList<String>();
		SQLiteDatabase db = mOpenHelper.getReadableDatabase();
		if(db.isOpen()){
			Cursor c = db.query("xxx", new String[]{"xx_1"}, null, null, null, null, null);
			while(c.moveToNext()){
				String xx= c.getString(0);
				xx_1.add(xxx);
			}
			c.close();
			db.close();
		}
		return xx_1;
	}
	
}