Android Sqlite数据库的升级(一)

Android Sqlite数据库的升级——加字段

参考博客:http://blog.sina.com.cn/s/blog_6400e5c50101mgu4.html

package com.db.demo;

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

public class MyDBHelper extends SQLiteOpenHelper{
	private static final String TAG = MyDBHelper.class.getName();
	private static final String DB_TABLE = "table_A";//表名
	private static int DB_VERSION = 2;//数据库版本号(亦可使用常量)
	public static final String COLUMN_NAME = "name";//名称
	public static final String COLUMN_DES = "des";//描述
	public static final String COLUMN_TYPE = "data1";//新增字段

	private final String CREATE_TABLE_SQL = "create table if