Cannot bind argument at index 1 because the index is out of range. The statement has 0 parameters.

SQLIT出现的错误:
04-24 17:51:28.116 3724-3724/com.liba.targetreportandroid E/AndroidRuntime: FATAL EXCEPTION: main
    Process: com.liba.targetreportandroid, PID: 3724
    java.lang.IllegalArgumentException: Cannot bind argument at index 1 because the index is out of range.  The statement has 0 parameters.
        at android.database.sqlite.SQLiteProgram.bind(SQLiteProgram.java:217)
        at android.database.sqlite.SQLiteProgram.bindString(SQLiteProgram.java:171)
        at android.database.sqlite.SQLiteProgram.bindAllArgsAsStrings(SQLiteProgram.java:205)
        at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
        at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1344)
        at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1278)
        at com.liba.targetreportandroid.fragment.PadFragment.queryDatasByTargetId(PadFragment.java:1155)
        at com.liba.targetreportandroid.fragment.PadFragment.reDrawIfChangeTarget(PadFragment.java:578)
        at com.liba.targetreportandroid.fragment.PadFragment.onPositionSelect(PadFragment.java:490)
        at com.liba.targetreportandroid.pickerview.PickerView.onClick(PickerView.java:75)
        at android.view.View.performClick(View.java:5264)
        at android.view.View$PerformClick.run(View.java:21297)
        at android.os.Handler.handleCallback(Handler.java:743)
        at android.os.Handler.dispatchMessage(Handler.java:95)
        at android.os.Looper.loop(Looper.java:150)

数据库代码如下:

 Data data = null;
        DBHelper db = new DBHelper(getActivity());
        SQLiteDatabase localSQLiteDatabase = db.getReadableDatabase();
        localSQLiteDatabase.beginTransaction();
        Cursor localCursor = localSQLiteDatabase.rawQuery("select * from datas where target_id+'=?'",
                new String[]{target_id});
        localSQLiteDatabase.setTransactionSuccessful();
        localSQLiteDatabase.endTransaction();
        while (localCursor.moveToNext()) {
            data = new Data();
请教这是怎么回事,数据库语句中加不加=号都是一样的错误。
  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值