android.database.CursorIndexOutOfBoundsException:Index -1 requested, with a size of 1

本文探讨了在Android开发过程中使用Cursor时遇到的CursorIndexOutOfBoundsException异常,并提供了正确的Cursor使用方法来避免此类问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

android.database.CursorIndexOutOfBoundsException:Index -1 requested, with a size of 1

android 中数据库处理,特别是使用cursor时,注意初始位置,好像是从下标为-1的地方开始的,也就是说一次查询中,返回给cursor查询结果时,不能够马上从cursor中提取值。

比如,下面的代码会返回错误,android.database.CursorIndexOutOfBoundsException:Index -1 requested, with a size of 0:
<p style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-bottom: 0px;"><span style="font-size: 18px;"><span class="kwd">int</span><span class="pln"> score </span><span class="pun">=</span><span class="pln"> </span><span class="pun">((</span><span class="typ">Cursor</span><span class="pun">)</span><span class="pln">getReadableDatabase</span><span class="pun">().</span><span class="pln">query</span><span class="pun">(</span><span class="pln">TABLE_NAME</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">String</span><span class="pun">[]{</span><span class="str">"learned"</span><span class="pun">},</span><span class="pln"> </span><span class="str">"_id=?"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">String</span><span class="pun">[]{</span><span class="str">""</span><span class="pun">+</span><span class="pln">id</span><span class="pun">},</span><span class="pln"> </span><span class="kwd">null</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">null</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">null</span><span class="pun">,</span><span class="str">"1"</span><span class="pun">)).</span><span class="pln">getInt</span><span class="pun">(</span><span class="lit">0</span><span class="pun">);</span></span></p>

正确的用法:
<p style="margin-top: 0px; margin-bottom: 0px; padding-top: 0px; padding-bottom: 0px;"><span style="font-size: 18px;"><span class="pln">  </span><span class="typ">Cursor</span><span class="pln"> cursor </span><span class="pun">=</span><span class="pln"> getReadableDatabase</span><span class="pun">().</span><span class="pln">query</span><span class="pun">(</span><span class="pln">TABLE_NAME</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">String</span><span class="pun">[]{</span><span class="str">"learned"</span><span class="pun">},</span><span class="pln"> </span><span class="str">"_id=?"</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">new</span><span class="pln"> </span><span class="typ">String</span><span class="pun">[]{</span><span class="str">""</span><span class="pun">+</span><span class="pln">id</span><span class="pun">},</span><span class="pln"> </span><span class="kwd">null</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">null</span><span class="pun">,</span><span class="pln"> </span><span class="kwd">null</span><span class="pun">,</span><span class="str">"1"</span><span class="pun">);</span>
<span class="pln">  </span><span class="kwd">int</span><span class="pln"> learned</span><span class="pun">=</span><span class="lit">0</span><span class="pun">;</span>
<span class="pln">  </span><span class="kwd">if</span><span class="pun">(</span><span class="pln">cursor</span><span class="pun">.</span><span class="pln">moveToFirst</span><span class="pun">()){</span>
<span class="pln">   score</span><span class="pun">=</span><span class="pln"> cursor</span><span class="pun">.</span><span class="pln">getInt</span><span class="pun">(</span><span class="lit">0</span><span class="pun">);</span>
<span class="pln">  </span><span class="pun">}</span>
<span class="pln">  cursor</span><span class="pun">.</span><span class="pln">close</span><span class="pun">();</span></span></p><div><span style="font-size: 18px;"><span class="pun">
</span></span></div>
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值