I’m moving away from using the Android email client in Note To Me, but wanted to share the snippet to launch the client.  And who knows, maybe I’ll add it back in if people want it as an option.

        Button sendBtn = (Button) findViewById(R.id.send_btn_id);
        sendBtn.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v)
            {
            	Intent emailIntent = new Intent(android.content.Intent.ACTION_SEND);
            	emailIntent.setType("text/html");
            	emailIntent.putExtra(android.content.Intent.EXTRA_EMAIL,
                  new String[]{ sendToAddress } );

            	emailIntent.putExtra(android.content.Intent.EXTRA_SUBJECT, subject );
            	emailIntent.putExtra(android.content.Intent.EXTRA_TEXT, msg );

            	hideKeyboard();

            	NoteToMe.this.startActivity(emailIntent);
            	NoteToMe.this.finish();
            }
        });

I’m pretty syched about this code.  It took some figuring out and some hunting and asking questions on Google’s Android forum.  But thanks to the following posts

 File permissions for world read/write

SQLite3 sql command to show tables in database

I pieced together the beginnings of some code that will take an Android SQLite db and export it to XML data within a file on the SD Card.  This has a couple potential uses,

(more…)

FIRST POST OF 2009!!

Threw this Android Activity together really quickly to see if I understood the different ways of getting a web page to launch.  The first three examples perform the same functionality, the Linkify.addLink call builds a means of launching an Intent.ACTION_VIEW.  The fourth example loads the url into a WebView in the layout.

(more…)

Used a SimpleAdapter.ViewBinder the other day.  ViewBinders allow another way of attaching data to an Adapter.  I needed to capture an onClick event from a row in a ListActivity and fire a corresponding Intent to open a new Activity; basically mimicking the behavior of the API Demos Google provides in the Android SDK.

(more…)

I’m tired of rewriting these, so here’s a simple set of boilerplate methods to CRUD objects for an Android SQLite3 db for your copy and pasting pleasure.

    public long createThing(String name)
    {
        ContentValues initialValues = new ContentValues();
        initialValues.put(KEY_NAME, name);

        return mDb.insert(THINGS_TABLE, null, initialValues);
    }

    public boolean updateThing(long rowId, String name)
    {
        ContentValues args = new ContentValues();
        args.put(KEY_NAME, name);

        return mDb.update(THINGS_TABLE, args, KEY_ROWID + "=" + rowId, null) > 0;
    }

    public boolean deleteThing(long rowId)
    {
        return mDb.delete(THINGS_TABLE, KEY_ROWID + "=" + rowId, null) > 0;
    }

    public Cursor fetchThing(long rowId)
    {
    	String query = KEY_ROWID + "=" + rowId;
        Cursor mCursor =
                mDb.query(true, THINGS_TABLE,
                		new String[] {KEY_ROWID, KEY_NAME},
                		query,
                        null, null, null, null, null);

        if (mCursor != null)
        {
            mCursor.moveToFirst();
        }

        return mCursor;
    }

    public Cursor fetchAllThings()
    {
        return mDb.query(THINGS_TABLE,
        		new String[] {KEY_ROWID, KEY_NAME},
        		null, null, null, null, null);
    }

I’ve been working through Ed Burnette’s book, “Hello, Andorid” and it’s given me a number of new tricks already; I’m only about a quarter of the way through.  One of the changes I made for my Android game Jumpy was to move the programmatic building of the menu to a menu.xml file instead, as Mr. Burnette describes in Chapter 3 of his book.

(more…)

With T-Mobiles data roaming issue out there for Android developers to worry about, it seems like programs accessing the web for data should be checking the DATA_ROAMING System Setting before they acquire their data.  The Activity below accesses and displays the result of the Setting.

I’m not a lawyer, but I do feel like I need to state that if your program still incurs roaming charges for the user, please don’t send them to me if you use this code bit.  Please thoroughly  test your code before you deploy!!  Just as a note, I had to install this on my G1 to test it because I couldn’t access the Setting directory from the Android Emulator.
(more…)

Wrote this real quick Android ListActivity to display the Resources from the android.R.drawable.  Not very pretty, but I just wanted something to display the images and show the associated Resource id.  Sorry in advance for any wacky formatting issues due to cutting and pasting from Eclipse into the WordPress editor.

(more…)

public int calculateTotalSalaryForEmployees( long[] departmentIds )
{
    int total = 0;
    // create a list of ids to use in the IN statement
    // Arrays.toString creates String which looks like [1,2,3]
    String deptlist = Arrays.toString( departmentIds );

    // remove the enclosing brackets from id list
    String inClause = deptlist.substring( 1, deptlist.length() - 1 );
    String sql = "select sum(salary) from employees where department_id " +
        "in (" + inClause + ")";

    Cursor c = mDb.rawQuery( sql, null );
    // move to the first row of the cursor
    c.moveToFirst();
    total = c.getInt(0);
    c.close();

    return total;
}

Trying something new out here. As I’m programming I find many little hints and tips that I want to remember or share. Not the longer more in-depth posts I’ve been trying out with the subjects on Android HTTP and Ruby on Rails, but little quick things to put into ones toolbox.

So here’s the first one, a little method to retrieve the sum of all the salaries of employees within a department.  It utilizes the SQL SUM and IN commands.  It was surprisingly difficult to find the exact way to perform these command, but surprisingly obvious and easy once I figured it out.  Just the types of little tools I don’t want to loose.

Had to hunt around for this in the Android documentation so I thought I’d mention it in case anyone else could utilize it.  In my new shopping list application I want to display dynamic information in the title bar and didn’t want to display the default title bar.  I knew it could be done from looking at the application view screen on the Android Market. There is a flag in the Window class to hide the title bar, and it’s placed in the onCreate method of an Activity.

@Override
protected void onCreate(Bundle savedInstanceState)
{
    super.onCreate(savedInstanceState);

    requestWindowFeature(Window.FEATURE_NO_TITLE);
    ...

I was expecting to find a setter method in either the Activity or the View class.  After hiding the title bar, I simply added a TableLayout to the top of my View to display the information.

I’m not exactly sure what the relationship is of the Window to the View or the Activity other then what is already documented in the Window API and Google’s glossary for Android, maybe I’ll get some time in the future to poke around a bit more.