Android Open Source - Billy Custom Database Adapter

From Project

Back to project page Billy.
License

The source code is released under:
GNU General Public License
If you think the Android project Billy listed in this page is inappropriate, such as containing malicious code/tools or violating the copyright, please email info at java2s dot com, thanks.
Java Source Code

package com.vibin.billy;
//from w  w  w .  j a  v a2  s  .co m
import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;
import android.util.Log;

public class CustomDatabaseAdapter {

    private static final String TAG = CustomDatabaseAdapter.class.getSimpleName();
    private DatabaseHelper hlp;
    //Context c;

    public CustomDatabaseAdapter(Context context) {
        //this.c = context;
        hlp = DatabaseHelper.getInstance(context);
    }

    public long insertArrayList(String data, String table) {
        Log.d(TAG, "insertArrayList called");
        SQLiteDatabase db = hlp.getWritableDatabase();
        ContentValues cv = new ContentValues();
        cv.put(DatabaseHelper.UID, 0);
        cv.put(DatabaseHelper.ArrayList, data);
        long yo = db.replace(table, null, cv);
        db.close();
        return yo;
    }

    public String getArrayList(String table) {
        Log.d(TAG, "getArrayList called");
        SQLiteDatabase db = hlp.getWritableDatabase();
        String[] columns = {DatabaseHelper.UID, DatabaseHelper.ArrayList};
        Cursor cursor = db.query(table, columns, DatabaseHelper.UID + " = '" + 0 + "'", null, null, null, null, null);
        String data = null;
        while (cursor.moveToNext()) {
            int columnIndex = cursor.getColumnIndex(DatabaseHelper.ArrayList);
            data = cursor.getString(columnIndex);
        }
        db.close();
        return data;
    }

    static class DatabaseHelper extends SQLiteOpenHelper {
        private static final int VERSION = 10;
        private static final String DATABASE_NAME = "BillyDatabase";
        private static final String[] TABLE_NAME = {"MostPopular", "Pop", "Rock", "Dance", "Metal", "RnB", "Country"};
        private static final String UID = "_id";
        private static final String ArrayList = "ArrayList";

        private static DatabaseHelper databaseHelper = null;

        /**
         * Constructor is made private intentionally. Use getInstance() instead for initiation.
         *
         * @param context Application context
         */
        private DatabaseHelper(Context context) {
            super(context, DATABASE_NAME, null, VERSION);
        }

        /**
         * Use the application context, which will ensure that you
         * don't accidentally leak an Activity's context.
         * See this article for more information: http://bit.ly/6LRzfx
         */

        public static DatabaseHelper getInstance(Context ctx) {
            if (databaseHelper == null) {
                databaseHelper = new DatabaseHelper(ctx.getApplicationContext());
            }
            return databaseHelper;
        }

        String getCreateTableString(int i) {
            return "CREATE TABLE " + TABLE_NAME[i] + " (" + UID + " TINYINT(255) PRIMARY KEY, " + ArrayList + " TEXT " + ");";
        }

        String getDropTableString(int i) {
            return "DROP TABLE IF EXISTS " + TABLE_NAME[i];
        }

        @Override
        public void onCreate(SQLiteDatabase db) {
            Log.d(TAG, "DB On Create");
            try {
                for (int i = 0; i < TABLE_NAME.length; i++) {
                    db.execSQL(getCreateTableString(i));
                }
            } catch (SQLException e) {
                Log.d(TAG, "" + e);
            }
        }

        @Override
        public void onUpgrade(SQLiteDatabase db, int i, int i2) {
            Log.d(TAG, "DB On Upgrade");

            try {
                for (int j = 0; i < TABLE_NAME.length; i++) {
                    db.execSQL(getDropTableString(j));
                }
            } catch (SQLException e) {
                Log.d(TAG, "" + e);
            }

            onCreate(db);
        }
    }
}
Java Source Code List
