写这个方法背景在于,Mybatis传IN参数
1.将List<String>集合 转化为'1','2','3','4','5'
/**
* 将List<String>集合 转化为String
* 如{"aaa","bbb"} To 'aaa','bbb'
*/
public static String convertListToString(List<String> strlist){
StringBuffer sb = new StringBuffer();
if(CollectionUtils.isNotEmpty(strlist)){
for (int i=0;i<strlist.size();i++) {
if(i==0){
sb.append("'").append(strlist.get(i)).append("'");
}else{
sb.append(",").append("'").append(strlist.get(i)).append("'");
}
}
}
return sb.toString();
}
2. 将"1,2,3,4,5..."这种形式的字符串转成"'1','2','3','4'..."这种形式
/***
* 将"1,2,3,4,5..."这种形式的字符串转成List<String> 集合
* @param strs
* @return
* */
public static List<String> converStringToList(String strs) {
if (StringUtils.isNotBlank(strs)) {
String[] idStrs = strs.trim().split(",");
if (null != idStrs && idStrs.length > 0) {
List<String> strsList = new ArrayList<String>();
for (String str : idStrs) {
if (StringUtils.isNotBlank(str)) {
strsList.add(str.trim());
}
}
if (strsList.size() > 0) {
return strsList;
}
}
}
return null;
}
3.将"1,2,3,4,5..."这种形式的字符串转成List<String> 集合
/**
将"1,2,3,4,5..."这种形式的字符串转成"'1','2','3','4'..."这种形式
@param strs
@return
*/
public static String converString(String strs) {
if (StringUtils.isNotBlank(strs)) {
String[] idStrs = strs.trim().split(",");
if (null != idStrs && idStrs.length > 0) {
StringBuffer sbf = new StringBuffer("");
for (String str : idStrs) {
if (StringUtils.isNotBlank(str)) {
sbf.append("'").append(str.trim()).append("'").append(",");
}
}
if (sbf.length() > 0) {
sbf = sbf.deleteCharAt(sbf.length() - 1);
return sbf.toString();
}
}
}
return "";
}