我有一个预先填充的SQLite数据库,它有两个表:
表1: AudioSamples (_id文本主键,AudioFile blob),其中_id ->音频文件的名称AudioFile ->音频文件(.PCM文件) 表2:android_metadata(地区文本) 其中的地区-> 'en_US‘
我所做的是:
问题是:
我的音频回放代码在其他pcm文件中运行良好。
插入.pcm文件的代码:
private static void insertFile(char FileName){
String filepath="C:/Documents and Settings/Administrator/Desktop/imp files/"+FileName+".pcm";
try{
PreparedStatement pstmt=c.prepareStatement("insert into AudioSamples values(?,?)");
File f=new File(filepath);
FileInputStream fin=new FileInputStream(f);
byte[] buff=new byte[(int)f.length()];
fin.read(buff);
pstmt.setString(1,String.valueOf(FileName));
pstmt.setBytes(2,buff);
pstmt.executeUpdate();
pstmt.clearParameters();
fin.close();
System.out.println("Inserted file :"+FileName+".pcm size="+(buff.length/1024)+"KB");
}catch(Exception e){
System.err.print("Error :"+e);
}
}在使用代码将表数据放入资产之前,我检查了表数据:
private static void GetTableData(String TableName){
try{
Statement stmt=c.createStatement();
String myquery="select * from "+TableName;
ResultSet rs=stmt.executeQuery(myquery);
while(rs.next()){
System.out.println("For "+rs.getString("_id")+".pcm :");
System.out.println("size="+rs.getBytes(rs.getMetaData().getColumnName(2)).length/1024+"KB");
System.out.println("column1 name:"+rs.getMetaData().getColumnName(1));
System.out.println("column1 type:"+rs.getMetaData().getColumnType(1));
System.out.println("column2 name:"+rs.getMetaData().getColumnName(2));
System.out.println("column2 type:"+rs.getMetaData().getColumnType(2));
}
rs.close();
stmt.close();
}catch(Exception e){
System.err.println("GetTableData()"+e.getMessage());
}
}这给了我预期的日志结果如下:
a.pcm : size=27KB column1 name:_id column1类型:12 column2名称:AudioFile column2类型:2004年
将资产中的数据库文件“AudioData.db”复制到系统数据库的代码:
private void copyDatabase() throws IOException{
//stream to read database in assets folder
InputStream ipstream = myContext.getAssets().open("AudioData.db");
//stream to write to empty database in system folder
FileOutputStream opstream= new FileOutputStream(DB_PATH+DB_NAME);
byte[] buff=new byte[1024*512]; //create 512Kb buffer
int bytesRead=0;
while((bytesRead=ipstream.read(buff))!=(-1)){
opstream.write(buff, 0, bytesRead); //write to empty db in systems folder
}
Log.v(DB_NAME,"Database copied");
//close streams
opstream.flush();
opstream.close();
ipstream.close();
Log.v("myDataBase status",""+(myDataBase!=null));
}下面是我访问pcm文件的代码:
public byte[] getPCMFile(String FileName){
Cursor cursor=null;
byte[] buff = null;
try{
cursor=myDataBase.query("AudioSamples",null,"_id=?",new String[]{FileName},null, null,null);
Log.v("getPCMFile()","Obtained table has Column count="+cursor.getColumnCount());
cursor.moveToFirst();
Log.v(FileName+".pcm", "_id columntype="+cursor.getType(cursor.getColumnIndex("_id")));
Log.v(FileName+".pcm", "AudioFile columntype="+cursor.getType(cursor.getColumnIndex("AudioFile")));
buff=cursor.getBlob(cursor.getColumnIndex("AudioFile"));
Log.v("getPCMFile()","Blob retrived :"+cursor.getString(cursor.getColumnIndex("_id"))+".pcm size="+buff.length);
}catch(Exception e){
Log.e("getPCMFile()","Couldnt read PCM file "+FileName+".pcm", e);
}
cursor.close();
return buff; //return byte array containing pcm samples
}对于getPCMFile('a'),它给我的日志如下:
获得的表有列count=2 AudioFile columntype=3 _id columntype=3 Blob检索:a.pcm size=49046
AudioFile列型应为2004年(对于blob),a.pcm的实际大小为27124,但它正在检索49046 byes。请帮帮我。提前感谢!
发布于 2014-01-23 09:02:43
我认为这在android系统中是不可取的,它可以将你的音频文件存储在数据库中。
并使用安装的assest文件夹来存储音频文件。
将您的音频文件保存在“共享”文件夹中,并将其相关信息保存在数据库中。
希望这有帮助
https://stackoverflow.com/questions/21303336
复制相似问题