public class DatabaseAdapter {
DatabaseHelper databaseHelper;
public DatabaseAdapter(Context context){
databaseHelper=new DatabaseHelper(context);
}
public long insertData(String name, String pw){
SQLiteDatabase db = databaseHelper.getWritableDatabase();
ContentValues contentValues = new ContentValues();
contentValues.put(DatabaseHelper.NAME, name);
contentValues.put(DatabaseHelper.PASSWORD, pw);
long id=db.insert(DatabaseHelper.TABLE_NAME, null, contentValues);
return id;
}
static class DatabaseHelper extends SQLiteOpenHelper {
private static final String DATABASE_NAME = "MyDatabase";
private static final int DATABASE_VERSION = 1;
private static final String TABLE_NAME = "TestTable";
private static final String UID = "_id";
private static final String NAME = "Name";
private static final String PASSWORD = "Password";
private static final String CREATE_TABLE = "CREATE TABLE " + TABLE_NAME
+ " (" + UID + " INTEGER PRIMARY KEY AUTOINCREMENTED, " + NAME
+ " VARCHAR(255), " + PASSWORD + " VARCHAR(255));";
public DatabaseHelper(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
try {
db.execSQL(CREATE_TABLE);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
} DatabaseAdapter databaseAdapter;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
databaseAdapter = new DatabaseAdapter(this);
long id = databaseAdapter.insertData("user", "1234");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS " + TABLE_NAME + ";");
onCreate(db);
}