sqlite存mp3

Step-1: 首先將.mp3檔案放入Project的/res/raw/裡，如下：
 
      
 
       程式一開始執行，建立一個資料庫，含有BLOB欄位，如下之指令：
 
     sql = "create table mySong("
            + "song_no text not null, "
            + "song_mp3 blob );";
         try {
            db.execSQL(sql);
         } catch (SQLException e) {
            Log.e("ERROR", e.toString());
            return;
        }
 
Step-2: 從Project的/res/raw/讀取*.mp3歌曲，然後分段儲存到SQLite的BLOB裡，如下之指令：
 
  InputStream is = getResources().openRawResource(rid);
  int bufSize = 63*1024;
  byte[] buffer  = new byte[bufSize];
  try {
          int size = is.read(buffer);
          while(size >= 0){
     ByteArrayOutputStream out = new ByteArrayOutputStream(size);
               out.write(buffer, 0, size);
               out.flush();
          out.close();
          cv.put("song_mp3", out.toByteArray());
          db.insert("mySong", null, cv);
          size = is