java - 将数据插入DB android时出错
问题描述
我在数据库中有两个表,条目只有列词,另一个表 worddictionary 有列词、定义和 auduiourl,
String create_table_query = "CREATE TABLE `entries` (`word` varchar(50) NOT NULL)";
db.execSQL(create_table_query);
String create_word_table = "CREATE TABLE `worddictionary` (`word` TEXT NOT NULL,'definition' TEXT, 'audiourl' TEXT)";
db.execSQL(create_word_table);
我正在尝试将使用网络抓取获得的单词、其定义和 audiourl 插入 worddictionary 表中,
String insert_query = "INSERT INTO worddictionary values("+word+","+wordDefinition+","+audioUrl+")";
db.execSQL(insert_query);
但我得到以下错误,
2020-07-13 14:11:56.527 27078-27131/com.example.scraping_synonyms E/SQLiteLog: (1) near "large": syntax error
2020-07-13 14:11:56.529 27078-27131/com.example.scraping_synonyms E/AndroidRuntime: FATAL EXCEPTION: AsyncTask #1
Process: com.example.scraping_synonyms, PID: 27078
java.lang.RuntimeException: An error occurred while executing doInBackground()
at android.os.AsyncTask$3.done(AsyncTask.java:354)
at java.util.concurrent.FutureTask.finishCompletion(FutureTask.java:383)
at java.util.concurrent.FutureTask.setException(FutureTask.java:252)
at java.util.concurrent.FutureTask.run(FutureTask.java:271)
at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:245)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1167)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:641)
at java.lang.Thread.run(Thread.java:764)
Caused by: android.database.sqlite.SQLiteException: near "large": syntax error (code 1 SQLITE_ERROR): , while compiling: INSERT INTO worddictionary values(aardvark,noun,
a large, nocturnal, burrowing mammal, Orycteropus afer, of central and southern Africa, feeding on ants and termites and having a long, extensile tongue, strong claws, and long ears.
,https://static.sfdict.com/audio/A00/A0001900.mp3)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:903)
at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:514)
at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.executeSql(SQLiteDatabase.java:1770)
at android.database.sqlite.SQLiteDatabase.execSQL(SQLiteDatabase.java:1698)
at com.example.scraping_synonyms.MainActivity$Content.doInBackground(MainActivity.java:140)
at com.example.scraping_synonyms.MainActivity$Content.doInBackground(MainActivity.java:74)
at android.os.AsyncTask$2.call(AsyncTask.java:333)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
在这个错误中,在“大”附近提到了错误,即定义中的词我不明白错误是什么
解决方案
这可能是因为周围的标记word
不同definition
吗?
我替换的那个人使用了 Content 值,所以对你来说它是
ContentValues values = new ContentValues();
values.put("word", word);
values.put("definition", definition);
values.put("audiourl", audiourl);
db.insert("worddictionary", null, values);
推荐阅读
- scala - 部分函数应用后对特定集合的泛型
- mongodb - 如何在快速应用程序中使用 mongoose for mongoDB 验证密码以登录用户?
- reactjs - Jest/Storyshots 测试我的组件中的响应式元素
- python - 如何仅沿数据框的选定列进行推断?
- android - Android键盘上的下一步按钮未提交表单
- azure - 如何测试 Azure 函数可扩展性?
- excel - 尝试递增 1 时值未更新
- javascript - 将数据从一个组件发送到另一个 Vuejs
- python - 有没有办法在 python 中更改用户的输入?
- java - 当我单击 JButton 以使其加倍输出时如何制作。例如,我单击 jButton 一次,但我想输出 2