如何通过contentprovider构建媒体文件数据库(doc 7页)
如何通过contentprovider构建媒体文件数据库(doc 7页)内容简介
如何通过contentprovider构建媒体文件数据库内容提要:
以Camera的image文件文件为例,数据库在第一次使用的时候被创建,对于image文件,SQL在updateDatabase为其创建一个table:
db.execSQL("CREATE TABLE IF NOT EXISTS images (" +
"_id INTEGER PRIMARY KEY," + //文件保存的序号
"_data TEXT," + //记录image 文件保存路径
"_size INTEGER," + //文件大小
"_display_name TEXT," + //图片名称
"mime_type TEXT," + //文件类型
"title TEXT," +
"date_added INTEGER," +
"date_modified INTEGER," +
"description TEXT," +
"picasa_id TEXT," +
"isprivate INTEGER," +
"latitude DOUBLE," +
"longitude DOUBLE," +
"datetaken INTEGER," +
"orientation INTEGER," +
"mini_thumb_magic INTEGER," +
"bucket_id TEXT," +
"bucket_display_name TEXT" +
");");
..............................
以Camera的image文件文件为例,数据库在第一次使用的时候被创建,对于image文件,SQL在updateDatabase为其创建一个table:
db.execSQL("CREATE TABLE IF NOT EXISTS images (" +
"_id INTEGER PRIMARY KEY," + //文件保存的序号
"_data TEXT," + //记录image 文件保存路径
"_size INTEGER," + //文件大小
"_display_name TEXT," + //图片名称
"mime_type TEXT," + //文件类型
"title TEXT," +
"date_added INTEGER," +
"date_modified INTEGER," +
"description TEXT," +
"picasa_id TEXT," +
"isprivate INTEGER," +
"latitude DOUBLE," +
"longitude DOUBLE," +
"datetaken INTEGER," +
"orientation INTEGER," +
"mini_thumb_magic INTEGER," +
"bucket_id TEXT," +
"bucket_display_name TEXT" +
");");
..............................
用户登陆
数据仓热门资料
数据仓相关下载