Dao.java

package com.txsc.dao;

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

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

import com.txsc.bean.SortBaseBean;

public class Dao {

	public static List<SortBaseBean> getList(Context context, String parentid) {
		List<SortBaseBean> list = new ArrayList<SortBaseBean>();
		DbOpenHelper helper = new DbOpenHelper(context);
		SQLiteDatabase db = helper.getReadableDatabase();
		Cursor cursor = db.rawQuery("select * from sort where g_parentid = '"
				+ parentid + "'", null);
		cursor.moveToFirst();
		while (!cursor.isAfterLast()) {
			String g_sortid = cursor.getString(cursor
					.getColumnIndex("g_sortid"));
			String g_sortname = cursor.getString(cursor
					.getColumnIndex("g_sortname"));
			String g_parentid = cursor.getString(cursor
					.getColumnIndex("g_parentid"));
			SortBaseBean bean = new SortBaseBean(g_sortid, g_sortname,
					g_parentid);
			list.add(bean);
			cursor.moveToNext();
		}
		cursor.close();
		db.close();
		return list;
	}

	public static boolean isExit(Context context) {
		boolean result = false;
		DbOpenHelper helper = new DbOpenHelper(context);
		SQLiteDatabase db = helper.getReadableDatabase();
		Cursor cursor = null;
		try {
			String sql = "select * from 'sort' ";
			cursor = db.rawQuery(sql, null);
			if (cursor.moveToNext()) {
				result = true;
			}

		} catch (Exception e) {
		}
		cursor.close();
		db.close();
		return result;
	}
}