想通过查询自己手机的音乐然后存到数据库,可是最后报错了,是怎么回事呢?
这个是数据表
/**
* 表名
*/
public static final String TBL_NAME = "playlistTbl";
/**
* 建表语句
*/
public static final String CREATE_TBL = "create table" + TBL_NAME + "("
+ "_id int," + "id int," + "songName text," + "songSinger text,"
+ "album text," + "albumId long," + "displayName text,"
+ "duration long," + "size long," + "path text" + ")";
public AppDBHelp(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
E/SQLiteLog: (1) no such table: playlistTbl
12-02 15:35:26.101 9191-9328/? E/SQLiteDatabase: Error inserting id=55484 duration=0 albumId=24 _id=180 album=download songSinger= path=/storage/sdcard0/kgmusic/download/张学友 - 沉默的眼睛.ape songName=张学友 - 沉默的眼睛 displayName=张学友 - 沉默的眼睛.ape size=23225879
android.database.sqlite.SQLiteException: no such table: playlistTbl (code 1): , while compiling: INSERT INTO playlistTbl(id,duration,albumId,_id,album,songSinger,path,songName,displayName,size) VALUES (?,?,?,?,?,?,?,?,?,?)
at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.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.(SQLiteProgram.java:58)
at android.database.sqlite.SQLiteStatement.(SQLiteStatement.java:31)
at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1467)
at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1339)
at com.jack.musicandchat.db.AppDB.addSongInfo(AppDB.java:63)
at com.jack.musicandchat.service.ScanService.onHandleIntent(ScanService.java:84)
at android.app.IntentService$ServiceHandler.handleMessage(IntentService.java:65)
at android.os.Handler.dispatchMessage(Handler.java:99)
at android.os.Looper.loop(Looper.java:137)
at android.os.HandlerThread.run(HandlerThread.java:60)
相关阅读:
在接口未开发阶段(已有接口文档)前端有什么调式接口相关代码的好方法吗?
webstrom有px转rem的插件吗
请教去掉默认样式的问题。
php静态缓存和纯静态有哪些区别?
Safari 的 tag 当 src 为空时,却仍然显示之前的图片。
react native 中this.setState无效
(有截图)为什么Mac 下用brew为PHP安装扩展,成功安装后,为啥安装目录找不到.so文件??
capistrano 在部署项目时出现"sorry, you must have a tty to run sudo“怎么处理呢?
后端验证码的值如何和前端进行匹对?
iOS FDTemplateLayoutCell配合Masonry一起去让Cell自适应高度
wordpress如何添加引导页
js或jquery如何获取到某元素周围的元素呢
django orm 出现子查询,如何规避?
Android Studio 和 Eclipse 相对照的快捷键有哪些?
Android怎么保证数据请求与传输安全?在线等...
关于javascript函数和对象的问题?
什么gulp插件可以实现动态修改资源引用?
用Aspects 来hook一个方法的时候,遇到这个方法的参数有block,需要怎么做?
为什么要build path?jar包放在lib目录下,为什么还有build path一下?
elasticsearch的匹配与排序问题