-
多值查询:
FIND_IN_SET(id,‘1,2,3,4,5’); -
字符串拼接:
StringUtils.join(array, “-”) -
日期格式化:
将String转换成Date,一般前台给后台传值时用
@DateTimeFormat(pattern = “yyyy-MM-dd HH:mm:ss”)
将Date转换成String 一般后台传值给前台时
@JsonFormat(pattern = “yyyy-MM-dd HH:mm:ss”, timezone=”GMT+8”) -
条件统计:
所有:count(*)
不含空:count(num)
包含空:count(num > 200 or null)
所有:count(`id`)
条件:COUNT(CASE WHEN result='fail' THEN 1 END)
- ibatis传参问题:
正确:
Map param = new HashMap();
param.put("optIdList", optIdList);
<iterate property="optIdList" prepend="(" close=")" conjunction=",">
#optIdList[]#
</iterate>
optIdList
<iterate prepend="(" close=")" conjunction=",">
#optIdList[]#
</iterate>
错误:
optIdList
<iterate property="optIdList" prepend="(" close=")" conjunction=",">
#optIdList[]#
</iterate>
- java8的map异常:
值不能为空:
Member member1 = new Member("1","hello");
Member member2 = new Member("2", null);
List<Member> list = Test.initMemberList();
Map<String, String> memberMap = list.stream().collect(
Collectors.toMap(Member::getId, Member::getImgPath));
key不能重复:
如果重复的话,会抛出异常
- 不可变immutable
ImmutableMap<Object, Object> map = ImmutableMap.builder().
put("id", id).
put("name", name).
build();