加载中
tomcat 远程调试配置

CATALINA_OPTS="-Xdebug -Xrunjdwp:transport=dt_socket,address=60223,suspend=n,server=y"

04/12 17:41
6
easy poi 双行标题导出

List<ExcelExportEntity> entityList = new ArrayList<ExcelExportEntity>(); entityList.add(new ExcelExportEntity("姓名","studentName",20)); entityList.add(new ExcelExportEntity("班...

04/09 18:38
59
COALESCE

COALESCE

03/18 18:47
4
mysql 分组行号查询

SELECT @row_number:=CASE WHEN @customer_no = customerNumber THEN @row_number + 1 ELSE 1 END AS num, @customer_no:=customerNumber as CustomerNumber, paymentDate, ......

03/16 09:23
9
mysql 行号查询

1 SET @row_number = 0; SELECT (@row_number:=@row_number + 1) AS num, firstName, lastName FROM employees LIMIT 5; 2 SELECT (@row_number:=@row_number + 1) AS num, firstName, lastN...

03/16 09:22
1
easypoi map 多sheet导出

package cn.thinkjoy.yucai.utils; import cn.afterturn.easypoi.excel.entity.ExportParams; import cn.afterturn.easypoi.excel.entity.enmus.ExcelType; import cn.afterturn.easypoi.exc...

03/15 08:35
286
mysql 多行转多列

准备 /* Navicat Premium Data Transfer Source Server : root Source Server Type : MySQL Source Server Version : 50725 Source Host : localhost:3306 Source Schema : ......

03/13 00:26
35
mysql 生成日历

SELECT max( CASE dw WHEN 2 THEN dm END ) AS Mo, max( CASE dw WHEN 3 THEN dm END ) AS Tu, max( CASE dw WHEN 4 THEN dm END ) AS We, max( CASE dw WHEN 5 THEN dm END ) AS Th, max( C...

03/10 21:42
6
mysql 判断闰年

判断2月份是不是28天 SELECT DAY ( LAST_DAY( DATE_ADD( DATE_ADD( DATE_ADD( CURRENT_DATE, INTERVAL - DAYOFYEAR( CURRENT_DATE ) DAY ), INTERVAL 1 DAY ), INTERVAL 1 MONTH ) ) ) FROM...

03/10 19:31
12
mysql 判断一年有多少个星期一

SELECT DATE_FORMAT( DATE_ADD( CAST( CONCAT( YEAR ( NOW( ) ), '-01-01' ) AS date ), INTERVAL t500.id - 1 DAY ), '%w' ), count(*) as days FROM t500 WHERE t500.id < DATEDIFF( CAST(...

03/10 19:09
8
mysql 计算两个日期之间的工作日天数

创建透视表t500 建表 CREATE TABLE t500 ( id int(11) NOT NULL AUTO_INCREMENT, PRIMARY KEY (id) ) ENGINE=InnoDB AUTO_INCREMENT=501 DEFAULT CHARSET=latin1; 插入500条数据 CREATE DEF...

03/08 07:42
23
easy poi 简单导出

SerializeFilter[] filters = new SerializeFilter[]{simpleValueFilter}; JSONArray jsonListAll = JSONArray.parseArray(JSON.toJSONString(list,filters)); List<Map> listMap = JSONArra...

03/06 14:00
5
spring data redis pubsub demo

创建监听器 package com.ssyouxia.listener; /** Created by lianfangfang on 2019/2/28. */ import org.springframework.data.redis.connection.Message; import org.springframework.data....

spring data redis

环境 jdk 1.8 spring 5.0.12.RELEASE spring-data-redis 2.1.5.RELEASE jedis 2.10.2 要想版本不冲突太艰难了,特此说明版本 配置jedis redis.properties host = 127.0.0.1 port = 6379 timeo...

chrome 调试 websocket

首次调试第4步看不到任何数据,因为chrome websocket的Frame默认是隐藏的,需要下拉拖动把socket的panel给拉出来

02/11 14:24
38
spring stomp websocket demo

配置信息 package com.ssyouxia.config; import java.util.Map; import javax.servlet.http.HttpSession; import org.springframework.context.annotation.Configuration; import org.spring...

spring websocket demo

websocket 配置 package com.ssyouxia.config; import com.ssyouxia.handler.SpringWebSocketHandler; import com.ssyouxia.interceptors.SpringWebSocketHandlerInterceptor; import org.sp...

02/11 13:26
5
java 组装树形结构

package cn.thinkjoy.kidscare.utils; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONArray; import com.alibaba.fastjson.JSONObject; import com.alibaba.fastjson....

01/19 09:15
14
quartz 任务调度

package cn.thinkjoy.dataInsight.starter; import cn.thinkjoy.dataInsight.domain.Task; import cn.thinkjoy.dataInsight.job.TaskJob; import cn.thinkjoy.dataInsight.service.ITaskExSe...

01/09 23:15
9
拉取微信所有服务商

#!/usr/bin/python -- coding: UTF-8 -- from selenium import webdriver from selenium.webdriver.common.keys import Keys import time import sys import pymysql from selenium.common.e...

没有更多内容

加载失败,请刷新页面

返回顶部
顶部