Android - sqlite in 子句使用数组中的字符串值? [英] Android - sqlite in clause using string values from array?

问题描述

我想执行一个 sqlite 查询，我有一个 String :

I want to execute a sqlite query, I have a String :

 String A = "AB-CDFER-GTDOL";
 String[] parts = Pattern.compile("-", Pattern.LITERAL).split(A);

现在我需要在我的 query 中使用 from parts.

Now I need to use from parts in my query.

cursor = sql.rawQuery("SELECT * FROM MyTable WHERE Comment in" + ?????, null);

如何在我的 query 中使用 parts.

How I can use from parts in my query.

例如我需要有 ("AB","CDFER","GTDOL")

推荐答案

分割后可以编译字符串:

You can compile a string after split:

         String A = "AB-CDFER-GTDOL";
         String[] parts = Pattern.compile("-", Pattern.LITERAL).split(A);
    // build the params string
    StringBuilder sb = new StringBuilder("");
    for(String param:parts){
    // you can also enclose it in quotes
    sb.append",".append('"').append(param).append('"');
    }
    // remove 1st comma from sb.
    final String params = sb.toString().substr(1);

这里的技巧是将所需的字符串编译为 "AB","CDFER","GTDOL".现在您可以将此字符串作为 ONE 参数传递.

The trick here is to compile needed string as "AB","CDFER","GTDOL". Now you can pass this string as a ONE paramenter.

cursor = sql.rawQuery("SELECT * FROM MyTable WHERE Comment in(?)", new String[]{params});

这篇关于Android - sqlite in 子句使用数组中的字符串值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！