Proud to mention that this is a series of Tutorials for ANDROID SQLite for Offline database. This series contains 8 tutorials with step-by-step instructions on how to develop your offline database facility in an Android app. Android SQLite Offline Tutorials:
Online Database with JSON – PHP & MYSQL |
SQLite in Android - Open Source Database which is into Android. It supports standard relational database features like SQL syntax, CREATE, INSERT, SELECT etc…
Support these data types;
- TEXT (similar to String in Java),
- INTEGER (similar to long in Java),
- REAL (similar to double in Java).
Database Helper – is a class that will handle the database creation (including populating data if any).
public class MyDBHelperSimple extends SQLiteOpenHelper {
final protected static String DATABASE_NAME="kamus";
public MyDBHelperSimple(Context context) {
super(context, DATABASE_NAME, null,1);
}
@Override
public void onCreate(SQLiteDatabase db) {
//here is the database definition
//or some data to insert
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
if (oldVersion >= newVersion) return;
//do something if database is updated
}
To CREATE table
//CREATE TABLE melayuenglish (katamelayu TEXT, kataeng TEXT);
db.execSQL("CREATE TABLE melayuenglish (katamelayu TEXT, kataeng TEXT);");
To INSERT a record
//INSERT INTO orang (nama, jantina, negeri)
VALUES(‘Khirulnizam', ‘lelaki‘, ‘Negeri Sembilan’);
db.execSQL("INSERT INTO orang (nama, jantina, negeri) VALUES(‘Khirulnizam', ‘lelaki‘, ‘Negeri Sembilan’);");
Check existence of database - from an Android emulator you may use the DDMS. Provided the emulator is running, and the app containing the database has been installed.
DDMS--> file explorer-->data--> data--> your package name-->databases
Comments
Post a Comment