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();
请教这是怎么回事,数据库语句中加不加=号都是一样的错误。