package com.sunvote.xpadapp.db;


import android.app.Activity;
import android.content.Context;
import android.database.sqlite.SQLiteDatabase;

import com.sunvote.util.LogUtil;

import java.io.File;

public class DBHelper {
	// 得到SD卡路径
	private final String DATABASE_PATH = android.os.Environment.getExternalStorageDirectory().getAbsolutePath();
			
	private final Activity activity;

	private final String DATABASE_FILENAME;

	private int mId;
	public DBHelper(Context context,int meetingId) {

		mId = meetingId;
		DATABASE_FILENAME = "Meeting.db";
		activity = (Activity) context;
	}

	// 得到操作数据库的对象
	public SQLiteDatabase openDatabase(int confId) {
		try {
			boolean b = false;
			mId = confId;
			if(confId == 0){
				LogUtil.e("DBHelper", "openDatabase with Error confid 0");
				return null;
			}
			// 得到数据库的完整路径名
			String databaseFilename = DATABASE_PATH + "/sunvote/"+ mId + "/" + DATABASE_FILENAME;
			if (!(new File(databaseFilename)).exists()) {
				LogUtil.e("DBHelper", "db not exists");
			}
			SQLiteDatabase database = SQLiteDatabase.openOrCreateDatabase(databaseFilename, null);
			return database;
		} catch (Exception e) {
			System.out.println(e.getMessage());
		}
		return null;
	}
}