package com.tonypan.databasetest;

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

public class MyDatabaseHelper extends SQLiteOpenHelper{

	public static final String CREATE_BOOK = "create table Book ("
										  + "id integer primary key autoincrement, "
										  + "author text, "
										  + "price real, "
										  + "pages integer, "
										  + "name text,"
										  + "category_id integer)";
	
	public static final String CREATE_CATEGORY = "create table Category("
											   + "id integer primary key autoincrement, "
											   + "category_name text, "
											   + "category_code integer )";
	
	private Context mContext;
	
	public MyDatabaseHelper(Context context, String name, CursorFactory factory, int version) {
		super(context, name, factory, version);
		mContext = context;
	}

	@Override
	public void onCreate(SQLiteDatabase db) {
		db.execSQL(CREATE_BOOK);
		db.execSQL(CREATE_CATEGORY);
		//¿ç³ÌÐò·ÃÎÊµÄÊ±ºò²»ÄÜÊ¹ÓÃToastµ¯³öÏûÏ¢£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿£¿
		//Toast.makeText(mContext, "´´½¨Êý¾Ý¿â³É¹¦", Toast.LENGTH_SHORT).show();
	}

	@Override
	public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
		//ÅÐ¶Ï°æ±¾½øÐÐÏàÓ¦µÄÉý¼¶²Ù×÷
		switch (oldVersion) {
		case 1:
			db.execSQL(CREATE_CATEGORY);
		case 2:
			db.execSQL("alter table Book add column category_id integer");
		//Ã¿¸öcase¶¼Ã»ÓÐ¼Óbreak£¬ÕâÑù±£Ö¤¿ç°æ±¾Éý¼¶µÄÊ±ºòÃ¿¸öcase¶¼ÄÜµÃµ½Ö´ÐÐ
		default:
		}
	}

}
