BaseTable.java

package org.softeg.slartus.forpdaplus.db;

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

import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;

/**
 * Created by IntelliJ IDEA.
 * User: slinkin
 * Date: 22.11.12
 * Time: 10:59
 * To change this template use File | Settings | File Templates.
 */
public class BaseTable {

    public static String getDateString(Date date) {
        return new SimpleDateFormat("yyyy.MM.dd HH:mm:ss").format(date);
    }

    public static Date parseDate(String val) throws ParseException {
        return new SimpleDateFormat("yyyy.MM.dd HH:mm:ss").parse(val);
    }

    public static int getRowsCount(SQLiteDatabase db, String tableName) {
        Cursor mcursor = null;
        try {
            String query = "SELECT count(*) FROM " + tableName;
            mcursor = db.rawQuery(query, null);

            mcursor.moveToFirst();
            return mcursor.getInt(0);
        } finally {
            mcursor.close();
        }
    }
}