public Statement createConnection() throws IOException{
//		String dbpath = DBSettings.PATH_TO_DB;
//		String fullpath = DBSettings.PATH_TO_DB + DBSettings.DB_NAME;

		String uri = (new File( DBSettings.DB_NAME ).getAbsolutePath());
		
		log(uri);
//		uri = (DbHelper.class.getProtectionDomain().getCodeSource().getLocation().toString() + "res/raw/db/" + DBSettings.DB_NAME).split("file:/")[1];
	
		if (checkFileExists(uri)){
			// create a database connection
			Statement statement = null;
			try {
				Class.forName("org.sqlite.JDBC");
				connection = DriverManager.getConnection("jdbc:sqlite:\\" + uri);
				statement = connection.createStatement();
				// set timeout to 30 sec.
				statement.setQueryTimeout(30); 

			} catch (SQLException e) {
				e.printStackTrace();
			} catch (ClassNotFoundException e) {
				e.printStackTrace();
			}
			return statement;

		}else return null; // return null if file does not exist


	}