SQLite 数据库操作类

GoDB {

  private Database database;
	private SQLiteDatabase db;

	public GoosunDB(Context context) {
		super();
		database = new Database(context);
	}

	public GoosunDB open() throws SQLException {
		db = database.getWritableDatabase();
		return this;
	}

	public void close() {
		db.close();
	}
	
	public Cursor search(int mark) {
		Cursor cursor = db.query(TABLE_SEARCH,new String[] { COL_id,COL_code,COL_name },"mark =" + mark,null,COL_date
				+ " desc");
		if (cursor != null) {
			cursor.moveToFirst();
		}
		return cursor;
	}

	public Cursor searchByCode(String string) {
		Cursor cursor = db.query(TABLE_SEARCH,new String[] { COL_id },"gid = " + "'" + string + "'",null);
		if (cursor != null) {
			cursor.moveToFirst();
		}
		return cursor;
	}

	public long insertEntity(SearchEntity entity) {
		
		Cursor cursor = searchByCode(entity.getCode());

		if (cursor != null && cursor.moveToFirst()) {
			return updateEntity(entity);
		} else {
			ContentValues values = new ContentValues();
			values.put(COL_code,entity.getCode());
			values.put(COL_name,entity.getName());
			values.put(COL_mark,entity.getMark());
			values.put(COL_date,new Date().toString());
			return db.insert(TABLE_SEARCH,values);
		}
	}

	public long updateEntity(SearchEntity entity) {
		ContentValues values = new ContentValues();
		values.put(COL_date,new Date().toString());
		return db.update(TABLE_SEARCH,values,"_id=?",new String[] { String.valueOf(entity.getId()) });
	}

	public long deleteEntity(int mark) {
		return db.delete(TABLE_SEARCH,"mark=?",new String[] { String.valueOf(mark) });
	}
	
	private class Database extends SQLiteOpenHelper {

		public Database(Context context) {
			super(context,DATABASE_NAME,DATABASE_VERSION);
			
		}

		@Override
		public void onCreate(SQLiteDatabase db) {
			
			db.execSQL(TABLE_InsideLetter);
			db.execSQL(TABLE_CREATE);
		}

		@Override
		public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion) {
			
			db.execSQL("DROP TABLE IF EXISTS" + TABLE_SEARCH);
			db.execSQL("DROP TABLE IF EXISTS" + TABLE_Inside);
			onCreate(db);
		}
	}
}

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!