default:
break;
}
}
}
}
其中的SQL的建表语句为:
public class SQL {
public static final String T_FAVORITE = “favorite”;
public static final String CREATE_TABLE_FAVORITE =
"CREATE TABLE IF NOT EXISTS " + T_FAVORITE + “(” +
"id VARCHAR PRIMARY KEY, " +
"title VARCHAR, " +
"url VARCHAR, " +
"createDate VARCHAR " +
“)”;
}
(2)v2.0:DATABASE_VERSION=1001,在favorite表添加1个deleted字段
public class DBHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = “mall.db”;
private static final int DATABASE_VERSION = 1001;
private static DBHelper instance = null;
public DBHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
pub