【www.bbyears.com--php常用代码】
Android sd卡读取数据库实例代码
前言:
本文主要给大家讲解如何利用Android SD卡读取数据库,提供一些代码如下。先在 Manifest 里添加权限:
代码如下然后在 mainActivity 添加方法
代码如下SQLiteDatabase db;
privatefinalString DATABASE_PATH = android.os.Environment
.getExternalStorageDirectory().getAbsolutePath() +"/vote";
privateString DATABASE_FILENAME ="db_vote.db";
// 初始化数据库
privateSQLiteDatabase openDatabase() {
try{
String databaseFilename = DATABASE_PATH +"/"+ DATABASE_FILENAME;
File dir =newFile(DATABASE_PATH);
if(!dir.exists())
dir.mkdir();
if(!(newFile(databaseFilename)).exists()) {
InputStream is = getResources().openRawResource(R.raw.db_vote);
FileOutputStream fos =newFileOutputStream(databaseFilename);
byte[] buffer =newbyte[8192];
intcount =0;
while((count = is.read(buffer)) >0) {
fos.write(buffer,0, count);
}
fos.close();
is.close();
}
db = SQLiteDatabase.openOrCreateDatabase(databaseFilename,null);
returndb;
}catch(Exception e) {
e.printStackTrace();
}
returnnull;
}