转化字符串为sql语句的in条件

方法一：

/**
	 * 拼接in条件值
	 * @param str="a,b,c"
	 * @return 'a','b','c'
	 */
	public String getInCond(String str) {  
  		String[] strArr = str.split(",");
  		StringBuffer sb = new StringBuffer();
  		for(int i = 0;i < strArr.length; i++){
  	  		if(i == strArr.length-1){
  	  			sb.append("'"+strArr[i]+"'");
  	  		}else{
  	  			sb.append("'"+strArr[i]+"'"+",");
  	  		}
  	  	}
  	  	return sb.toString();   
  	}

方法二

 /**
     * 拼接in条件值
     * @param str= "a,b,c";
     * @return 'a', 'b', 'c'
     */
    public String getInCond(String str) {
        String[] strArr = str.split(",");
        for (int i = 0; i < strArr.length; i++) {
            strArr[i] = "'" + strArr[i] + "'";
        }
        str = StringUtils.strip(Arrays.toString(strArr), "[]");
        return str;
    }