The general structure of App is explained:
a) MainActivity Class where the layout of user screen is defined.
b) DatabaseHandler Class. Creation of database, insert and select
queries. How Cursor works on android database.
c) Generation of the CSV file.
The intruction explains how important is to understand the layout
of the user screen to allocate space on each table and row for
Text and Data Entry fields. Also for buttons and the On Click
event to execute an action like:
a) Insert data entry to the database.
b) Generate the text CSV file.
The souce code and PDF with explanation is included in the section two of the course.
a) Structure of the App
b) TableLayout to Display Titles, Input Fields and Buttons.
c) Properties for Rows on Table Layouts to Display Text, Edit Fields and Buttons.
Structure concept to allocate Text, Edit and Button Fields inside the Rows of the
d) Actions to allocate each Field on the Rows and each Row inside the Table
e) Create Database Handler Class
f) Initialization Methods of the DatabaseHandler.
g) Insert and Select Statements in the Database
h) Code for Function SelectData() on the MainActivity to get the results of the query
from the Database.
i) Functions and Statements to generate CSV file from Database Query.
j) Display and Orientation settings Initialization
k) Run and Test Code
l) Export the data from database to CSV file
m) Exercise to build all the Pieces Together
The source code packed in the datacapture.zip file has the structure to be
imported in the Eclipse with Android Plug In IDE. The version used to compile the
source code is Eclipse JUNO. If you are using another version or IDE, the source files are located on path: Inventory/src/com/com/example2/ex2 : MainActivity.java and