UAS Mobile Programming memnbuat kontak dengan SQL Lite Android

untuk memenuhi salah satu tugas mata kuliah dalam hal ini UAS Mobile Programming saya akan membuat kontak sederhana dengan SQL lite Android.
langsung saja langkah pertama yang kita lakukan adalah membuka eclipse dengan membuat aplikasi android baru

setelah itu buat kita membuat class DBPracticeActivity.java dengan kode berikut ini

    package com.example.uasdudisqllite;

    import com.example.db.R;

    import android.app.Activity;
    import android.content.Intent;
    import android.os.Bundle;
    import android.view.View;
    import android.view.View.OnClickListener;
    import android.widget.Button;

    public class DBPracticeActivity extends Activity implements OnClickListener {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.main);
    Button regButton = (Button)findViewById(R.id.buttonMainRegister);
    Button listButton = (Button)findViewById(R.id.ButtonMainList);
    regButton.setOnClickListener(this);
    listButton.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
    Intent intent;
    switch(v.getId()) {
    case R.id.buttonMainRegister :
    intent = new Intent();
    intent.setClass(getApplicationContext(), Registration.class);
    startActivity(intent);
    break;
    case R.id.ButtonMainList :
    intent = new Intent();
    intent.setClass(getApplicationContext(), ListUsers.class);
    startActivity(intent);
    break;
    }
    }
    }

    

    

DetailUser.java

    package com.example.uasdudisqllite;
    import com.example.db.DatabaseHandler;
    import com.example.db.R;
    import com.example.db.User;

    import android.app.Activity;
    import android.content.Intent;
    import android.os.Bundle;
    import android.util.Log;
    import android.view.View;
    import android.view.View.OnClickListener;
    import android.widget.Button;
    import android.widget.EditText;
    import android.widget.Toast;

    public class EditUsers extends Activity implements OnClickListener{
    private static String position = null;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.edit_user);
    Intent intent = getIntent();
    position = intent.getStringExtra(“position”);

    DatabaseHandler db = new DatabaseHandler(this);
    Log.d(“position”, position);
    //get user for the position clicked for edit
    User user = db.getUser(position);

    Log.d(“User Name”, user.getName());
    Log.d(“Address”, user.getAddress());
    Log.d(“Users phone”, user.getPhone());

    //set the values in editText boxes
    EditText name = ((EditText)findViewById(R.id.editTextEditName));
    name.setText(user.getName());
    EditText address = ((EditText)findViewById(R.id.editTextEditAddress));
    address.setText(user.getAddress());
    EditText phone = ((EditText)findViewById(R.id.editTextEditPhone));
    phone.setText(user.getPhone());

    Button backButton = (Button)findViewById(R.id.buttonEditBack);
    backButton.setOnClickListener(this);

    Button updateButton = (Button)findViewById(R.id.buttonEdit);
    updateButton.setOnClickListener(this);
    }

    @Override
    public void onClick(View v) {
    if(v.getId() == R.id.buttonEditBack) {
    Intent intent = new Intent(getApplicationContext(), ListUsers.class);
    startActivity(intent);
    }
    else if(v.getId() == R.id.buttonEdit) {
    User user = new User(
    ((EditText)findViewById(R.id.editTextEditName)).getText().toString(),
    ((EditText)findViewById(R.id.editTextEditAddress)).getText().toString(),
    ((EditText)findViewById(R.id.editTextEditPhone)).getText().toString()
    );
    DatabaseHandler db = new DatabaseHandler(this);
    int updateCount = db.editUser(user, position);
    if(updateCount == 1) {
    Toast toast = Toast.makeText(getApplicationContext(),
    “User successfully updated”,
    Toast.LENGTH_SHORT);
    toast.show();
    }
    else{
    Toast toast = Toast.makeText(getApplicationContext(),
    “User update failed, Try Again”,
    Toast.LENGTH_SHORT);
    toast.show();
    }
    }
    }

    }

ListUser.java

package com.example.uasdudisqllite;
import java.util.List;

import com.example.db.DatabaseHandler;
import com.example.db.R;
import com.example.db.User;

import android.app.ListActivity;
import android.content.Intent;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.ArrayAdapter;
import android.widget.ListView;

public class ListUsers extends ListActivity{

public void onCreate(Bundle icicle) {
super.onCreate(icicle);
DatabaseHandler db = new DatabaseHandler(this);
String[] users = db.getAllUsers();
if(users!=null) {
for(String us:users) {
Log.d(“String Array Value”, us);
}
db.close();
}
// Use your own layout
ArrayAdapter<String> adapter = new ArrayAdapter<String>(this, R.layout.list_users, R.id.textViewList, users);
setListAdapter(adapter);
}

@Override
protected void onListItemClick(ListView l, View v, int position, long id) {
Log.d(“On click of a item”, Integer.toString(position));
Intent intent = new Intent();
intent.setClass(getApplicationContext(), DetailsUsers.class);
intent.putExtra(“position”, Integer.toString(position + 1)); //position starts from 0, but in db row starts from 1
startActivity(intent);
}
}

 Registration.java

package com.example.uasdudisqllite;
import com.example.db.DatabaseHandler;
import com.example.db.R;
import com.example.db.User;

import android.app.Activity;
import android.content.Intent;
import android.os.Bundle;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class Registration extends Activity implements OnClickListener{
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.registration);
Button regButton = (Button)findViewById(R.id.buttonRegister);
regButton.setOnClickListener(this);
Button backButton = (Button)findViewById(R.id.buttonRegisterBack);
backButton.setOnClickListener(this);
}

@Override
public void onClick(View v) {
Intent intent;
switch(v.getId()) {
case R.id.buttonRegister :
register();
break;
case R.id.buttonRegisterBack :
intent = new Intent();
intent.setClass(getApplicationContext(), DBPracticeActivity.class);
startActivity(intent);
break;
}
}

private void register() {
String user = ((EditText)findViewById(R.id.editTextRegName)).getText().toString();
String address = ((EditText)findViewById(R.id.editTextRegAddress)).getText().toString();
String phone = ((EditText)findViewById(R.id.editTextRegPhone)).getText().toString();
DatabaseHandler db = new DatabaseHandler(this);
int id = db.addUser(new User(user,address,phone));
db.close();
if(id>0) {
Toast toast = Toast.makeText(getApplicationContext(),
“User registered at id ” + id,
Toast.LENGTH_SHORT);
toast.show();
}
else {
Toast toast = Toast.makeText(getApplicationContext(),
“User registration failed”,
Toast.LENGTH_SHORT);
toast.show();
}
((EditText)findViewById(R.id.editTextRegName)).setText(“”);
((EditText)findViewById(R.id.editTextRegAddress)).setText(“”);
((EditText)findViewById(R.id.editTextRegPhone)).setText(“”);
}
}

dan hasilnya seperti gambar di bawah ini

semoga bermanfaat, ^_^