qwer78

摘要： 1.配置 #第一数据源 spring.datasource.primary.jdbc-url=jdbc:sqlserver://192.168.1.159\\aaa:1433;database=dataserver spring.datasource.primary.username=sa spri 阅读全文

摘要： 1.docker stats 命令查看服务资源占用情况 获取cpu异常的容器id 60a01eab867b 2.docker exec -it 60a01eab867b /bin/bash 命令进入容器 3.top 命令查看该容器线程占用最高的进程PID 1 4.ps -mp 1 -o THREAD 阅读全文

摘要： SELECT SUM ( CASE WHEN area_name IS NULL THEN 0 ELSE 1 END ) AS '有值', COUNT ( id ) AS "总数" FROM beike_property 阅读全文

摘要： SELECT DISTINCT ( object_id ) FROM ( SELECT TOP 100 PERCENT a.*, b.cnt FROM weChat_share a LEFT JOIN ( SELECT object_id, COUNT ( object_id ) cnt FROM 阅读全文

摘要： import com.alibaba.fastjson.JSONObject; import com.google.common.util.concurrent.RateLimiter; import org.slf4j.Logger; import org.slf4j.LoggerFactory; 阅读全文

摘要： SELECT COUNT ( [size] ) num FROM crawler_publish_property WHERE CAST ( ISNULL( [size], 0 ) AS NUMERIC ( 10, 2 ) ) >= 0 AND CAST ( ISNULL( [size], 0 ) 阅读全文

摘要： SELECT t1.num, t1.estate_name AS ename, t2.* FROM ( SELECT TOP 100 PERCENT COUNT ( estate_name ) num, estate_name FROM crawler_property GROUP BY estat 阅读全文

摘要： public static String jsoupEntity(String url1) { InputStream is = null; BufferedReader buffer = null; try { String[] ips = newIp();//获取自定义ip 127.0.0.1: 阅读全文

摘要： SELECT type, CONVERT ( VARCHAR ( 100 ), t.create_time, 23 ) [date], COUNT ( id ) num FROM crawler_property t WHERE 1 = 1 GROUP BY type, CONVERT ( VARC 阅读全文

摘要： redis-cli -h 192.168.3.4 -a 123456 keys user:id:* | xargs redis-cli -h 192.168.3.4 -a 123456 del 阅读全文