Android database (p1)- Intro SQLite DB

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: Introduction to SQLite in Android apps – with DBHelper (this article)http://blog.kerul.net/2013/08/android-database-p1-intro-sqlite-db.html Doing simple SEARCH in the database - http://blog.kerul.net/2013/08/android-database-p2-search-example.html Inserting a new record into an existing database - http://blog.kerul.net/2013/09/android-database-p3-insert-record.html Populating records in a ListView - http://blog.kerul.net/2015/07/populate-records-in-listview-android.html Clicking an Item inside a ListView to view complete data of a selected record - http://blog.kerul.net/2015/07/view-complete-record-from-listview.html Long-click an Item inside ListView to update a record - http://blog.kerul.net/2015/07/update-record-by-long-press-listview.html Adding a new record to a table - http://blog.kerul.net/2015/07/add-new-record-android-database-sqlite.html Long-click to select a new record to be deleted - http://blog.kerul.net/2015/07/delete-record-from-listviewandroid.html   Online Database with JSON – PHP & MYSQL Android DB JSON - Insert Android DB JSON - Search

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