Fire_Fly_Lei的博客

原创 java excel导入表注释和字段注释

转载 MySQL根据id查询当前节点的层级

SELECT COUNT(*) FROM ( SELECT tab2.id, tab2.NAME, tab2.p_id FROM ( SELECT @r AS _id, ( SELECT @r := p_id FROM dc_location WHERE id = _id ) AS pid, @l := @l + 1 AS lvl FROM ( SELECT @r := #{id}, @l := 0 ) vars, dc_location

原创 MySQL查询当前时间到两个小时之前的时间列表（每十分钟）

SELECT tab.dt FROM ( SELECT DATE_FORMAT( date_add( concat( DATE_SUB( NOW(), INTERVAL 2 DAY_HOUR ) ), INTERVAL ( help_topic_id ) MINUTE ), '%Y-%m-%d %H:%i' ) dt FROM mysql.help_topic WHERE help_topic_id <= timestampdiff( MINUTE

转载 MySQL查询当月第一天到当天的日期列表

SELECT ADDDATE( tab2.firstDay, tab1.firstDay - 1 ) AS date FROM ( SELECT 1 AS firstDay UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL

原创 java实现0001 0002 0003 自增

public static String addNum(String str) { String numStr = str.substring(str.length() - 4); //取出最后四位数字 if (!StringUtils.isEmpty(numStr)) { //如果最后四位不是数字，抛NumberFormatException异常 int n = numStr.length(); //取出字符串的长度 int.

原创 sql查询取第一条数据

数据全查询SELECT * FROM edu_course ec ORDER BY priceMySQLSELECT * FROM edu_course ec ORDER BY price DESC LIMIT 1sqlserverSELECT TOP 1* FROM edu_course ec ORDER BY price DESCOracleSELECT * FROM(SELECT * FROM EDU_COURSE ORDER BY price DESC) WHERE ROWN

原创 sql截取时分：15小时26分钟

sql截取时分：15小时26分钟sqlserverSELECT SUBSTRING('15小时26分钟', 0, charindex( '小时', '15小时26分钟', 1 ) ) AS '时', SUBSTRING('15小时26分钟', CHARINDEX( '时', '15小时26分钟' ) + 1, CHARINDEX( '分', '15小时26分钟' ) - CHARINDEX( '时', '15小时26分钟' ) - 1 ) AS '分'MySQLSELECT SUBSTRI