Get Files

<RelativeLayout >="http://schemas.android.com/apk/res/android"
 >="http://schemas.android.com/tools"
 android:layout_width="match_parent"
 android:layout_height="match_parent"
 android:paddingBottom="@dimen/activity_vertical_margin"
 android:paddingLeft="@dimen/activity_horizontal_margin"
 android:paddingRight="@dimen/activity_horizontal_margin"
 android:paddingTop="@dimen/activity_vertical_margin"
 android:background="#FFCC99"
 tools:context=".AddNewRecord" >
 
 <!-- FILE activity_update_record.xml -->
 <TableLayout
 android:id="@+id/tableLayout1"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_alignParentBottom="true"
 android:layout_alignParentLeft="true"
 android:layout_alignParentRight="true"
 android:layout_alignParentTop="true" >

 <TableRow
 android:id="@+id/tableRow6"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <ImageView
 android:id="@+id/imageView1"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:src="@drawable/ic_person_add_black_24dp" />

 </TableRow>

 <TableRow
 android:id="@+id/tableRow1"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <TextView
 android:id="@+id/textView1"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:text="Fullname"
 android:textAppearance="?android:attr/textAppearanceMedium" />

 <EditText
 android:id="@+id/txtnama"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:ems="10" >

 <requestFocus />
 </EditText>
 </TableRow>

 <TableRow
 android:id="@+id/tableRow2"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <TextView
 android:id="@+id/textView2"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:text="Department"
 android:textAppearance="?android:attr/textAppearanceMedium" />

 <EditText
 android:id="@+id/txtjbt"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:ems="10" />
 </TableRow>

 <TableRow
 android:id="@+id/tableRow3"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <TextView
 android:id="@+id/textView3"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:text="Phone"
 android:textAppearance="?android:attr/textAppearanceMedium" />

 <EditText
 android:id="@+id/txttelefon"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:ems="10"
 android:inputType="phone" />
 </TableRow>

 <TableRow
 android:id="@+id/tableRow4"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <TextView
 android:id="@+id/textView4"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:text="Email"
 android:textAppearance="?android:attr/textAppearanceMedium" />

 <EditText
 android:id="@+id/txtemel"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:ems="10"
 android:inputType="textEmailAddress" />
 </TableRow>

 <TableRow
 android:id="@+id/tableRow5"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <Button
 android:id="@+id/btnsavenew"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:text="Save New Staff" />

 </TableRow>

 </TableLayout>

</RelativeLayout>

package net.kerul.fstmdirektori;

import android.net.Uri;
import android.os.Bundle;
import android.app.Activity;
import android.content.ContentValues;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;

public class AddNewRecord extends Activity {
 private EditText txtnama, txtjbt, txttelefon, txtemel;
 private Button btnsave;
 private DBHelper mHelper;
 private SQLiteDatabase dataBase;
 private String id,name,telno,email,dept;//to hold the data strings

 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_add_new_record);
 
 mHelper=new DBHelper(this);
 dataBase = mHelper.getWritableDatabase();
 
 //initiate all textbox container to hold the data for the staff
 txtnama=(EditText)findViewById(R.id.txtnama);
 txtjbt=(EditText)findViewById(R.id.txtjbt);
 txttelefon=(EditText)findViewById(R.id.txttelefon);
 txtemel=(EditText)findViewById(R.id.txtemel);
 
 btnsave=(Button)findViewById(R.id.btnsavenew);
 btnsave.setOnClickListener( new OnClickListener(){
 public void onClick(View v){
 //capture amendment
 name=txtnama.getText().toString();
 telno=txttelefon.getText().toString();
 email=txtemel.getText().toString();
 dept=txtjbt.getText().toString();
 
 saveData();
 }
 });//end btnsave setOnCLickCListener
 }
 
 //save new record
 private void saveData(){
 ContentValues values=new ContentValues();
 
 values.put(DBHelper.NAMA,name);
 values.put(DBHelper.JBT,dept);
 values.put(DBHelper.EMEL,email );
 values.put(DBHelper.TELEFON,telno );
 
 System.out.println("");
 
 //save new record to the database into database
 dataBase.insert(DBHelper.TABLE_NAME, null, values);

 //close database
 dataBase.close();
 finish();
 
 
 }

}

package net.kerul.fstmdirektori;

import java.util.ArrayList;

import android.app.Activity;
import android.app.AlertDialog;
import android.content.DialogInterface;
import android.content.Intent;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.os.Bundle;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.AdapterView.OnItemLongClickListener;
import android.widget.ListView;
import android.widget.Toast;

public class DisplayList extends Activity {
 
 private String id;//to hold selected stafid 
 private DBHelper mHelper;
 private SQLiteDatabase dataBase;

 //variables to hold staff records
 private ArrayList<String> stafid = new ArrayList<String>();
 private ArrayList<String> nama = new ArrayList<String>();
 private ArrayList<String> jbt = new ArrayList<String>();

 private ListView userList;
 private AlertDialog.Builder build;

 @Override
 public void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_display_list);

 userList = (ListView) findViewById(R.id.List);

 mHelper = new DBHelper(this);
 
 //click to update data
 userList.setOnItemClickListener(new OnItemClickListener() {
 public void onItemClick(AdapterView<?> arg0, View arg1, int arg2,
 long arg3) {

 Intent i = new Intent(getApplicationContext(),
 ViewRecord.class);
 i.putExtra("stafid", stafid.get(arg2));
 startActivity(i);
 }
 });//end setOnItemClickListener
 
 //long-press to update data
 userList.setOnItemLongClickListener(new OnItemLongClickListener() {

 public boolean onItemLongClick(AdapterView<?> arg0, View arg1,
 final int arg2, long arg3) {
 Intent i = new Intent(getApplicationContext(),
 UpdateRecord.class);
 i.putExtra("stafid", stafid.get(arg2));
 startActivity(i);
 return true;
 }
 });//end setOnItemLongClickListener
 
 
 }

 @Override
 protected void onResume() {
 //refresh data for screen is invoked/displayed
 displayData();
 Toast.makeText(getApplicationContext(), "TAP on rescord to view complete info, LONG-TAP to update...", Toast.LENGTH_LONG).show();
 super.onResume();
 }

 /**
 * displays data from SQLite
 */
 private void displayData() {
 dataBase = mHelper.getWritableDatabase();
 //the SQL command to fetched all records from the table
 Cursor mCursor = dataBase.rawQuery("SELECT * FROM "
 + DBHelper.TABLE_NAME, null);

 //reset variables
 stafid.clear();
 nama.clear();
 jbt.clear();
 
 //fetch each record
 if (mCursor.moveToFirst()) {
 do {
 //get data from field 
 stafid.add(mCursor.getString(mCursor.getColumnIndex(DBHelper.STAFID)));
 nama.add(mCursor.getString(mCursor.getColumnIndex(DBHelper.NAMA)));
 jbt.add(mCursor.getString(mCursor.getColumnIndex(DBHelper.JBT)));
 
 } while (mCursor.moveToNext());
 //do above till data exhausted 
 }
 
 //display to screen
 DisplayAdapter disadpt = new DisplayAdapter(DisplayList.this, stafid, nama, jbt);
 userList.setAdapter(disadpt);
 mCursor.close();
 }//end displayData
 
 


 @Override
 public <
Available link for download