java - 从 Objective C 到 java 的 SQLite 查询

Question

我正在尝试将一些 Objective C 代码翻译成 Android 的 java 版本。我是 Android 新手，如果有人可以帮助我，我该如何执行这些查询。

以下代码位于 Objective C 中

 private int getNextAccountIdForUserId (String userId, AccountType accountType)
    {
        int nextId = kFirstIDValue;  //initial value is 0;
        String queryString = "SELECT MAX(accountId) FROM MAAccounts WHERE userId = ? AND accountType = ?";
        ResultSet resultSet = [_db executeQuery:queryString, [self stringToDB:userId], [self integerToDB:accountType], nil];
        if([resultSet next])
        {
            int currentMax = [resultSet intForColumnIndex:0];

            nextId = currentMax + 1;
        }

        [resultSet close];

        return  nextId;

    }

如果有人可以告诉我如何在 java sqlite 中执行此查询。

String queryString = "SELECT MAX(accountId) FROM MAAccounts WHERE userId = ? AND accountType = ?";

Answer 1

你会使用这样的东西

String[] whereVars = new String[] {userId, accountType};
String queryString = "SELECT MAX(accountId) FROM MAAccounts WHERE userId = ? AND accountType = ?";
Cursor cursor = dbHandle.rawQuery(queryString, whereVars);