package com.ttj.dao;
import java.util.ArrayList;
import java.util.List;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.ttj.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;
}
}