I've been struggling with this for a bit now and I would like to see
if anyone could point me in the right direction. First off, I'm
developing this with 1.5 as a target so I will be using some
depreciated methods. I have been working through the book "Android
Apps for Absolute Beginners" not because I don't know how to program,
but because it's the only book I could get my hands on. Anyhow, when I
got to chapter 10, the one where they start talking about connecting
to a database to quere, add, update, and delete records, I decide to
get creative.
Right now, I have a basic ui conisiting of four buttons; query
(displays all the contacts in toast messages), add (puts a contact
into the database with the name in the "contactName" edit text and
phone number in the "contactPhone" edit text), update (takes the name
of a contact from the "contactName" edit text and attempts to update
the number when a contact is found with that name), and delete (finds
a contact with the name from the "contactName" editText and deletes
the record).
So far, I have query and add working properly. However, my update
button does not work and throws an error. I've tried a few different,
what I thought was, creative solutions. So far I have nothing.
I'll post my latest attempt to get this to work and any feedback would
be greatly appreciated.
<code>
package content.providers;
import android.app.Activity;
import android.os.Bundle;
import android.widget.*;
import android.telephony.PhoneNumberUtils;
import android.view.View;
import android.view.View.OnClickListener;
import android.net.Uri;
import android.database.Cursor;
import android.provider.Contacts.People;
import android.content.ContentUris;
import android.content.ContentValues;
public class DatabaseProviders extends Activity
{
// Called when the activity is first created.
@Override
public void onCreate(Bundle savedInstanceState)
{
// make instance of database providers and call main
super.onCreate(savedInstanceState);
setContentView(R.layout.main);
// create instances of the phone objects
// buttons
Button queryButton = (Button)findViewById(R.id.queryButton);
Button addContactButton =
(Button)findViewById(R.id.addContactButton);
Button updateContactButton =
(Button)findViewById(R.id.updateContactButton);
Button deleteContactButton =
(Button)findViewById(R.id.deleteContactButton);
// edit text
final EditText contactName =
(EditText)findViewById(R.id.contactName);
final EditText contactPhone =
(EditText)findViewById(R.id.contactPhone);
// on queryButton click
queryButton.setOnClickListener(new OnClickListener()
{
public void onClick(View view)
{
queryContacts();
}
});
// on addContactButton click
addContactButton.setOnClickListener(new OnClickListener()
{
public void onClick(View view)
{
// format the number to be proper NANP
PhoneNumberUtils.formatNanpNumber(contactPhone.getEditableText());
addContact(contactName.getText().toString(),
contactPhone.getText().toString());
}
});
// on updateContactButton click
updateContactButton.setOnClickListener(new OnClickListener()
{
public void onClick(View view)
{
// format the number to be proper NANP
PhoneNumberUtils.formatNanpNumber(contactPhone.getEditableText());
updateContact(contactName.getText().toString(),
contactPhone.getText().toString());
}
});
// on deleteContactButton click
deleteContactButton.setOnClickListener(new OnClickListener()
{
public void onClick(View view)
{
deleteContact(contactName.getText().toString());
}
});
}
protected void queryContacts()
{
// load projection and base uri for people table in contact
database
String[] cols = new String[] {People.NAME, People.NUMBER};
// run query
Cursor mqCur =
managedQuery(People.CONTENT_URI,cols,null,null,null);
// move to first record if database isn't empty
if (mqCur.moveToFirst())
{
// Declare values to hold field values
String myname = null;
String mynumber = null;
do
{
// get field values
myname =
mqCur.getString(mqCur.getColumnIndex(People.NAME));
mynumber =
mqCur.getString(mqCur.getColumnIndex(People.NUMBER));
// show the record
Toast.makeText(this, myname + " " + mynumber,
Toast.LENGTH_SHORT).show();
} while (mqCur.moveToNext()); // repeat loop if more
records exist
}
}
protected void addContact(String newName, String newPhone)
{
// declare ContentValues and ContentUri
ContentValues values = new ContentValues();
Uri phoneUri = null;
// Add contactName to the ContentValues then add ContentValues
to
the database
values.put(People.NAME, newName);
Uri contentUri = getContentResolver().insert(People.CONTENT_URI,
values);
/** Add a phone number for the Contact. Begin with the URI for
the new record just returned by insert(); it ends with
the _ID
of the new record, so we don't have to add the ID
ourselves.
Then append the designation for the phone table to this
URI,
and use the resulting URI to insert the phone number. */
phoneUri = Uri.withAppendedPath(contentUri,
People.Phones.CONTENT_DIRECTORY);
// clear ContentValues then Add contactNumber to the
ContentValues
values.clear();
values.put(People.Phones.TYPE, People.TYPE_MOBILE);
values.put(People.Phones.NUMBER, newPhone);
// add content values to the database
getContentResolver().insert(phoneUri, values);
// display success and contact
Toast.makeText(this, "Success! Added Record: " + newName + " " +
newPhone, Toast.LENGTH_SHORT).show();
}
protected void updateContact(String contactName, String newPhone)
{
// Declare columns to return
String[] cols = new String[] {People._ID, People.NAME,
People.NUMBER};
// create an sql string then run sql query
String sqlQuery = "Name = '" + contactName + "'";
Cursor mqCur =
managedQuery(People.CONTENT_URI,cols,sqlQuery,null,null);
// move to first record if database isn't empty
if (mqCur.moveToFirst())
{
// declare ContentValues and ContentUri
ContentValues values = new ContentValues();
// Declare values to hold field values
int myID = 0;
do
{
// get field values
myID =
Integer.parseInt(mqCur.getString(mqCur.getColumnIndex(People._ID)));
// create a phoneUri which contains the proper
_ID for the record
we wish to change
Uri myPerson =
ContentUris.withAppendedId(People.CONTENT_URI,
myID);
// clear ContentValues then Add contactNumber
to the ContentValues
values.clear();
values.put(People.Phones.TYPE,
People.TYPE_MOBILE);
values.put(People.Phones.NUMBER, newPhone);
// update the record
getContentResolver().update(myPerson, values,
null, null);
// show the record
Toast.makeText(this, "Updated Record: " + myID,
Toast.LENGTH_SHORT).show();
Toast.makeText(this, contactName + " " +
newPhone,
Toast.LENGTH_SHORT).show();
} while (mqCur.moveToNext()); // repeat loop if more
records exist
}
else
{
// no records found
Toast.makeText(this, "No records found",
Toast.LENGTH_SHORT).show();
}
}
protected void deleteContact(String contactName)
{
// TODO Auto-generated method stub
}
}
</code>
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
