android sd卡数据库读取

最新推荐文章于 2021-02-06 12:49:41 发布

weixin_34234823

最新推荐文章于 2021-02-06 12:49:41 发布

阅读量93

点赞数

文章标签：移动开发数据库 python

原文链接：https://my.oschina.net/oldfeel/blog/53859

版权

2019独角兽企业重金招聘Python工程师标准>>>

先在 Manifest 里添加权限

<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />

<uses-permission android:name="android.permission.MOUNT_UNMOUNT_FILESYSTEMS" />

然后在 mainActivity 添加方法

SQLiteDatabase db;
	private final String DATABASE_PATH = android.os.Environment
			.getExternalStorageDirectory().getAbsolutePath() + "/vote";
	private String DATABASE_FILENAME = "db_vote.db";


// 初始化数据库
	private SQLiteDatabase openDatabase() {
		try {
			String databaseFilename = DATABASE_PATH + "/" + DATABASE_FILENAME;
			File dir = new File(DATABASE_PATH);
			if (!dir.exists())
				dir.mkdirs();
			if (!(new File(databaseFilename)).exists()) {
				InputStream is = getResources().openRawResource(R.raw.db_vote);
				FileOutputStream fos = new FileOutputStream(databaseFilename);
				byte[] buffer = new byte[8192];
				int count = 0;
				while ((count = is.read(buffer)) > 0) {
					fos.write(buffer, 0, count);
				}
				fos.close();
				is.close();
			}
			db = SQLiteDatabase.openOrCreateDatabase(databaseFilename, null);
			return db;
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}

转载于:https://my.oschina.net/oldfeel/blog/53859