android sqlite 项目

发布于 2024-10-26 00:51:58 字数 884 浏览 2 评论 0原文

大家好，我有这个 android sqlite 代码来读取表中的所有标题，该代码位于 DBHelper.java 中

//---retrieves all the titles---
    public Cursor getAllTitles() 
    {
        return db.query(DATABASE_TABLE, new String[] {
                KEY_ROWID, 
                KEY_BOOK,
                KEY_AUTHOR,
                KEY_EDITION,    
                KEY_YEAR,
                 KEY_RETURNDATE}, 
                null, 
                null, 
                null, 
                null, 
                null);

，这是我的主应用程序中的代码......

//---get all titles---
        db.open();
        Cursor c = db.getAllTitles();
        if (c.moveToFirst())
        {
            do {          
                DisplayTitle(c);
            } while (c.moveToNext());
        }

我的问题是我想获取例如返回日期，以便我可以将其与当前时间进行比较，并基于此我将采取行动

，以便我可以读取它..buffer[5]并比较它....???

原文

hi to all i have this android sqlite code to read all the titles from a table and this code is in the DBHelper.java

//---retrieves all the titles---
    public Cursor getAllTitles() 
    {
        return db.query(DATABASE_TABLE, new String[] {
                KEY_ROWID, 
                KEY_BOOK,
                KEY_AUTHOR,
                KEY_EDITION,    
                KEY_YEAR,
                 KEY_RETURNDATE}, 
                null, 
                null, 
                null, 
                null, 
                null);

and this is the code in my main app.....

//---get all titles---
        db.open();
        Cursor c = db.getAllTitles();
        if (c.moveToFirst())
        {
            do {          
                DisplayTitle(c);
            } while (c.moveToNext());
        }

my question is that i want to get for example the returendate so i can compare it to the current time and based on that i will make an action

so can i read it ....buffer[5] and compare it....???

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

最好是你 2024-11-02 00:51:58

假设您的返回日期是一个字符串，您可以在 DisplayTitle(cursor c) 中使用以下内容：

String returnDate = c.getString(c.getColumnIndex(KEY_RETURNDATE));

Assuming your return date is a string, you can use the following in your DisplayTitle(cursor c) :

String returnDate = c.getString(c.getColumnIndex(KEY_RETURNDATE));

回复收藏 0 原文

情魔剑神 2024-11-02 00:51:58

public void doWork()
    {
        db.open();
        Cursor c = db.getAllTitles();
        if(c==null)
            return;


        for(c.moveToFirst();!c.isAfterLast();c.moveToNext())
        {

          String key= c.getString(c.getColumnIndex(c.getColumnName(5)));
          //and now you can put the condition to compare current time with key

        }

    }

public void doWork()
    {
        db.open();
        Cursor c = db.getAllTitles();
        if(c==null)
            return;


        for(c.moveToFirst();!c.isAfterLast();c.moveToNext())
        {

          String key= c.getString(c.getColumnIndex(c.getColumnName(5)));
          //and now you can put the condition to compare current time with key

        }

    }

回复收藏 0 原文