- 博客(8)
- 收藏
- 关注
原创 springboot设置tomcat连接数
@Configurationpublic class TomcatConfig { @Value("${server.port}") public int port; @Bean public ConfigurableServletWebServerFactory configurableServletWebServerFactory(){ TomcatServletWebServerFactory tomcatFactory = new TomcatS
2021-03-09 17:22:35 1224
原创 redisConfig配置文件及spring注解方式缓存redis
@Configuration@EnableCachingpublic class RedisConfig { // redis配置 @Bean public RedisTemplate<String, Object> redisTemplate(RedisConnectionFactory factory) { RedisTemplate<String, Object> template = new RedisTemplate<S
2021-03-09 17:15:37 206
原创 java获取时间字符串
// Date 获取年月日 public static String formatYmd(Date date){ return new SimpleDateFormat("yyyy-MM-dd").format(date); } // Date 获取年月日时分秒 public static String formatYmdHms(Date date) { return new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(date);...
2021-03-09 16:55:11 492
原创 mysql曲线图当前没有的补0
查询一个月30 天数据,只显示7条 没有的补0SELECT create_time y, SUM(count) x FROM ( SELECT @cdate := DATE_ADD(@cdate, INTERVAL - 1 DAY ) `create_time`, 0 AS `count` FROM -- t_zone 数据库随便一张表,如果查询30天数据 里面必须保证有3
2021-03-09 16:41:11 101
原创 存储过程一个表查询出来的数据到另一种张表筛选查询
drop procedure if exists smrDtl;delimiter $$create procedure smrDtl(IN userId bigint(20),IN tradersId bigint(20))begincreate temporary table if not exists emp – 创建临时表(start_time datetime ,end_time datetime ,sub_ratio decimal(10,5) ,currency_coun
2021-03-09 16:18:33 304 1
原创 MYSQL统计收益排名
统计收益排名SELECT * FROM (// 计算排名select user_id,@curr_cnt:=cnt as cnt ,@rank:=IF(@prev_cnt!=@curr_cnt,@rank+1,@rank) as rankfrom (// 按条件查询表select user_id, SUM(profit) as cnt from t_user_follow_bb_ordergroup by user_id ORDER BY cnt desc) as der,(select
2021-03-09 16:14:01 227
原创 MYSQL 获取天,周,月 日期
– 今天SELECT DATE_FORMAT(NOW(),’%Y-%m-%d 00:00:00’) AS ‘今天开始’;SELECT DATE_FORMAT(NOW(),’%Y-%m-%d 23:59:59’) AS ‘今天结束’;– 昨天SELECT DATE_FORMAT( DATE_SUB(CURDATE(), INTERVAL 1 DAY), ‘%Y-%m-%d 00:00:00’) AS ‘昨天开始’;SELECT DATE_FORMAT( DATE_SUB(CURDATE(), INT
2021-03-09 16:11:33 571
原创 redis过期key通知
redis过期key通知修改rendis配置文件notify-keyspace-events修改为EXnotify-keyspace-events Exjava redis配置文件@Configurationpublic class RedisConfig {@Beanpublic RedisTemplate<String, Object> empRedisTemplate(RedisConnectionFactory redisConnectionFactory) { R
2021-03-09 16:05:49 67
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人