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;DetailUser.java
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;
}
}
}
package com.example.uasdudisqllite;ListUser.java
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();
}
}
}
}
package com.example.uasdudisqllite;Registration.java
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);
}
}
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, ^_^