Cara Membuat SQLite Database Menu Registrasi dan View list Tugas 2
Buatlah project android dengan nama Tugas2
Activity Name = DBPracticeActivity
Layout Name = main
pada praktikum kali ini kita akan membuat banyak class baik itu java maupun xml, untuk memudahkan praktikum saya membuat 2 package yang didalamnya ada beberapa file java seperti gambar berikut..
kemudian buat lagi beberaa file xml pada folder layout seperti gambar ini :
Kemudian downloadlah gambar yang ada dibawah ini yang nanti anda akan pastekan pada folder drawable-hdpi
Jika file – file yang kita butuhkan sudah lengkap saatnya modifikasi isi coding yang ada pada file yang telah kita buat.
Ubahlah isi coding main.xml menjadi seperti berikut :<?xml version=”1.0″ encoding=”utf-8″?>
android:orientation=”vertical”
android:layout_width=”fill_parent”
android:layout_height=”fill_parent”
>
<TextView
android:layout_height=”wrap_content”
android:id=”@+id/textViewMainHeading”
android:layout_width=”wrap_content”
android:text=”Slect your choice”
android:layout_alignParentTop=”true”
android:layout_centerHorizontal=”true”>
</TextView>
<Button
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:text=”Register”
android:id=”@+id/buttonMainRegister”
android:layout_below=”@+id/textViewMainHeading”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”70dp”>
</Button>
<Button
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:text=”View List and Details”
android:id=”@+id/ButtonMainList”
android:layout_below=”@+id/textViewMainHeading”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”133dp”>
</Button>
</RelativeLayout>
Ubahlah isi coding registration.xml menjadi seperti berikut :<?xml version=”1.0″ encoding=”utf-8″?>
<RelativeLayout
android:orientation=”vertical”
android:layout_width=”match_parent”
android:layout_height=”match_parent”>
<Button
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:layout_alignParentTop=”true”
android:layout_alignParentLeft=”true”
android:id=”@+id/buttonRegisterBack”
android:text=”Back”>
</Button>
<EditText
android:layout_height=”wrap_content”
android:inputType=”textPersonName”
android:id=”@+id/editTextRegName”
android:layout_width=”120dp”
android:layout_below=”@+id/buttonRegisterBack”
android:layout_toRightOf=”@+id/textViewRegName”
android:layout_marginLeft=”51dp”
android:layout_marginTop=”18dp”>
</EditText>
<TextView
android:layout_height=”wrap_content”
android:id=”@+id/textViewRegName”
android:layout_width=”wrap_content”
android:text=”Name”
android:layout_alignBottom=”@+id/editTextRegName”
android:layout_toRightOf=”@+id/buttonRegisterBack”
android:layout_marginLeft=”36dp”
android:layout_marginBottom=”14dp”>
</TextView>
<EditText
android:layout_height=”wrap_content”
android:inputType=”textPostalAddress”
android:layout_width=”120dp”
android:layout_below=”@+id/editTextRegName”
android:layout_alignLeft=”@+id/editTextRegName”
android:layout_marginTop=”26dp”
android:id=”@+id/editTextRegAddress”>
</EditText>
<TextView
android:layout_height=”wrap_content”
android:id=”@+id/textViewRegAddress”
android:layout_width=”wrap_content”
android:text=”Address”
android:layout_alignTop=”@+id/editTextRegAddress”
android:layout_alignLeft=”@+id/textViewRegName”
android:layout_marginTop=”14dp”>
</TextView>
<EditText
android:layout_height=”wrap_content”
android:inputType=”phone”
android:layout_centerVertical=”true”
android:layout_alignLeft=”@+id/editTextRegAddress”
android:id=”@+id/editTextRegPhone”
android:layout_width=”120dp”>
</EditText>
<TextView
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:layout_centerVertical=”true”
android:layout_alignLeft=”@+id/textViewRegAddress”
android:id=”@+id/textViewRegPhone”
android:text=”Phone No.”>
</TextView>
<Button
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:layout_below=”@+id/editTextRegPhone”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”38dp”
android:id=”@+id/buttonRegister”
android:text=”Register”>
</Button>
<ImageView
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:src=”@drawable/login_icon”
android:layout_below=”@+id/buttonRegister”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”38dp”
android:id=”@+id/imageViewRegLogin”>
</ImageView>
</RelativeLayout>
Ubahlah isi coding list_users.xml menjadi seperti berikut :<?xml version=”1.0″ encoding=”utf-8″?>
<RelativeLayout
android:orientation=”vertical”
android:layout_width=”match_parent”
android:layout_height=”match_parent”>
<ImageView
android:id=”@+id/icon”
android:layout_width=”22px”
android:layout_height=”22px”
android:layout_marginLeft=”4px”
android:layout_marginRight=”10px”
android:layout_marginTop=”4px”
android:src=”@drawable/login_icon” >
</ImageView> <TextView
android:id=”@+id/textViewList”
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:layout_alignTop=”@+id/icon”
android:layout_marginLeft=”20dp”
android:layout_toRightOf=”@+id/icon”
android:text=”@+id/label”
android:textSize=”20px” />
</RelativeLayout>
Ubahlah isi coding edit_user.xml menjadi seperti berikut :<?xml version=”1.0″ encoding=”utf-8″?>
<RelativeLayout
android:orientation=”vertical”
android:layout_width=”match_parent”
android:layout_height=”match_parent”>
<Button
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:layout_alignParentTop=”true”
android:layout_alignParentLeft=”true”
android:id=”@+id/buttonEditBack”
android:text=”Back”>
</Button>
<TextView
android:layout_height=”wrap_content”
android:id=”@+id/textViewEditAddress”
android:layout_width=”wrap_content”
android:text=”Address”
android:layout_alignTop=”@+id/editTextEditAddress”
android:layout_alignLeft=”@+id/textViewEditName”
android:layout_marginTop=”14dp”>
</TextView>
<Button
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:layout_below=”@+id/editTextEditPhone”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”38dp”
android:id=”@+id/buttonEdit”
android:text=”Update”>
</Button>
<ImageView android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:src=”@drawable/login_icon”
android:layout_below=”@+id/buttonEdit”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”38dp”
android:id=”@+id/imageViewEditLogin”>
</ImageView>
<TextView
android:id=”@+id/textViewEditName”
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:text=”Name”
android:layout_alignBottom=”@+id/editTextEditName”
android:layout_toRightOf=”@+id/buttonEditBack”
android:layout_marginBottom=”14dp”>
</TextView>
<EditText
android:layout_width=”120dp”
android:inputType=”textPersonName”
android:layout_height=”wrap_content”
android:id=”@+id/editTextEditName”
android:layout_below=”@+id/buttonEditBack”
android:layout_alignLeft=”@+id/buttonEdit”>
</EditText>
<EditText
android:layout_width=”120dp”
android:inputType=”textPostalAddress”
android:layout_height=”wrap_content”
android:id=”@+id/editTextEditAddress”
android:layout_below=”@+id/editTextEditName”
android:layout_alignLeft=”@+id/editTextEditName”
android:layout_marginTop=”14dp”>
</EditText>
<EditText
android:layout_width=”120dp”
android:inputType=”phone”
android:layout_height=”wrap_content”
android:id=”@+id/editTextEditPhone”
android:layout_below=”@+id/editTextEditAddress”
android:layout_alignLeft=”@+id/editTextEditAddress”
android:layout_marginTop=”14dp”>
</EditText>
<TextView
android:id=”@+id/textViewEditPhone”
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:text=”Phone No.”
android:layout_alignTop=”@+id/editTextEditPhone”
android:layout_toRightOf=”@+id/buttonEditBack”
android:layout_marginTop=”15dp”>
</TextView>
</RelativeLayout>
Ubahlah isi coding details_users.xml menjadi seperti berikut :<?xml version=”1.0″ encoding=”utf-8″?>
<RelativeLayout
android:orientation=”vertical”
android:layout_width=”match_parent”
android:layout_height=”match_parent”>
<ImageView
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:src=”@drawable/login_icon”
android:layout_alignParentTop=”true”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”31dp”
android:id=”@+id/imageViewDetailsUserIcon”>
</ImageView>
<TextView
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:layout_below=”@+id/imageViewDetailsUserIcon”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”51dp”
android:id=”@+id/textViewDetailsName”
android:text=”Name”>
</TextView>
<TextView
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:layout_below=”@+id/textViewDetailsName”
android:layout_alignLeft=”@+id/textViewDetailsName”
android:layout_marginTop=”28dp”
android:id=”@+id/textViewDetailsAddress”
android:text=”Address”>
</TextView>
<TextView
android:layout_height=”wrap_content”
android:id=”@+id/textViewDetailsPhone”
android:layout_width=”wrap_content”
android:layout_below=”@+id/textViewDetailsAddress”
android:layout_alignLeft=”@+id/textViewDetailsAddress”
android:layout_marginTop=”28dp”
android:text=”Phone”>
</TextView>
<Button
android:layout_height=”wrap_content”
android:layout_width=”wrap_content”
android:layout_alignParentTop=”true”
android:layout_alignParentLeft=”true”
android:id=”@+id/buttonDetailsBack”
android:text=”Back”>
</Button>
<Button
android:id=”@+id/buttonEditDetails”
android:layout_width=”wrap_content”
android:layout_height=”wrap_content”
android:text=”Edit Details”
android:layout_below=”@+id/textViewDetailsPhone”
android:layout_centerHorizontal=”true”
android:layout_marginTop=”44dp”>
</Button>
</RelativeLayout>
Ubahlah isi coding DBPracticeActivity.java menjadi seperti berikut :package com.example.activity;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;
}
}
}
Ubahlah isi coding DetailsUsers.java menjadi seperti berikut :package com.example.activity;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.TextView;
public class DetailsUsers extends Activity implements OnClickListener{
private static String position = null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.details_users);
Intent intent = getIntent();
position = intent.getStringExtra(“position”);
Log.d(“value of position from intent”, position);
DatabaseHandler db = new DatabaseHandler(this);
User user = db.getUser(position);
TextView textViewDetailName = (TextView) findViewById(R.id.textViewDetailsName);
textViewDetailName.setText(user.getName());
TextView textViewDetailAddress = (TextView) findViewById(R.id.textViewDetailsAddress);
textViewDetailAddress.setText(user.getAddress());
TextView textViewDetailsPhone = (TextView) findViewById(R.id.textViewDetailsPhone);
textViewDetailsPhone.setText(user.getPhone());
Button backButton = (Button)findViewById(R.id.buttonDetailsBack);
backButton.setOnClickListener(this);
Button editButton = (Button)findViewById(R.id.buttonEditDetails);
editButton.setOnClickListener(this);
}
@Override
public void onClick(View v) {
if(v.getId() == R.id.buttonDetailsBack) {
Intent intent = new Intent(getApplicationContext(), ListUsers.class);
startActivity(intent);
}
else if(v.getId() == R.id.buttonEditDetails) {
Intent intent = new Intent(getApplicationContext(), EditUsers.class);
intent.putExtra(“position”, position);
startActivity(intent);
}
}
}
Ubahlah isi coding EditUsers.java menjadi seperti berikut :package com.example.activity;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();
}
}
}
}
Ubahlah isi coding ListUsers.java menjadi seperti berikut :package com.example.activity;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);
}
}
Ubahlah isi coding Registration.java menjadi seperti berikut :package com.example.activity;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(“”);
}
}
Ubahlah isi coding DatabaseHandler.java menjadi seperti berikut :package com.example.db;import java.util.ArrayList;
import java.util.List;
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;
public class DatabaseHandler extends SQLiteOpenHelper{
// Database Version
private static final int DATABASE_VERSION = 1;
// Database Name
private static final String DATABASE_NAME = “userDB”;
// Employee table name
private static final String TABLE_USERS = “users”;
private static String USER_ID = “user_id”;
private static String NAME = “name”;
private static String PHONE = “phone”;
private static String ADDRESS = “address”;
public DatabaseHandler(Context context) {
super(context, DATABASE_NAME, null, DATABASE_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
String CREATE_USER_TABLE = “CREATE TABLE ” + TABLE_USERS + “(“
+ USER_ID + ” INTEGER PRIMARY KEY,”
+ NAME + ” TEXT,”
+ PHONE + ” TEXT,”
+ ADDRESS + ” TEXT”
+ “)”;
db.execSQL(CREATE_USER_TABLE);
//db.close();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// Drop older table if existed
db.execSQL(“DROP TABLE IF EXISTS ” + TABLE_USERS);
// Create tables again
onCreate(db);
}
// Adding new user
public int addUser(User user)
{
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(NAME, user.getName());
values.put(ADDRESS, user.getAddress());
values.put(PHONE, user.getPhone());
// Inserting Row
int id = (int) db.insert(TABLE_USERS, null, values);
db.close(); // Closing database connection
return id;
}
//updating a existing user
public int editUser(User user, String position) {
SQLiteDatabase db = this.getWritableDatabase();
ContentValues values = new ContentValues();
values.put(NAME, user.getName());
values.put(PHONE, user.getPhone());
values.put(ADDRESS, user.getAddress());
// updating row
return db.update(TABLE_USERS, values, USER_ID + ” = ?”,
new String[] { String.valueOf(position) });
}
public User getUser(String id) {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.query(TABLE_USERS, new String[] { USER_ID,
NAME, ADDRESS, PHONE }, USER_ID + “=?”,
new String[] {String.valueOf(id)}, null, null, null, null);
if (cursor != null)
cursor.moveToFirst();
User user = new User(cursor.getString(1),
cursor.getString(2), cursor.getString(3));
db.close();
// return user
return user;
}
// LIst all users
public String[] getAllUsers() {
ArrayList<String> usersList = new ArrayList<String>();
String selectQuery = “SELECT * FROM ” + TABLE_USERS;
try {
SQLiteDatabase db = this.getReadableDatabase();
Cursor cursor = db.rawQuery(selectQuery, null);
// looping through all rows and adding to list
if (cursor.moveToFirst()) {
do {
String user = cursor.getString(1) + “, ” + cursor.getString(2) + “, ” + cursor.getString(3);
usersList.add(user);
} while (cursor.moveToNext());
}
String[] users = new String[usersList.size()];
db.close();
return (usersList.toArray(users));
}
catch(Exception e) {
Log.d(“Error in getting users from DB”, e.getMessage());
return null;
}
}
}
Ubahlah isi coding User.java menjadi seperti berikut :package com.example.db;public class User {
public User() {
super();
// TODO Auto-generated constructor stub
}
private int userId;
private String name;
private String address;
private String phone;
public User(String name, String address, String phone) {
super();
this.name = name;
this.address = address;
this.phone = phone;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getAddress() {
return address;
}
public void setAddress(String address) {
this.address = address;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
}
Hasil running
Komentar
Posting Komentar