Sqlite create database and table with BAT file for Android

AD MOB

Sqlite3 create database and table with load.bat file and fill data to table example.

Create folder for your project: my_sqlite_project

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
```

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

Create text_file.txt and paste this text and save it as UTF-8:
```
1;word1;my first word

2;word2; my second word 
```

Download sqlite3.exe and put to project folder.

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

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

Copy database to Asses Android project folder

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/

397LW NO topic_id

Další témata ....(Topics)

Number convert int to string Java Android example code | number

Convert number int to string Android Java example source code.


int n = 0;

try {
    n = Integer.parseInt("21"));
} catch(NumberFormatException e) {
   System.out.println("Could not parse " + e);
} 
// int to string
String s = String.valueOf(24);

Android Emulator PC keyboard shortcuts | android-emulator-pc-keyboard-shortcuts

Basic shortcuts for Android Emulator.

Emulated Device Key	Keyboard Key
Home	HOME
Menu (left softkey)	F2 or Page-up button
Star (right softkey)	Shift-F2 or Page Down
Back	ESC
Call/dial button	F3
Hangup/end call button	F4
Search	F5
Power button	F7
Audio volume up button	KEYPAD_PLUS, Ctrl-5
Audio volume down button	KEYPAD_MINUS, Ctrl-F6
Camera button	Ctrl-KEYPAD_5, Ctrl-F3
Switch to previous layout orientation (for example, portrait, landscape)	KEYPAD_7, Ctrl-F11
Switch to next layout orientation (for example, portrait, landscape)	KEYPAD_9, Ctrl-F12
Toggle cell networking on/off	F8
Toggle code profiling	F9 (only with -trace startup option)
Toggle fullscreen mode	Alt-Enter
Toggle trackball mode	F6
Enter trackball mode temporarily (while key is pressed)	Delete
DPad left/up/right/down	KEYPAD_4/8/6/2
DPad center click	KEYPAD_5
Onion alpha increase/decrease	KEYPAD_MULTIPLY(*) / KEYPAD_DIVIDE(/)

More about Android Emulator

156

Convert Drawable to Bitmap to Drawable | converts-drawable-to-bitmap


Context context = getApplicationContext();
Drawable drawable = context.getResources().getDrawable(R.drawable.my_image);
// convert drawable to bitmap
Bitmap bitmap = ((BitmapDrawable)drawable).getBitmap();
// convert bitmap to drawable
Drawable d = new BitmapDrawable(bitmap);

Android example source code.

108

Turn screen ON OFF Android sample code | turn-screen-on-off-android-sample-code

WakeLock, PowerManager,uses-permission Android sample.
Main.java


public class Main extends Activity {
	    private SensorManager mSensorManager;
	    private PowerManager mPowerManager;
	    private WindowManager mWindowManager;
	    private WakeLock mWakeLock;
	    private Button button;
	    private TextView textView;

	    /** Called when the activity is first created. */
	    @Override
	    public void onCreate(Bundle savedInstanceState) {
	        super.onCreate(savedInstanceState);
try{
	        // Get an instance of the SensorManager
	        mSensorManager = (SensorManager) getSystemService(SENSOR_SERVICE);

	        // Get an instance of the PowerManager
	        mPowerManager = (PowerManager) getSystemService(POWER_SERVICE);

	        // Get an instance of the WindowManager
	        mWindowManager = (WindowManager) getSystemService(WINDOW_SERVICE);
	        mWindowManager.getDefaultDisplay();

	        // Create a bright wake lock
	        mWakeLock = mPowerManager.newWakeLock(PowerManager.SCREEN_BRIGHT_WAKE_LOCK, getClass()
	                .getName());

	        setContentView(R.layout.main);
	        textView = (TextView)findViewById(R.id.textView1);
	        button = (Button)findViewById(R.id.button1);
	        button.setOnClickListener(mButtonStopListener);
	       
	        
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			Log.e("onCreate", e.getMessage());
		}
} // END onCreate
	    
	    View.OnClickListener mButtonStopListener = new OnClickListener() {
	    	public void onClick(View v) {
		        try {
					mWakeLock.release();
					textView.setText("mWakeLock.release()");
				} catch (Exception e) {
					// TODO Auto-generated catch block
					e.printStackTrace();
					Log.e("onPause",e.getMessage());
				}
	    	
	    	}
	    };

	    @Override
	    protected void onResume() {
	        super.onResume();
	        /*
	         * when the activity is resumed, we acquire a wake-lock so that the
	         * screen stays on, since the user will likely not be fiddling with the
	         * screen or buttons.
	         */
	        
	        try {
				mWakeLock.acquire();
				textView.setText("mWakeLock.acquire()");
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				Log.e("onResume", e.getMessage());
			}

	    }

	    @Override
	    protected void onPause() {
	        super.onPause();

	        // and release our wake-lock
	        try {
				mWakeLock.release();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
				Log.e("onPause",e.getMessage());
			}
	    }
}

AndroidManifest.xml


<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="//schemas.android.com/apk/res/android"
      package="cz.okhelp.Main"
      android:versionCode="1"
      android:versionName="1.0">
    <uses-sdk android:minSdkVersion="7" />
    <uses-permission android:name="android.permission.HARDWARE_TEST"></uses-permission>
<uses-permission android:name="android.permission.VIBRATE"></uses-permission>

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

    <application android:icon="@drawable/icon" android:label="@string/app_name">
        <activity android:name=".ScreenBrightnessActivity"
                  android:label="@string/app_name">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />
                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>

    </application>
</manifest>

115

Progressbar change background and fore color - Android sample | progressbar-background-and-fore-color-android-sample

MainActivity.java


        ProgressBar mProgressBarScore;
      // onCreate
	mProgressBarScore = (ProgressBar)findViewById(R.id.progressBarScore);
	Resources res = getResources();
	mProgressBarScore.setProgressDrawable(res.getDrawable( R.drawable.my_progress));

res/layout/main.xml


       <ProgressBar
            android:id="@+id/progressBarScore"
            style="?android:attr/progressBarStyleHorizontal"
            android:layout_width="fill_parent"
            android:layout_height="wrap_content" android:max="100"/>

res/drawable/my_progress.xml










    

        

        

                        android:startColor="#FF001A"

                android:centerColor="#ff5a5d5a"

                android:centerY="0.75"

                android:endColor="#FF001A"

                android:angle="270"

        />

    







    

        

            

                                android:startColor="#80ffd300"

                    android:centerColor="#80ffb600"

                    android:centerY="0.75"

                    android:endColor="#a0ffcb00"

                    android:angle="270"

            />

        

    



    android:id="@android:id/progress"

>

    

        

            

                            android:radius="10dip" />

                            android:startColor="#00ff00"

                android:centerColor="#80ffb600"

                android:centerY="0.75"

                android:endColor="#339900"

                android:angle="270" />

Editace: 2011-09-26 20:47:35
Počet článků v kategorii: 397
Url:sqlite-create-database-and-table-with-bat-file

AD