English 中文(简体)
获取 sqlite 单行列中的列值
原标题:retrieving the value of a column in a single row for sqlite

试图获取“ 值” 列的值, 其中“ 选项” 列是 = = “ 最后单击 ”, 用于我的和机器人应用程序 。

这是我的函数代码:

public String getLastClick() {
    SQLiteDatabase db = this.getReadableDatabase();
    Cursor cursor = db.rawQuery("SELECT value FROM config where option= lastclick ", null);
    cursor.moveToFirst();
    return cursor.getString(0);
}

它似乎没有正确运行... 我对一个有条件的语句使用以下代码, 它从不承认字符串为 0, 即使我第一次在 VD 上安装应用程序, 我的在 Create 函数在数据库中插入一行, 并加上“ 0 ” 的“ 最后点击” 值 。

不管怎么说,这里就是这个代码:

    DatabaseHandler db = new DatabaseHandler(this);
    String lastClick = db.getLastClick();

    // check if its the first time they ve ever clicked
    if (lastClick != "0") {
        String millis = String.valueOf(Long.parseLong(dateString) - Long.parseLong(lastClick));
        db.insertRecord(millis);
    }

"选择"和"价值"都是瓦尔查的

最佳回答

比较 Strings 的正确方式是使用 evols 方法, 而不是:

if (lastClick != "0") {

写入 :

if (!lastClick.equals("0")) {
问题回答

暂无回答




相关问题
Android - ListView fling gesture triggers context menu

I m relatively new to Android development. I m developing an app with a ListView. I ve followed the info in #1338475 and have my app recognizing the fling gesture, but after the gesture is complete, ...

AsyncTask and error handling on Android

I m converting my code from using Handler to AsyncTask. The latter is great at what it does - asynchronous updates and handling of results in the main UI thread. What s unclear to me is how to handle ...

Android intent filter for a particular file extension?

I want to be able to download a file with a particular extension from the net, and have it passed to my application to deal with it, but I haven t been able to figure out the intent filter. The ...

Android & Web: What is the equivalent style for the web?

I am quite impressed by the workflow I follow when developing Android applications: Define a layout in an xml file and then write all the code in a code-behind style. Is there an equivalent style for ...

TiledLayer equivalent in Android [duplicate]

To draw landscapes, backgrounds with patterns etc, we used TiledLayer in J2ME. Is there an android counterpart for that. Does android provide an option to set such tiled patterns in the layout XML?

Using Repo with Msysgit

When following the Android Open Source Project instructions on installing repo for use with Git, after running the repo init command, I run into this error: /c/Users/Andrew Rabon/bin/repo: line ...

Android "single top" launch mode and onNewIntent method

I read in the Android documentation that by setting my Activity s launchMode property to singleTop OR by adding the FLAG_ACTIVITY_SINGLE_TOP flag to my Intent, that calling startActivity(intent) would ...

From Web Development to Android Development

I have pretty good skills in PHP , Mysql and Javascript for a junior developer. If I wanted to try my hand as Android Development do you think I might find it tough ? Also what new languages would I ...

热门标签