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