Android真机不能写入MySQL_在写Android用户界面的时候无法对数据库进行读写,可是SQL语句并没有写错是什么原因?...

博主在开发Android应用时遇到问题,应用在尝试写入SQLite数据库时会崩溃。问题表现为点击注册按钮添加数据时应用自动关闭,仅在模拟器root后才能查看到数据库文件,但文件显示为乱码。错误日志显示与输入流读取错误相关,同时在尝试创建表格时出现SQL语法错误。
摘要由CSDN通过智能技术生成

我在写Android用户界面的时候无法对数据库进行读写,每次点击注册按钮添加数据的时候应用都会自动关闭,只有应用运行之后root一下模拟器才可以看到数据库文件,但是数据库文件下载下来打开是乱码,无法辨别。我尝试运行过不同需要操作数据库的项目都是报的类似错误,还请各位大佬看看有啥办法?下面是错误信息

10-31 12:55:13.685 2098-2876/? W/ErrorProcessor: onFatalError, processing error from engine(4)

com.google.android.apps.gsa.shared.speech.a.g: Error reading from input stream

at com.google.android.apps.gsa.staticplugins.recognizer.i.a.a(SourceFile:342)

at com.google.android.apps.gsa.staticplugins.recognizer.i.a$1.run(SourceFile:1367)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:428)

at java.util.concurrent.FutureTask.run(FutureTask.java:237)

at com.google.android.apps.gsa.shared.util.concurrent.a.ak.run(SourceFile:66)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607)

at java.lang.Thread.run(Thread.java:761)

at com.google.android.apps.gsa.shared.util.concurrent.a.ad$1.run(SourceFile:85)

Caused by: com.google.android.apps.gsa.shared.exception.GsaIOException: Error code: 393238 | Buffer overflow, no available space.

at com.google.android.apps.gsa.speech.audio.Tee.g(SourceFile:2531)

at com.google.android.apps.gsa.speech.audio.ap.read(SourceFile:555)

at java.io.InputStream.read(InputStream.java:101)

at com.google.android.apps.gsa.speech.audio.al.run(SourceFile:362)

at com.google.android.apps.gsa.speech.audio.ak$1.run(SourceFile:471)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:428)

at java.util.concurrent.FutureTask.run(FutureTask.java:237)

at com.google.android.apps.gsa.shared.util.concurrent.a.ak.run(SourceFile:66)

at com.google.android.apps.gsa.shared.util.concurrent.a.ax.run(SourceFile:139)

at com.google.android.apps.gsa.shared.util.concurrent.a.ax.run(SourceFile:139)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1133)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:607)

at java.lang.Thread.run(Thread.java:761)

at com.google.android.apps.gsa.shared.util.concurrent.a.ad$1.run(SourceFile:85)

10-31 12:55:56.287 2912-2912/? E/AndroidRuntime: FATAL EXCEPTION: main

Process: com.demo.sqllite2, PID: 2912

android.database.sqlite.SQLiteException: near "tableUsers": syntax error (code 1): , while compiling: Create tableUsers (_id integer primary key autoincrement,username text,userpassword text);

at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)

at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)

at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)

at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)

at android.database.sqlite.SQLiteProgram.(SQLiteProgram.java:58)

at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)

at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1677)

at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1608)

at com.demo.sqllite2.dbHelper.onCreate(dbHelper.java:30)

at android.database.sqlite.SQLiteOpenHelper.getDatabaseLocked(SQLiteOpenHelper.java:251)

at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:163)

at com.demo.sqllite2.dbHelper.insert(dbHelper.java:42)

at com.demo.sqllite2.ManagerUser.createAccount(ManagerUser.java:63)

at com.demo.sqllite2.ManagerUser.access$000(ManagerUser.java:13)

at com.demo.sqllite2.ManagerUser$1.onClick(ManagerUser.java:38)

at android.view.View.performClick(View.java:5637)

at android.view.View$PerformClick.run(View.java:22429)

at android.os.Handler.handleCallback(Handler.java:751)

at android.os.Handler.dispatchMessage(Handler.java:95)

at android.os.Looper.loop(Looper.java:154)

at android.app.ActivityThread.main(ActivityThread.java:6119)

at java.lang.reflect.Method.invoke(Native Method)

at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)

at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值