Caused by: android.database.sqlite.SQLiteException: near "xxxx"

来源：互联网发布：网页优化怎么做编辑：程序博客网时间：2024/05/23 13:30

</pre>先看错误：<pre name="code" class="plain">08-16 11:06:31.221: E/AndroidRuntime(12581): Caused by: android.database.sqlite.SQLiteException: near "ID": syntax error (code 1): , while compiling: SELECT * FROM cart c INNER JOIN food f ON c.foodID=f.food ID08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at com.xxx.xxxxx.xxxxx.xxx.query(CartProvider.java:35)（应用包名）08-16 11:06:31.221: E/AndroidRuntime(12581): at android.content.ContentProvider.query(ContentProvider.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.content.ContentProvider$Transport.query(ContentProvider.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.content.ContentResolver.query(ContentResolver.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.content.ContentResolver.query(ContentResolver.java)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.support.v4.content.CursorLoader.loadInBackground(CursorLoader.java:49)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.support.v4.content.CursorLoader.loadInBackground(CursorLoader.java:35)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.support.v4.content.AsyncTaskLoader.onLoadInBackground(AsyncTaskLoader.java:240)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.support.v4.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:51)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.support.v4.content.AsyncTaskLoader$LoadTask.doInBackground(AsyncTaskLoader.java:40)08-16 11:06:31.221: E/AndroidRuntime(12581): at android.support.v4.content.ModernAsyncTask$2.call(ModernAsyncTask.java:123)08-16 11:06:31.221: E/AndroidRuntime(12581): at java.util.concurrent.FutureTask.run(FutureTask.java:234)08-16 11:06:31.221: E/AndroidRuntime(12581): ... 3 more

出现这种错误,一般都是SQL语句拼写错误,或者使用androidApi的使用错误,仔细检查一下一的sql语法是否错误.

请看我的错误：

很明显 foodID有一个空格,错误就在这里.

0 0