Monthly Archives: June 2013

Android Development Tutorial

Android Development 14

109 Comments

Android Development TutorialWelcome to part 14 of my Android Development tutorial! In this part of the tutorial I will completely finish the Android Address Book App. I will also spend a lot of time answering questions I recently received on Contexts, Intents, how to pass data between Activities using putExtra() and and getStringExtra(). I’ll also cover how to import Android packages into Eclipse.

Here is the final complete Android Address Book App Package. All of the specific code I worked with in this tutorial can be found below. Continue reading Android Development 14 →

Android Development Tutorial

Android Development 13

26 Comments

Android Development TutorialWelcome to part 13 of my Android Development Tutorial! In this tutorial I will continue building the Android Address Book App previously covered in parts 10, 11 and 12. If you haven’t seen them, check them out first.

Specifically in this tutorial I will create the Java that will power the ListView for the Main Activity and I’ll also cover the New Contact code needed to add a contact to the database. All of the heavily commented code after the video should help make everything understandable. Continue reading Android Development 13 →

Android Development Tutorial

Android Development 12

25 Comments

Android SQLiteIn this tutorial I’ll continue making my Android SQLite Address Book app. I hope this code is useful enough to use as a cheat sheet when you need to use an SQLite database in Android.

I cover a ton of topics: How to Create a SQLite Database and Tables, How to Issue Queries, How to Insert Data, How to Update Data, How to Delete Data, SQLiteOpenHelper, execSQL, SQLiteDatabase, ContentValues, rawQuery, Cursor, and more. The code below will help. Continue reading Android Development 12 →

Android Development Tutorial

Android Development 11

13 Comments

Android Address Book AppIn this part of my Android Development Tutorial I continue building the Android Address Book app. If you missed the first part it is here.

This time I finish up the interface for my app. I walk you step-by-step through everything. I then go through every query I will be issuing to my SQLite database in the app. I show how to create tables, insert contacts, update contacts, delete contacts, output everything and even drop the table. Here is my SQLite3 Tutorial if you need it. Continue reading Android Development 11 →

Android Development Tutorial

Android Development 10

26 Comments

Android Development Tutorial 10Welcome to part 10 of my Android Development Tutorial! In the next few videos I will show you how to create an Address Book / Contact App using both Android and SQLite.

I was asked by a bunch of you guys slow down for a few tutorials so that it would be easier to completely understand what is going on. So, I’ll go through how to define constants for my interface in the string.xml and dimens.xml files. I’ll then create the activity_main.xml file which will be the opening interface. I’ll also introduce the ListView. Continue reading Android Development 10 →

Android Development Tutorial

SQLite3 Tutorial 4

20 Comments

SQLite3 TutorialWelcome to part 4 of my SQLite3 Tutorial! I cover an enormous amount of information on SQLite3 here.

I cover all of the following: Review of most everything from previous SQlite3 tutorials, SQLite3 ENUMs, Composite Primary Keys, dates, data types, data affinities, joins, inner join, left join, natural join, cross join, ON, GROUP BY, select statements inside of select statements, views, triggers and more. If you missed the previous parts look here SQLite3 Tutorial, Part 2 & Part 3. Continue reading SQLite3 Tutorial 4 →

Android Development Tutorial

SQLite3 Tutorial 3

2 Comments

SQLite3 Tutorial 3Welcome to part 3 of my SQLite3 Tutorial! Here I will cover a TON of commands for SQLite3. If you want a video that covers a ton on SQL you are in the right place.

All of the following are covered in the video and the code that follows: SELECT, FROM, WHERE, COLLATE, NOT NULL, DEFAULT, UNIQUE, CHECK, FOREIGN KEY, REFERENCES, ALTER, ADD COLUMN, RENAME, AND, OR, LIKE, NOT LIKE, ORDER BY, LIMIT, OFFSET, AS, UPDATE, DELETE, and more. I also cover a bunch of arithmetic, boolean, bitwise, relational and other operators. Continue reading SQLite3 Tutorial 3 →

Android Development Tutorial

SQLite3 Tutorial 2

11 Comments

SQLite3 Tutorial 2Welcome to part 2 of my SQLite3 Tutorial. Today I’m going to talk about something that is always ignored in most database tutorials. I’ll show you how to alphabetize a multidimensional array. I’ll also show you the code you can use to generate insert statements so you can save yourself a ton of time.

If you missed part 1 you should watch it first here SQLite3 Tutorial. All of the code used in the video is available below. I hope you find it to be useful. Continue reading SQLite3 Tutorial 2 →