1. Create folder for your project: my_sqlite_project


2. Open folder and create file load.bat and paste to load.bat this text and save to project folder:
   

   
   
   
   sqlite3 my_database.s3db < load_text.sql
   
   pause
   
   
   
   




3. Create load_text.sql file and paste this text and save to project folder:
   

   
   CREATE TABLE [android_metadata] (
   
   [locale] TEXT
   
   );
   
   
   
   
   
   
   
   
   
   CREATE TABLE [my_table] (
   
   [_id] int NULL,
   
   [word] VARCHAR(255)  NULL,
   
   [description] VARCHAR(255)  NULL
   
   
   
   
   
   
   
   
   
   .separator ";"
   
   .import text_file.txt my_table
   
   
   
   



4. Create text_file.txt and paste this text and save it as UTF-8:
   

   
   1;word1;my first word
   
   2;word2; my second word 
   
   

   
   



5. Download sqlite3.exe and put to project folder.


6. Run BAT file load.bat and read text instruction from console


7. If database created you can open and edit this with sqlite database explorer


8. Copy database to Asses Android project folder


9. If you want using this database in Android application on device, you have to copy this database to folder on device /data/data/com.MyPackage/databases/

 C:\Program Files\Java\jdk1.8.0_05

// starts activity
15:27:12.801: INFO/onCreate(1828): onCreate()
15:27:12.811: INFO/onStart(1828): onStart()
15:27:12.821: INFO/onResume(1828): onResume()
// activity is running 

15:27:33.651: DEBUG/dalvikvm(307): GC_EXPLICIT freed 186K, 53% 
free 2770K/5831K, external 981K/1038K, paused 99ms

// change emulator state Ctrl+F11 landscape, portrait
15:27:40.427: INFO/ActivityManager(74): Config changed: 
{ scale=1.0 imsi=310/260 loc=en_US touch=3 keys=2/1/2 nav=3/1 orien=2 layout=18 uiMode=17 seq=64}

// saved all variable values if need
15:27:40.581: INFO/onSaveInstanceState(1828): onSaveInstanceState()

15:27:40.602: INFO/onPause(1828): onPause()
15:27:40.612: INFO/onStop(1828): onStop()
15:27:40.631: INFO/onDestroy(1828): onDestroy()

// activity goes back to onCreate !!!!!!!!!
15:27:40.692: INFO/onCreate(1828): onCreate()
15:27:40.701: INFO/onStart(1828): onStart()

// restore all saved values of variables 
15:27:40.711: INFO/onRestoreInstanceState(1828): onRestoreInstanceState()
// you can using saved values by onSaveInstanceState() in onResume
15:27:40.721: INFO/onResume(1828): onResume()

import java.util.HashSet;
import java.util.Iterator;
import java.util.Map;
import java.util.Map.Entry;
import java.util.Set;
import java.util.TreeMap;

public class MainClass {
	public static void main(String[] arg) {

		// english;germany dictionary
		String[] arrayOfString = { "one;eine", "two;zwei", "two sets of;zwei"
				, "three;drei", "four;vier" };

		Map<String, String> map = new TreeMap<String, String>();

		for (String s : arrayOfString) {
			String[] array = s.split(";");
			String sKey = "", sValue = "";
			if (array.length > 1) {
				sKey = array[0];
				sValue = array[1];
				map.put(sKey, sValue);
			}
		}

		if (map.containsValue("zwei")) {
			Set<String> references = getKeysByValue(map, "zwei");
			 Iterator<String> it = references.iterator();
			    while (it.hasNext()) {
			      String key = (String) it.next();
			      String value = map.get(key);
			      System.out.println(key + " = " + value);
			    }
		}

	}

	public static <T, E> Set<T> getKeysByValue(Map<T, E> map, E value) {
		Set<T> keys = new HashSet<T>();
		for (Entry<T, E> entry : map.entrySet()) {
			if (entry.getValue().equals(value)) {
				keys.add(entry.getKey());
			}
		}
		return keys;
	}
}
/*
two = zwei
two sets of = zwei
 */