連線資料庫SQLite建立資料表的最基本程式碼: SQLite-MyDBHelper extends SQLiteOpenHelper


注意：整個事件程式碼都必須放在
onCreate() 
{  
}
下面
..........................

範例：


import android.view.*;
import android.widget.*;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

 
    private SQLiteDatabase db;
    private MyDBHelper dbHelper;
    private static String DATABASE_TABLE = "資料表名稱";
    // Button元件的事件處理
    public void button1_Click(View view) {
    	dbHelper = new MyDBHelper(this);
        db = dbHelper.getWritableDatabase();
      
    }//end of button1_Click()
	
//連線資料庫SQLite，新增資料表	
	public class MyDBHelper extends SQLiteOpenHelper {
		private static final String DATABASE_NAME = "資料庫名稱";
		private static final int DATABASE_VERSION = 1;
		
		public MyDBHelper(Context context) {
			super(context, DATABASE_NAME, null, DATABASE_VERSION);
		}
		@Override
		public void onCreate(SQLiteDatabase db) {			
			//新增資料表
			//資料表名稱與欄位名稱，不要用中文名稱
			db.execSQL("CREATE TABLE " + DATABASE_TABLE + " (_id integer primary key autoincrement, "
			           + "name text no null, price real no null, num real no null)");
		}
		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE );
	        onCreate(db);
		}
	} //end of MyDBHelper extends SQLiteOpenHelper ()