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