如何解决在SQLite数据库更新查询语法错误 [英] How to solve Syntax error in Update query in Sqlite Database
本文介绍了如何解决在SQLite数据库更新查询语法错误的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我使用
更新
查询在SQLite数据库由值1到0时发生语法错误更新STATUS_MSG
列编译应用程序时。
日志猫
块引用>9月2日至二十日:45:36.145 19350-19350 / com.smsfilter E / SQLiteLog:(1)接近1:语法错误
9月2日至二十〇日:45:36.145 19350-19350 / com.smsfilter D / AndroidRuntime:关闭VM
9月2日至二十〇日:45:36.145 19350-19350 / com.smsfilter W / dalvikvm:主题ID = 1:螺纹未捕获的异常退出(组= 0x40a71930)
9月2日至二十〇日:45:36.195 19350-19350 / com.smsfilter E / AndroidRuntime:致命异常:主要
android.database.sqlite.SQLiteException:接近1:语法错误(code 1),在编译:UPDATE sms_tbl SET 1 = 0 1 = 1
在android.database.sqlite.SQLiteConnection.native prepareStatement(本机方法)
在android.database.sqlite.SQLiteConnection.acquire preparedStatement(SQLiteConnecti on.java:882)
在android.database.sqlite.SQLiteConnection。prepare(SQLiteConnection.java:493)
在android.database.sqlite.SQLiteSession。prepare(SQLiteSession.java:588)
在android.database.sqlite.SQLiteProgram<&初始化GT;(SQLiteProgram.java:58)
在android.database.sqlite.SQLiteQuery<&初始化GT;(SQLiteQuery.java:37)
在android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
在android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
在android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
在com.smsfilter.DB_Message.setStatus(DB_Message.java:106)
在com.smsfilter.SpamActivity $ DataList控件$ 1.onCheckedChanged(SpamActivity.java:208)
在android.widget.CompoundButton.setChecked(CompoundButton.java:126)
在android.widget.CompoundButton.toggle(CompoundButton.java:87)
在android.widget.CompoundButton.performClick(CompoundButton.java:99)
在android.view.View $ PerformClick.run(View.java:17355)
在android.os.Handler.handleCallback(Handler.java:725)
在android.os.Handler.dispatchMessage(Handler.java:92)
在android.os.Looper.loop(Looper.java:137)
在android.app.ActivityThread.main(ActivityThread.java:5041)
在java.lang.reflect.Method.invokeNative(本机方法)
在java.lang.reflect.Method.invoke(Method.java:511)
在com.android.internal.os.ZygoteInit $ MethodAndArgsCaller.run(ZygoteInit.java:793)
在com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560)
在dalvik.system.NativeStart.main(本机方法)
更新功能如下
给出
块引用>公众诠释setStatus(){
SQLiteDatabase SQLDB = this.getWritableDatabase();
串status_change_query =UPDATE+ DB_Table1 +SET+ STATUS_MSG += 0,其中+ STATUS_MSG += 1;
光标光标= sqldb.rawQuery(status_change_query,NULL);
cursor.close();
的System.out.println(+ STATUS_MSG);
sqldb.close();
返回STATUS_MSG;
}
解决方案字符串status_change_query =UPDATE+ DB_Table1 +SET+ STATUS_MSG += 0,其中+ STATUS_MSG + = 1;
给
更新sms_tbl SET 1 = 0,其中1 = 1
在换句话说,你似乎已经简单地混合起来的变量。
STATUS_MSG
应该是你的列名,但它似乎反而是一个数值,结果查询是无效的SQL。I am updating
Status_msg
column usingUpdate
query in Sqlite Database by value 1 to 0. The Syntax error occurred when compiling the application.The Log cat
02-20 09:45:36.145 19350-19350/com.smsfilter E/SQLiteLog: (1) near "1": syntax error 02-20 09:45:36.145 19350-19350/com.smsfilter D/AndroidRuntime: Shutting down VM 02-20 09:45:36.145 19350-19350/com.smsfilter W/dalvikvm: threadid=1: thread exiting with uncaught exception (group=0x40a71930) 02-20 09:45:36.195 19350-19350/com.smsfilter E/AndroidRuntime: FATAL EXCEPTION: main android.database.sqlite.SQLiteException: near "1": syntax error (code 1): , while compiling: UPDATE sms_tbl SET 1 = 0 where 1 = 1 at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method) at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnecti on.java:882) at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:493) at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588) at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58) at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:37) at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44) at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314) at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253) at com.smsfilter.DB_Message.setStatus(DB_Message.java:106) at com.smsfilter.SpamActivity$datalist$1.onCheckedChanged(SpamActivity.java:208) at android.widget.CompoundButton.setChecked(CompoundButton.java:126) at android.widget.CompoundButton.toggle(CompoundButton.java:87) at android.widget.CompoundButton.performClick(CompoundButton.java:99) at android.view.View$PerformClick.run(View.java:17355) at android.os.Handler.handleCallback(Handler.java:725) at android.os.Handler.dispatchMessage(Handler.java:92) at android.os.Looper.loop(Looper.java:137) at android.app.ActivityThread.main(ActivityThread.java:5041) at java.lang.reflect.Method.invokeNative(Native Method) at java.lang.reflect.Method.invoke(Method.java:511) at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:793) at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:560) at dalvik.system.NativeStart.main(Native Method)
The Update function is given below
public int setStatus(){ SQLiteDatabase sqldb = this.getWritableDatabase(); String status_change_query = "UPDATE " + DB_Table1 + " SET " + Status_Msg + " = 0 where " + Status_Msg + " = 1"; Cursor cursor = sqldb.rawQuery(status_change_query,null); cursor.close(); System.out.println(""+ Status_Msg); sqldb.close(); return Status_Msg; }
解决方案String status_change_query = "UPDATE " + DB_Table1 + " SET " + Status_Msg + " = 0 where " + Status_Msg + " = 1";
gives
UPDATE sms_tbl SET 1 = 0 where 1 = 1 at
In other words, you seem to have simply mixed up your variables.
Status_Msg
should be your column name but it seems to instead be a numeric value, and the resulting query is invalid SQL.这篇关于如何解决在SQLite数据库更新查询语法错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文