SqliteDataBaseHelper.java

package org.android.textbook.lesson5.sqlite;

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

public class SqliteDataBaseHelper extends SQLiteOpenHelper {

    private static final String DB_FILE_NAME = "SqliteSample";

    public static final String DB_TABLE = "DataBaseTable";

    private static final int DB_VERSION = 1;

    public static final String DB_COLUMN_ID = "_id";
    public static final String DB_COLUMN_NAME = "Name";
    public static final String DB_COLUMN_JAPANESE = "Japanease";
    public static final String DB_COLUMN_ENGLISH = "English";
    public static final String DB_COLUMN_MATH = "Math";

    public SqliteDataBaseHelper(Context context) {
        super(context, DB_FILE_NAME, null, DB_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        String sql = "";
        sql += "create table " + DB_TABLE + " ( ";
        sql += DB_COLUMN_ID + " integer primary key autoincrement,";
        sql += DB_COLUMN_NAME + " text not null,";
        sql += DB_COLUMN_ENGLISH + " integer,";
        sql += DB_COLUMN_JAPANESE + " integer,";
        sql += DB_COLUMN_MATH + " integer";
        sql += ")";
        db.execSQL(sql);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub

    }

}