您现在的位置: 精品资料网 >> 管理信息化 >> 数据仓 >> 资料信息

如何通过contentprovider构建媒体文件数据库(doc 7页)

所属分类:
数据仓
文件大小:
195 KB
下载地址:
相关资料:
content,provide,媒体,文件数据,数据库
如何通过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" +
  ");");
..............................