android sqlite查询方式

1、    cursor= db.query("limp_con_areacode", new String[]{"parentId","name"}, "code = ?", new String[]{code}, null, null, null, null);
          cursor= db.rawQuery("select name from limp_con_areacode a where a.code= ?",new String[]{code});

2、    cursor= db.rawQuery(" SELECT NAME FROM limp_con_areacode  b WHERE b.code IN (SELECT parentid FROM limp_con_areacode a WHERE a.code="+code+") or b.code="+code,new String[]{});

 

    第二种方式中，注意‘or’不能写成‘||’，否则查不到数据