{"id":11324,"date":"2015-07-12T20:57:03","date_gmt":"2015-07-12T15:57:03","guid":{"rendered":"https:\/\/blazeminds.com\/blog\/?p=11324"},"modified":"2015-07-12T21:10:19","modified_gmt":"2015-07-12T16:10:19","slug":"how-to-make-android-database-application-sqlite-part-1","status":"publish","type":"post","link":"https:\/\/blazeminds.com\/blog\/how-to-make-android-database-application-sqlite-part-1\/","title":{"rendered":"How to make Android Database application (SQLite) Part 1"},"content":{"rendered":"

Assalam-u-Alaikum, Welcome again folks. Today in this post I will be guiding you to make Android in App database through SQLite database. So lets get started!<\/p>\n

<\/p>\n

Step 1<\/b>
\nCreate new Project & name it whatever you want to. After naming Project you will be asked Company Domain, <\/i>this is where you define your Project package.
\nI am naming Project to “DBClass” <\/b>and Company Domain “tuts.com”<\/b>. Company Domain counts the most while uploading your app on Google Play Store.
\nAfter naming proceed to next.<\/p>\n

\"1\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 2<\/b>
\nIn next window you will be asked to choose minimum Android OS Level<\/i><\/b> OR\u00a0API Level<\/i>. Best choice is to select API 16<\/i><\/b> OR Android 4.1 (JellyBean)<\/i>, as mostly nowadays at minimum Android 4.1 JellyBean is widely used.
\n
\n<\/b><\/p>\n

\"2\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 3<\/b>
\nAfter selecting Android OS Level you will prompted with this window asking you which type of android layout you wish to use. Right now keep it simple & select “Blank Activity”<\/b> and proceed to next.<\/p>\n

 <\/p>\n

\"3\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 4<\/b>
\nIn this window you will be asked about the name of your android activity & layout name. By default Activity Name is\u00a0“Main Activity” <\/b>& layout name is “activity_main”<\/b>.<\/p>\n

NOTE:
\nDo remember to use only small caps while naming layout name.<\/p>\n

 <\/p>\n

\"4\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 5 (a)<\/b>
\nNow your application is ready to get coded. For this app you Right click your package,(here its com.tuts.dbclass<\/b><\/i>) & select New then Java Class<\/p>\n

Right click package -> New -> Java Class.<\/p>\n

 <\/p>\n

\"5\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 5(b)<\/b>
\nName this Class DBController.<\/b><\/p>\n

\"6\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 6(a) – Real coding starts<\/i><\/b>
\nHere define your database name, tables & version. Main things you have to keep in your mind:<\/p>\n

Database Version:<\/b>\u00a0Changing this would delete all your previous records & make new entries. Better to change its version when doing the re-engineering of your application
\n
\n<\/b>Database Name: <\/b>Name of your database. better use small caps & if your DB Name consists of 2 words then use underscore(“_”<\/b>) in between. Example: “db_class<\/i>“<\/b>.<\/p>\n

Same applies to Database Table & Table Column names.<\/p>\n

\"7a\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 6(b)<\/b>
\nThe most important Helping classes used in making database app are DBHelper, SQLiteDatabase
\n
\n<\/b>DBHelper:<\/b>\u00a0DBHelper would be inner class where all of the SQL queries will be defined.
\nSQLiteDatabase:<\/b>\u00a0This class is the most important of all as all queries will be executed via this.
\n
\n<\/b>Context: <\/b>\u00a0It will get the current activity of the application from where the query is called.<\/p>\n

 <\/p>\n

\"7b\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 6(c)<\/b>
\nTwo most important built-in functions of SQLite database, onCreate & onUpgrade.<\/p>\n

When your app fresh installs onCreate<\/i><\/b> function is called whereas when you re-install the app then onUpgrade<\/i><\/b> function is called.<\/p>\n

 <\/p>\n

\"7c\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 6(d)<\/b>
\nMost frequently used database functions:<\/b>
\n1) openDatabase
\n2) closeDatabase<\/p>\n

1) openDatabase:<\/u><\/i>
\n
\n<\/u><\/i>You can open database in 2 ways. One through Opening “db = dbhelper.getWritableDatabase();” <\/i>\u00a0where as second way is “db = dbhelper.getReadableDatabase();”<\/i>.
\nIn Writable version you can read as well as write database entries.
\nIn Readable version you can just only read database entries.
\nBest option is to use Writable database.
\nIn the fig attached I have shown how to make function of both of these types.
\n
\n<\/b>2) closeDatabase:<\/u><\/i>
\n
\n<\/u><\/i>closing database simple. You just have to close Database Helper class.
\n“dbHelper.close();”.<\/i><\/p>\n

\"7d\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

That’s all for now. Stay tuned for next part of android database connection. Till then Take Care \ud83d\ude42<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

Assalam-u-Alaikum, Welcome again folks. Today in this post I will be guiding you to make Android in App database through SQLite database. So lets get started!<\/p>\n","protected":false},"author":113,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"yes"},"categories":[1455],"tags":[186,1469,1470,1471,1460,1466,1468,1467,1472,1473],"_links":{"self":[{"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/posts\/11324"}],"collection":[{"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/users\/113"}],"replies":[{"embeddable":true,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/comments?post=11324"}],"version-history":[{"count":6,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/posts\/11324\/revisions"}],"predecessor-version":[{"id":11340,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/posts\/11324\/revisions\/11340"}],"wp:attachment":[{"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/media?parent=11324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/categories?post=11324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/tags?post=11324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}