2cZwjW3K

1Why I am not getting any result from rawQuery method in android
2public class AddData {
3
4public static final String TAG = DbHelper.class.getSimpleName();
5public static final String DB_NAME = "Grup.db";
6public static final int DB_VERSION = 1;
7public static final String TABLE = "Grups";
8public static final String C_ID = BaseColumns._ID;
9public static final String C_CREATED_AT = "easy_ass_created_At";
10public static final String C_NAME = "name";
11private DbHelper ourHelper;
12private final Context ourContext;
13private SQLiteDatabase ourDatabase;
14
15public class DbHelper extends SQLiteOpenHelper {
16
17    // public static final String TAG = DbHelper.class.getSimpleName();
18    // public static final String DB_NAME = "Grup.db";
19    // public static final int DB_VERSION = 1;
20    // public static final String TABLE = "Grups";
21    // public static final String C_ID = BaseColumns._ID;
22    // public static final String C_CREATED_AT = "easy_ass_created_At";
23    // public static final String C_NAME = "name";
24
25    public DbHelper(Context context) {
26        super(context, DB_NAME, null, DB_VERSION);
27
28    }
29
30    @Override
31    public void onCreate(SQLiteDatabase db) {
32
33        String sql = ("create table " + TABLE + " ( " + C_ID
34                + " integer primary key autoincrement, " + C_NAME
35                + " text not null" + ");");
36        db.execSQL(sql);
37        Log.d(TAG, "OnCreate sql" + sql);
38
39    }
40
41    @Override
42    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
43        db.execSQL("drop table if exists " + TABLE);
44        this.onCreate(db);
45        Log.d("TAG", "********On Upgrate Drop Table*****");
46
47    }
48
49}
50
51public AddData(Context context) {
52    ourContext = context;
53
54}
55
56public AddData open() throws SQLException {
57
58    ourHelper = new DbHelper(ourContext);
59    ourDatabase = ourHelper.getReadableDatabase();
60    return this;
61}
62
63public void close() {
64    ourHelper.close();
65}
66
67public long createEntry(String name) {
68    ContentValues cv = new ContentValues();
69    cv.put(C_NAME, name);
70    return ourDatabase.insert(TABLE, null, cv);
71}
72
73public String getData() {
74
75    String[] columns = new String[] { C_ID, C_NAME };
76    Cursor c = ourDatabase.query(TABLE, columns, null, null, null, null,
77            null);
78    String result = "";
79    // int iRow=c.getColumnIndex(C_ID);
80    int iName = c.getColumnIndex(C_NAME);
81
82    // for(c.moveToFirst();!c.isAfterLast();c.moveToLast()){
83    for (boolean hasItem = c.moveToFirst(); hasItem; hasItem = c
84            .moveToNext()) {
85        result = result + "   " + c.getString(iName) + "n";
86        c.moveToNext();
87    }
88    c.close();
89    return result;
90
91}
92
93public ArrayList<String> fatchData() {
94
95
96
97    ArrayList<String> results = new ArrayList<String>();
98    try {
99        Cursor c = ourDatabase.rawQuery("SELECT * from Grups;", null);
100        if (c != null) {
101            if (c.moveToFirst()) {
102                do {
103                    String firstName = c.getString(c.getColumnIndex("name"));
104                    results.add("Project: " + firstName);
105                } while (c.moveToNext());
106            }
107        }
108    } catch (Exception e) {
109
110        e.printStackTrace();
111    }finally {
112        if (ourDatabase != null) 
113            ourDatabase.execSQL("DELETE FROM Grups");
114            ourDatabase.close();
115    }
116    return results;
117
118}
119
120}