{"id":11341,"date":"2015-07-13T09:00:12","date_gmt":"2015-07-13T04:00:12","guid":{"rendered":"https:\/\/blazeminds.com\/blog\/?p=11341"},"modified":"2015-07-13T14:16:29","modified_gmt":"2015-07-13T09:16:29","slug":"how-to-make-android-database-application-sqlite-part-2","status":"publish","type":"post","link":"https:\/\/blazeminds.com\/blog\/how-to-make-android-database-application-sqlite-part-2\/","title":{"rendered":"How to make Android Database application (SQLite) Part 2"},"content":{"rendered":"

Assalam-u-Alaikum, Welcome again folks. Today in this post I will be continuing the previous tutorial on how to make your own android database application. Hope you understood the previous part. Now lets complete the tutorial!<\/p>\n

In previous steps\u00a0I have covered the basic functions of database that are used thoroughly in android sqlite database. From now on we will cover on how to insert into & view data from database.<\/p>\n

Step 7(a)<\/strong><\/p>\n

Make new Class to view data from database. Same as Step 5 (present in part 1 of this tutorial<\/em>).<\/p>\n

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

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 7(b)<\/strong><\/p>\n

Name that class “GetResult”<\/strong>.<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 8 (a)<\/strong><\/p>\n

Now make layout for Activity you just made\u00a0“GetResult.java”<\/strong>. Expand\u00a0“res”<\/strong> folder then\u00a0“layout”<\/strong>.<\/p>\n

res-> layout -> (Right Click layout -> Click New).<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 8(b)<\/strong><\/p>\n

Name the layout file\u00a0“get_result”<\/strong>. Remember the names of all layouts should be small caps.<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 8(c)<\/strong><\/p>\n

After the layout is set & loaded, Drag & Drop “ListView”<\/strong> from elements present on Left hand side.
\n\"10\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

After Drag & Drop of ListView you will be seeing the structure as shown in above snapshot.<\/p>\n

 <\/p>\n

Step 8(d)<\/strong><\/p>\n

Now swap to Text\u00a0<\/strong>from bottom left. & put the id of ListView as whatever you want to give I am giving its name as getResultList<\/strong>.<\/p>\n

To give id in android write :\u00a0android:id =<\/strong> “@+id\/getResultList”<\/strong><\/p>\n

\"11\"<\/a>\u00a0<\/strong><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 9 (a)<\/strong><\/p>\n

Now open GetResult.java<\/strong> file that is present inside the package folder.<\/p>\n

1) Extend GetResult to Activity & import required packages by right clicking the GetResult extends Activity<\/strong> line.<\/p>\n

2) Inside GetResult Class write “onCre”<\/strong>\u00a0which then generates the dropdown, from options select\u00a0onCreate(SavedInstanceState)<\/strong>. This will generate the function in which you will be attaching & playing with your layout xml file.<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 9 (b)<\/strong><\/p>\n

1) Now time to attach the xml(layout) file that you made as “get_result<\/strong>“. Write “setContentView(R.layout.get_result)”<\/strong>.<\/p>\n

2) Make the variable of\u00a0ListView\u00a0<\/strong> better to make it global. Link the ListView with the xml as<\/p>\n

ListVariable = (ListView) findViewById(R.id.getResultList);<\/strong><\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 9(c)<\/strong><\/p>\n

For Back button repeat the previous steps as you did for ListView.<\/p>\n

For Showing data from database we will be getting help of data structure\u00a0ArrayList<\/strong>. You can use other Data Structure technique such as List<String> etc. You can also use simple String but its much much better to use data structures.<\/p>\n

For Java Data Structures download ebooks from:<\/span>
\nJava Data Structures Ebooks<\/a><\/span><\/em><\/p>\n

or check JavaTPoint site:<\/span>
\nJava Data Structures – Java TPoint<\/a><\/span><\/em><\/p>\n

1) ArrayList<String> data = new ArrayList<String>();\/\/ Make variable of ArrayList<String><\/p>\n

2) DBController db = new DBController(GetResult.this); \/\/ Make object of DBController Class<\/p>\n

3) db.OpenDataBase();\/\/Opens Database Connection<\/p>\n

4) data = db.getData();\/\/ Gets data from database & store into variable named data<\/strong><\/p>\n

5) db.CloseDataBase(); \/\/ Closes Database Connection<\/p>\n

ArrayAdapter<\/strong>:<\/p>\n

The default way to show data into the ListView is through ArrayAdapter. Following code snippet is the default way to use this class.<\/p>\n

ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, data); <\/strong>\/\/ here data is the variable we are using from above.<\/p>\n

DBResult.setAdapter(adapter);<\/strong> \/\/DBResult is the variable name for ListView\u00a0<\/strong><\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Step 10<\/strong><\/p>\n

Here comes the final step . Yet its final But most important step too.<\/p>\n

1) Open manifest (mostly present above java folder<\/em>).<\/p>\n

2) Inside <application><\/strong> tag link GetResult.java file so that your apps know the classes present inside it. To link the class follow the code below:<\/p>\n

<activity<\/p>\n

android:name =”.GetResult”<\/p>\n

android:label = “Database Result”<\/p>\n

\/><\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Outputs of the Program:<\/strong><\/p>\n

 <\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Output(a)<\/p>\n

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

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Output(b)<\/p>\n

 <\/p>\n

\"14<\/a>Output(c)<\/p>\n

 <\/p>\n

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

Assalam-u-Alaikum, Welcome again folks. Today in this post I will be continuing the previous tutorial on how to make your own android database application. Hope you understood the previous part. Now lets complete the tutorial! In previous steps\u00a0I have covered the basic functions of database that are used thoroughly in android sqlite database. From now […]<\/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":[],"_links":{"self":[{"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/posts\/11341"}],"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=11341"}],"version-history":[{"count":8,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/posts\/11341\/revisions"}],"predecessor-version":[{"id":11364,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/posts\/11341\/revisions\/11364"}],"wp:attachment":[{"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/media?parent=11341"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/categories?post=11341"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blazeminds.com\/blog\/wp-json\/wp\/v2\/tags?post=11341"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}