Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- db = new Database(this);
- public class Database extends SQLiteOpenHelper {
- public static final String DATABASE_NAME = "days.db";
- public static final String TABLE_NAME = "days";
- public static final String COLUMN_1 = "date";
- public static final String COLUMN_2 = "blob";
- private Context context;
- public Database(Context context) {
- super(context, DATABASE_NAME, null, 1);
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- db.execSQL("create table IF NOT EXISTS " + TABLE_NAME + " (" + COLUMN_1 + " TEXT, " + COLUMN_2 + " BLOB)");
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- onCreate(db);
- }
- }
- public class Database extends SQLiteOpenHelper {
- private Context context1;
- public Database(Context context) {
- super(context, "CREATECONTACT", null, 1);
- this.context1 = context;
- }
- @Override
- public void onCreate(SQLiteDatabase db) {
- String query = "CREATE TABLE createContact ( n" +
- " ID INTEGER PRIMARY KEY AUTOINCREMENTn" +
- " NOT NULLn" +
- " UNIQUE,n" +
- " Name VARCHAR( 50 ) NOT NULL,n" +
- " Phone VARCHAR NOT NULL,n" +
- " typeofPhone VARCHAR NOT NULL,n" +
- " Email VARCHAR NOT NULL,n" +
- " typeofEmail VARCHAR NOT NULL,n" +
- " FAVE VARCHAR NOT NULL,n" +
- " RED INTEGER,n" +
- " GREEN INTEGER,n" +
- " BLUE INTEGER n" +
- ");n";
- db.execSQL(query);
- }
- @Override
- public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
- db.execSQL("DROP TABLE IF EXISTS createContact");
- onCreate(db);
- }
Add Comment
Please, Sign In to add comment