package com.example.dbtest;import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;public class DatabaseHelper extends SQLiteOpenHelper {
private final String TAG = "DatabaseHelper";
private static final String DATABASE_NAME = "db";
private static final String TABLE_NAME = "contacts";
private static final String COLUMN_ID = "_id";
private static final String COLUMN_QUESTION = "question";
private static final String COLUMN_G1 = "g1";
private static final String COLUMN_G2 = "g2";
private static final String COLUMN_G3 = "g3";
private static final String COLUMN_G4 = "g4";
private static final String CREATE_TABLE = "CREATE_TABLE" + TABLE_NAME + "(" +
COLUMN_ID + "INTEGER PRIMARY KEY AUTOINCREMENT," +
COLUMN_QUESTION + "TEXT," +
COLUMN_G1 + "TEXT," + COLUMN_G2 + "TEXT," +
COLUMN_G3 + "TEXT," + COLUMN_G4 + "TEXT" + "):"; public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, 1);
// TODO Auto-generated constructor stub
Log.i(TAG, "Object created.");
} @Override
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(CREATE_TABLE);
} @Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// TODO Auto-generated method stub
db.execSQL("Drop table if exists + TABLE_NAME");
onCreate(db);
}
public String getTableName(){
return TABLE_NAME;
}
public String getRowIdName(){
return COLUMN_ID;
}
}
package com.example.dbtest;import android.content.ContentValues;
import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.util.Log;public class DatabaseHandler {
private final String TAG = "DatabaseHandler";
static final String QUESTION = "question";
static final String G1 = "g1";
static final String G2 = "g2";
static final String G3 = "g3";
static final String G4 = "g4";
private DatabaseHelper dbHelper;
private SQLiteDatabase database;
public DatabaseHandler (Context context){
dbHelper = new DatabaseHelper (context);
Log.i(TAG, "Object create.");
}
public void open() throws SQLException {
database = dbHelper.getWritableDatabase();
}
public void close(){
dbHelper.close();
}
public void insertContact (){
}}
