DBUtils.java

package com.androsz.electricsleepbeta.util;

import java.util.ArrayList;
import java.util.Arrays;
import java.util.List;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;

public class DBUtils {
	/**
	 * Appends one set of selection args to another. This is useful when adding
	 * a selection argument to a user provided set. Used for API levels < 11
	 * 
	 * @param originalValues
	 * @param newValues
	 * @return
	 */
	public static String[] appendSelectionArgs(String[] originalValues, String[] newValues) {
		if (originalValues == null) {
			originalValues = new String[] {};
		}
		if (newValues == null) {
			newValues = new String[] {};
		}
		final String[] newSelectionArgs = new String[originalValues.length + newValues.length];
		System.arraycopy(originalValues, 0, newSelectionArgs, 0, originalValues.length);
		System.arraycopy(newValues, 0, newSelectionArgs, originalValues.length, newValues.length);
		return newSelectionArgs;
	}

	public static List<String> GetColumns(final SQLiteDatabase db, final String tableName) {
		List<String> ar = null;
		Cursor c = null;
		try {
			c = db.rawQuery("select * from " + tableName + " limit 1", null);
			if (c != null) {
				ar = new ArrayList<String>(Arrays.asList(c.getColumnNames()));
			}
		} catch (final Exception e) {
			e.printStackTrace();
		} finally {
			if (c != null) {
				c.close();
			}
		}
		return ar;
	}

	public static String join(final List<String> list, final String delim) {
		final StringBuilder buf = new StringBuilder();
		final int num = list.size();
		for (int i = 0; i < num; i++) {
			if (i != 0) {
				buf.append(delim);
			}
			buf.append(list.get(i));
		}
		return buf.toString();
	}
}