如何在SQLITE Android中添加子查询和’IN’?
我的问题是我要写这个
select * from contacts where id in (select cpk from mapping where gpk = 'MY-VARIABLE-HERE') 在Android中查询但在运行时失败. 到目前为止,我已经尝试过这些: 1)Cursor cursor = myDataBase.rawQuery(“select * from contacts where where in(select cpk from mapping where gpk =”“’”“?”“’”“)”,new String [] {grpName}); 2)Cursor cursor = myDataBase.query(TABLE_CONTACTS,null,“id in”,new String [] {“(从映射中选择cpk,其中gpk =’”grpName“’)”},null); 3)Cursor cursor = myDataBase.rawQuery(“select * from contacts where where in(select cpk from mapping where gpk =?)”,new String [] {grpName}); 请帮帮我…提前谢谢…… 解决方法我解决了这个问题,我为变量传递了错误的值.Cursor cursor = myDataBase.rawQuery("select * from contacts where id in (select cpk from mapping where gpk = ?)",new String[]{grpName}); 工作正确. 谢谢大家帮忙.. (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |