While cycle loop in Java example

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/

// Context instead Activity as a parameter
@Override
public void onAttach(Context context) {
    super.onAttach(context);

    Activity a;

    if (context instanceof Activity){
        a=(Activity) context;
    }

}

OnNoteClickedListener listener;
/* old emxample of usage
	@Override
	public void onAttach(Activity activity) {
		super.onAttach(activity);
		try {
			listener = (OnNoteClickedListener) activity;
		} catch (ClassCastException e) {
			throw new ClassCastException(activity.toString()
					+ " must implement OnNoteClickedListener");
		}
	}
*/
// new version of code
	@Override
	public void onAttach(Context context) {
		super.onAttach(context);

		Activity a;

		if (context instanceof Activity){
			a=(Activity) context;
			try {
				listener = (OnNoteClickedListener) a;
			} catch (ClassCastException e) {
				throw new ClassCastException(a.toString()
						+ " must implement OnNoteClickedListener");
			}
		}

	}

android:contentDescription="@string/desc"

            <ImageView
                android:id="@+id/imageViewOil"
                android:layout_width="wrap_content"
                android:layout_height="wrap_content"
            android:contentDescription="@string/desc"
                android:layout_alignParentLeft="true"
                android:layout_centerVertical="true"
                android:layout_marginLeft="84dp"
                android:src="@drawable/tank_silver" />

Window>Preference>Java>Editor>Typing and check the "Escape text when pasting into a string literal".

1. Go to Eclipse menu Window -> Preferences


2. Doubleclick on Java


3. Double click on Editor


4. Select Java, Javadocs or Comments and setup color and font


5. Font size and family change from Window->Preferences-> General->Appearance->Colors and Fonts



6. Press OK for saving changes