摘要： SELECT * FROM workorder_role_skill WHERE (roleCode, skillCode) IN ( SELECT roleCode,skillCode FROM workorder_role_skill GROUP BY roleCode,skillCode HA 阅读全文

摘要： select w.woType, 'NO_HIS' as dataFromfrom workorder_complet_info wwhere w.workOrderNo = 'xxxxxx'union all select w.woType, 'HIS' as dataFromfrom worko 阅读全文

摘要： 一,先创建交换器(exchange) 其中type ,类型与代码中的模式相匹配 二,创建TTL DLX 队列 注意点: 此处的Bingings 的Routing key 与上面的Details-->Parameters中的 x-dead-letter-routing-key 不能一样,否则会有 "多 阅读全文

摘要： 标红的位置要配置上 阅读全文

摘要： [mysql]# 设置mysql客户端默认字符集default-character-set=utf8mb4[mysqld]#设置3306端口port = 3306# 设置mysql的安装目录basedir="C:\Program Files\MySQL\mysql-8.0.12-winx64"# 设 阅读全文

摘要： 正序： select * from table_name ORDER BY CONVERT(name USING gbk); 倒序：select * from table_name ORDER BY CONVERT(name USING gb2312) desc 参考网站http://www.2ct 阅读全文

摘要： package com.vanke.sampling.dao; import com.gexin.rp.sdk.base.uitls.RandomUtil; import com.google.common.collect.Lists; import java.text.SimpleDateForm 阅读全文

摘要： function completeDate(time1 , time2 , m) { var diffyear = time2.getFullYear() - time1.getFullYear() ; var diffmonth = diffyear * 12 + time2.getMonth() 阅读全文

摘要： /** * 校验字符串是否在规定字符数内 * @param str * @param maxLength * @return */public static boolean isOver(String str,Integer maxLength) { try { int length = str.g 阅读全文

摘要： public class hello { public static void main(String[] args) { System.out.println(isIDNumber("xxxxxxxxxxxxx")); } public static boolean isIDNumber(Stri 阅读全文