convertToSQL

//genSql 使用
private String convertToStr(List<String> paramsList){
    StringBuffer resultBuf = new StringBuffer();
    if(paramsList.size()==1){
        return paramsList.get(0);
    }
    for (String param : paramsList) {
        resultBuf.append("‘").append(param.trim()).append("‘").append(",");
    }
    return resultBuf.toString();
}

//全部手写sql in 使用

private String convertToStr(List<String> paramsList){
    StringBuffer resultBuf = new StringBuffer();
    for (String param : paramsList) {
        resultBuf.append("‘").append(param.trim()).append("‘").append(",");
    }
    if(resultBuf.length()>0){
        return resultBuf.substring(0,resultBuf.length()-1);
    }
    return resultBuf.toString();
}

convertToSQL

原文：https://www.cnblogs.com/fuerming/p/13324191.html