Android Programming - Fast Way Preserving Sqlite Db

Actually this is some snippet I found from browsing, the guy who must be credited to this code is Omar Flores, sorry I can't found your link pal :).
It helping me to copy already made SQLite database to my application, it make my job simpler, do not need to fill the database by coding in my Db Helper. And it really fast too, no lag in the runtime.
public class assets extends Activity
 {

        @Override
        protected void onCreate(Bundle icicle)    {
            super.onCreate(icicle);
            // use your own layout :p
            setContentView(R.layout.main);
            try {
                // Open the file
                InputStream in = getAssets().open("yourDB");
                // Open the output file, remember the package name :)
                String outFilename = "/data/data/com.assets/databases/yourDB";
                OutputStream out = new FileOutputStream(outFilename);
                // Transfer bytes from the input file to the output file
                byte[] buf = new byte[1024];
                int len;
                while ((len = in.read(buf)) > 0) {
                    out.write(buf, 0, len);
                }
                // Close the streams
                out.close();
                in.close();
            } catch (IOException e) {
                }
            Toast(this, "File Copied", TOAST.SHORT).show;
        }

 }

Simple code isn't it? But really helpful for me. In my application then I make some additional code to make it just run once, when application first started after install. ^_^

Read More

Android Programming - Spinner from Database

Spinner is Android UI that looks like dropdown menu in another UI. Like in the other programming language we can directly add Spinner content directly, by hard coding,not dynamic.
To add spinner content dynamically you need CursorAdapter. I'll make my spinner load content dynamically with SimpleCursorAdapter.

Cursor cClass = dbHelper.fetchAllClass();
        startManagingCursor(cClass);
        SimpleCursorAdapter scaClass = new SimpleCursorAdapter(this, android.R.layout.simple_spinner_item, cClass, new String[] {GSDbAdapter.KEY_CLASS}, new int[]{android.R.id.text1});
        scaClass.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
        classSpinner = (Spinner) findViewById(R.id.id_class);
        classSpinner.setAdapter(scaClass);

Cursor cClass come from database query fetchAllClass, then I create SimpleCursorAdapter named scaClass. This adapter will use template from default android layout simple_spinner_item, containing value from KEY_CLASS column in database that will be placed to TextView with id text1.
Then I set the drop drown view resource using layout simple_spinner_dropdown and finally find the spinner Id and add the SimpleCursorAdapter to it.

Note : to make this code work you need database helper class and tempate for your activity. :)

Read More