Java
String createTableQuery = "CREATE TABLE users (id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, age INTEGER);";
sqLiteDatabase.execSQL(createTableQuery);
String insertDataQuery = "INSERT INTO users (name, age) VALUES ('John Doe', 25);";
sqLiteDatabase.execSQL(insertDataQuery);
Java
@Entity(tableName = "users")
public class User {
@PrimaryKey(autoGenerate = true)
public int id;
public String name;
public int age;
}
@Database(entities = {User.class}, version = 1)
public abstract class AppDatabase extends RoomDatabase {
public abstract UserDao userDao();
}
AppDatabase db = Room.databaseBuilder(getApplicationContext(), AppDatabase.class, "my-database").build();
User user = new User();
user.name = "John Doe";
user.age = 25;
db.userDao().insert(user);
Java
@Entity
public class User {
@Id(autoincrement = true)
private Long id;
private String name;
private int age;
// ... getters and setters
}
DaoMaster.DevOpenHelper helper = new DaoMaster.DevOpenHelper(this, "my-database");
Database db = helper.getWritableDb();
DaoSession daoSession = new DaoMaster(db).newSession();
UserDao userDao = daoSession.getUserDao();
User user = new User();
user.setName("John Doe");
user.setAge(25);
userDao.insert(user);
<uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />
<uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />
gradle
implementation 'androidx.room:room-runtime:2.3.0'
annotationProcessor 'androidx.room:room-compiler:2.3.0'
gradle
implementation 'org.greenrobot:greendao:3.3.0'
