加载中
爬取美食杰

#!/usr/bin/python -- coding: UTF-8 -- import requests import json import sys import re from bs4 import BeautifulSoup import pymysql from lxml import etree reload(sys) sys.setdef...

easy poi 双行标题导出

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

2019/04/09 18:38
2.7K
mysql 分组行号查询

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

2019/03/16 09:23
979
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...

2019/03/16 09:22
136
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...

2019/03/15 08:35
8K
mysql 多行转多列

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

2019/03/13 00:26
2.3K
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...

2019/03/10 21:42
478
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...

2019/03/10 19:31
773
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(...

2019/03/10 19:09
392
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...

2019/03/08 07:42
3.6K
easy poi 简单导出

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

2019/03/06 14:00
49
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给拉出来

2019/02/11 14:24
1.5K
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...

2019/02/11 13:56
78
spring websocket demo

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

2019/02/11 13:26
94
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....

2019/01/19 09:15
1.5K
拉取微信所有服务商

#!/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...

2019/01/07 16:02
105
爬虫微信支付服务商

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

openpyxl read excel

#!/usr/bin/python -- coding: UTF-8 -- import pymysql from openpyxl import load_workbook sql=" select * from saas_school_type where schoolId=3408260001 " updateSql=" update saas_...

2019/01/03 22:55
54

没有更多内容

加载失败,请刷新页面

返回顶部
顶部