java - sqlite :Select query not work

Question

我有这个功能。我将一个字符串传递给该函数，它将它分成两部分。然后我将在我的选择查询中使用a[1]，它总是返回我空。最后我决定打印 query String，它是这样的:

select *  from targettree where target='t

    '

如你所知，它应该是这样的

    select *  from targettree where target='t'

函数如下:

 protected void fun(String statment) 
 {
    String[] a=statment.split("  ");



    String t=a[1].toString();
    String query = "select *  from targettree where target='"+t+"'";
    Select(query);

}

那么这是因为 split("") 还是有其他原因？

Answer 1

尝试替换

String query = "select *  from targettree where target='"+t+"'";

与

String query = "select *  from targettree where target='"+t.trim()+"'";