从SQLite安卓系统提升数据价值

Question

我有问题的升序按日期...I想要分组所有的日期按listDate(日期格式)，我认为在我的代码中的一些错误。

public Cursor getAll() {
        // TODO Auto-generated method stub
        return (database.rawQuery("SELECT " + SQLiteHelper.listId + " as _id, "
                + SQLiteHelper.listName + "," + SQLiteHelper.listDate + ","
                + SQLiteHelper.listDest + " FROM " + SQLiteHelper.listTable
                + " ORDER BY " + SQLiteHelper.listDate+ "ASC",null));

    }


private static final String CREATE_SHOPPLINGLIST_TABLE = "CREATE TABLE IF NOT EXISTS "
            + listTable
            + " ("
            + listId
            + " INTEGER PRIMARY KEY AUTOINCREMENT, "
            + listName
            + " TEXT, "
            + listDest + " TEXT," + listDate + " INTEGER)";

希望任何人能纠正我的错误…

Answer 1

试试这个..。

return (database.rawQuery("SELECT " + SQLiteHelper.listId + " as _id, "
                + SQLiteHelper.listName + "," + SQLiteHelper.listDate + ","
                + SQLiteHelper.listDest + " FROM " + SQLiteHelper.listTable
                + " ORDER BY " + SQLiteHelper.listDate+ " ASC",null));

在" ASC"中留出空间。