public class DataBaseAdapter {
....
private DataBaseHelper mDBHelper;
private SQLiteDatabase mDB;
private static final String DB_CREATE = "create table userinfo (id integer primary key autoincrement,"
+ "name text not null, sex text, year Integer, height Integer, weight Integer, loss_weight Integer, avg_weight Integer, bm Integer, bmi Integer);";
private static final String DATABASE_NAME = "checkmybody.db";
private static final String DATABASE_TABLE = "userinfo";
private static final int DATABASE_VERSION = 1;
private final Context mContext;
private class DataBaseHelper extends SQLiteOpenHelper {
public DataBaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(DB_CREATE);
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE);
onCreate(db);
}
}
public DataBaseAdapter(Context context) {
mContext = context;
}
public DataBaseAdapter open() throws SQLException {
mDBHelper = new DataBaseHelper(mContext);
mDB = mDBHelper.getWritableDatabase();
return this;
}
public void close() {
mDBHelper.close();
}
public void dropTable() {
mDB.execSQL("DROP TABLE IF EXISTS " + DATABASE_TABLE+";");
}
public long insertUserInfo(String name, String sex, float year,
float height, float weight, float lossWeihgt, float avgWeight,
float BM, float BMI) {
ContentValues initialValues = new ContentValues();
initialValues.put(KEY_NAME, name);
initialValues.put(KEY_SEX, sex);
initialValues.put(KEY_YEAR, year);
initialValues.put(KEY_HEIGHT, height);
initialValues.put(KEY_WEIHGT, weight);
initialValues.put(KEY_LOSS_WEIGHT, lossWeihgt);
initialValues.put(KEY_AVG_WEIGHT, avgWeight);
initialValues.put(KEY_BM, BM);
initialValues.put(KEY_BMI, BMI);
return mDB.insert(DATABASE_TABLE, null, initialValues);
}
...
}
