Skip to main content

Android database (p1)- Intro SQLite DB


android-sqlite
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:

  1. Introduction to SQLite in Android apps – with DBHelper (this article)http://blog.kerul.net/2013/08/android-database-p1-intro-sqlite-db.html
  2. Doing simple SEARCH in the database - http://blog.kerul.net/2013/08/android-database-p2-search-example.html
  3. Inserting a new record into an existing database - http://blog.kerul.net/2013/09/android-database-p3-insert-record.html
  4. Populating records in a ListView - http://blog.kerul.net/2015/07/populate-records-in-listview-android.html
  5. 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
  6. Long-click an Item inside ListView to update a record - http://blog.kerul.net/2015/07/update-record-by-long-press-listview.html
  7. Adding a new record to a table - http://blog.kerul.net/2015/07/add-new-record-android-database-sqlite.html
  8. 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-json-php-mysql-illustration

  1. Android DB JSON - Insert
  2. 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
view-database-existence-in-android-emulator

Comments

Popular posts from this blog

Several English proverbs and the Malay pair

Or you could download here for the Malay proverbs app – https://play.google.com/store/apps/details?id=net.kerul.peribahasa English proverbs and the Malay pair Corpus Reference: Amir Muslim, 2009. Peribahasa dan ungkapan Inggeris-Melayu. DBP, Kuala Lumpur http://books.google.com.my/books/about/Peribahasa_dan_ungkapan_Inggeris_Melayu.html?id=bgwwQwAACAAJ CTRL+F to search Proverbs in English Definition in English Similar Malay Proverbs Definition in Malay 1 Where there is a country, there are people. A country must have people. Ada air adalah ikan. Ada negeri adalah rakyatnya. 2 Dry bread at home is better than roast meat home's the best hujan emas di negeri orang,hujan batu di negeri sendiri Betapa baik pun tempat orang, baik lagi tempat sendiri. 3 There's no accounting for tastes We can't assume that every people have a same feel Kepala sama hitam hati lain-lain. Dalam kehidupan ini, setiap insan berbeza cara, kesukaan, perangai, tabia

WebDev

http://blog.kerul.net PHP DEVELOPMENT TOOLS Download the XAMPP latest version from www.apachefriends.org . This installation file contains the Apache web server, PHP 5 and 4 interpreter, and the MySQL 5 Community edition. - download latest version MozillaFireFox (OpenSource web browser firefox) – download latest version Google Chrome – fastest web browser on earcth – fast download chrome here TEACHING PLAN Download the teaching plan here for Web/Internet Programming ( download ) NOTES HTML references HTML Editor -  http://www.sublimetext.com/ Lab 1: HTML Basics -  http://www.w3schools.com/html/ Lab 2: Responsive Design:  http://www.w3schools.com/html/html_responsive.asp Lab 3: HTML Forms  http://www.w3schools.com/html/html_forms.asp Lab 4: HTML 5  http://www.w3schools.com/html/html5_intro.asp Lab 5: Bootstrap for responsive Web -  http://www.w3schools.com/bootstra

Contact Us at blog.kerul.net

Powered by EMF HTML Contact Form

Bootstrap Template for PHP database system - MyCompanyHR

HTML without framework is dull. Doing hard-coded CSS and JS are quite difficult with no promising result on cross platform compatibility. So I decided to explore BootStrap as they said it is the most popular web framework. What is BootStrap? - Bootstrap is the most popular HTML, CSS, and JavaScript framework for developing responsive, mobile-first web sites. (  http://www.w3schools.com/bootstrap/   ) Available here -  http://getbootstrap.com/ Why you need Flat-UI? Seems like a beautiful theme to make my site look professional. Anyway you could get variety of BootStrap theme out there, feel free to select here  http://bootstraphero.com/the-big-badass-list-of-twitter-bootstrap-resources/ Flat-UI is from DesignModo -   http://designmodo.com/flat/ Web Programming MyCompanyHR – PHP & MySQL mini project (with Boostrap HTML framework) Template 1: Template for the Lab Exercise. This is a project sample of a staff record management system. It has the PHP structured co

Login JSON Android using Login Activity

I’ve been trying to release this tutorial quite a while. At last after a long hard effort. Since HttpClient is not supported any more in Android SDK 23, I have to resort to org.json.JSONObject and java.net.HttpURLConnection library to do online database with JSON. The objective of this tutorial is to log-in from a mobile client with the username and password stored in an online database facility. STEP 1: Create a new Android project, this time choose the LoginActivity .