摘要: SELECT count(1) from energy_alarm_loss_info where hier_id = #{hierId} and date_type = #{dateType} <if test="dateType == '日'.toString()"> and date(crea 阅读全文
posted @ 2025-04-25 15:12 十一点 阅读(333) 评论(0) 推荐(0)
摘要: -- 用FIND_IN_SET(state,'0,1,4,2,3,5,6') 可以按照指定的'0,1,4,2,3,5,6'状态进行排序 SELECT * FROM qua_prod_return ORDER BY FIND_IN_SET(state,'0,1,4,2,3,5,6'), prod_re 阅读全文
posted @ 2023-11-16 09:06 十一点 阅读(576) 评论(0) 推荐(0)
摘要: 在相关字段上加上注解 @TableField(updateStrategy = FieldStrategy.IGNORED) 如: @TableField(updateStrategy = FieldStrategy.IGNORED)@ApiModelProperty(value = "检验结果2: 阅读全文
posted @ 2023-11-14 17:50 十一点 阅读(197) 评论(0) 推荐(0)
摘要: class UserPo { private String name; private Double score; } List<UserPo> list = new ArrayList<>(); list.add(new UserPo(1L,"小一", 10.d)); list.add(new U 阅读全文
posted @ 2023-11-01 10:57 十一点 阅读(83) 评论(0) 推荐(0)
摘要: // 用stripTrailingZeros()去掉末尾的0// 用toPlainString() 避免输出科学计数法 BigDecimal produceQty = produceWorkLog.getProduceQty(); produceQty.stripTrailingZeros().to 阅读全文
posted @ 2023-10-31 15:13 十一点 阅读(358) 评论(0) 推荐(0)
摘要: // list转数组 Long[] ids = updateIds.toArray(new Long[updateIds.size()]) // 数组转list List<String> reasonList = Arrays.asList(perm.trim().split(",")) // St 阅读全文
posted @ 2023-10-30 14:22 十一点 阅读(30) 评论(0) 推荐(0)