package com.w3cnet.db; import android.content.Context; import android.content.ContentValues; import android.database.sqlite.SQLiteDatabase; import android.database.sqlite.SQLiteOpenHelper; import android.database.Cursor; public class SqliteHelper extends SQLiteOpenHelper{ private final static String DATABASE_NAME = "db_name"; private final static int DATABASE_VERSION = 1; private final static String TABLE_NAME = "mytable"; private final static String FIELD_ID = "ID"; private final static String FIELD_NAME = "NAME"; public SqliteHelper(Context context) { super(context, DATABASE_NAME, null, DATABASE_VERSION); } @Override public void onCreate(SQLiteDatabase db) { String sql = "Create table %s (%s integer primary key autoincrement,%s text);"; sql = String.format(sql, TABLE_NAME, FIELD_ID, FIELD_NAME); db.execSQL(sql); } @Override […]
View Details