android的sqlite的query使用

查询单条语句

@Override
	public Map<String, String> viewPerson(String selection,String[] selectionArgs) {
		// TODO Auto-generated method stub
		boolean flag=false;
		sqLiteDatabase = null;
		Cursor cursor=null;
		Map<String, String> map=new HashMap<String, String>();
		try {
			sqLiteDatabase=helper.getReadableDatabase();
			cursor=	sqLiteDatabase.query(
					true,//消除重复
					"person", //表名
					null, //返回的列名。空为所有列
					selection, //返回哪一列
					selectionArgs,//You may include ?s in selection,
					null, 
					null, 
					null, 
					null);
			int cols_len=cursor.getColumnCount();
			while(cursor.moveToNext()){
				for (int i = 0; i < cols_len; i++) {
					String cols_name=cursor.getColumnName(i);
					String cols_value=cursor.getString(cursor.getColumnIndex(cols_name));
					if(cols_value==null){
						cols_value="";
					}
					map.put(cols_name, cols_value);
				}
			}
		} catch (Exception e) {
			// TODO: handle exception
			e.printStackTrace();
		} finally {
			if(sqLiteDatabase!=null){
			sqLiteDatabase.close();
			}
		}
		
		return map;
	}

//——————————————————————————

public void ViewPerson(){
		PersonService service2=new PersonDao2(getContext());
		Map<String, String> viewPerson = service2.viewPerson("_id=?", new String[]{"2"});
		System.out.println(viewPerson.toString()+"-->");
	}