java处理字符串、分隔字符串、数据库in拼接字符串工具类。项目中用的非常实用,分享给大家(文章底部提供工具类下载)
public class CommonTool { private CommonTool() { } private static class CommonToolHandler { private static CommonTool commonTool = new CommonTool(); } public static CommonTool getInstance() { return CommonToolHandler.commonTool; } public String listToString(List<String> stringList) { if (stringList == null) { return null; } StringBuilder result = new StringBuilder(); boolean flag = false; for (String string : stringList) { if (flag) { result.append(","); } else { flag = true; } result.append(string); } return result.toString(); } public String listToString(List<String> stringList, String sliptFlag) { if (stringList == null) { return null; } StringBuilder result = new StringBuilder(); boolean flag = false; for (String string : stringList) { if (flag) { result.append(sliptFlag); } else { flag = true; } result.append(string); } return result.toString(); } public List<String> stringToList(String strings, String sliptFlag) { if (strings == null||strings.equals("")) { return null; } List<String> strList = new ArrayList<String>(); for (String string : strings.split(sliptFlag)) { strList.add(string); } return strList; } public String getOracleSQLIn(List<String> ids, String field) { StringBuilder builder = new StringBuilder(); if (ids.size() > 0) { int minNum = Math.min(ids.size(), 1000); int len = ids.size(); int size = len % minNum; if (size == 0) { size = len / minNum; } else { size = (len / minNum) + 1; } for (int i = 0; i < size; i++) { int fromIndex = i * minNum; int toIndex = Math.min(fromIndex + minNum, len); String productId = StringUtils.defaultIfEmpty(StringUtils.join(ids.subList(fromIndex, toIndex), "','"), ""); if (i != 0) { builder.append(" or "); } builder.append(field).append(" in ('").append(productId).append("')"); } return "(" + builder.toString() + ")"; } return "(" + field + " in ('')" + ")"; } public String getOracleSQLNotIn(List<String> ids, String field) { StringBuilder builder = new StringBuilder(); if (ids.size() > 0) { int minNum = Math.min(ids.size(), 1000); int len = ids.size(); int size = len % minNum; if (size == 0) { size = len / minNum; } else { size = (len / minNum) + 1; } for (int i = 0; i < size; i++) { int fromIndex = i * minNum; int toIndex = Math.min(fromIndex + minNum, len); String productId = StringUtils.defaultIfEmpty(StringUtils.join(ids.subList(fromIndex, toIndex), "','"), ""); if (i != 0) { builder.append(" or "); } builder.append(field).append(" not in ('").append(productId).append("')"); } return "(" + builder.toString() + ")"; } return "(" + field + " not in ('')" + ")"; } }
版权声明:本站所发布的全部内容源于互联网搬运,仅供用于学习和交流,如果有侵权之处请第一时间联系我们删除。敬请谅解! E-mail:xujinxiao@126.com
评论列表
很好,感谢分享