- 博客(21)
- 收藏
- 关注
原创 一对多标签字段
<resultMap id="ResultMap" type="com.spdb.quality.inspection.task.domain.vo.RulePropertiesUniteVO" autoMapping="true"> <id column="rule_no" jdbcType="VARCHAR" property="ruleNo" /> <collection property="subRuleProperties" ofType="com.spd
2023-03-08 16:14:27 121
原创 build模式
package com.spdb.quality.inspection.task.domain.entity; import cn.hutool.json.JSONUtil; import com.spdb.quality.inspection.task.constant.Constants; import org.springframework.core.io.support.PropertiesLoaderUtils; import java.io.IOException; import
2023-03-02 15:42:26 137
原创 插入sql前判断是否存在
insert into mon_check_plan ( plan_group, rule_no, rule_group_no, create_time ) select 'CHECK_PLAN', 'RPT103420230226000001', 'RPT1034', sysdate() from dual where not exists (select rule_no from mon_check_plan where plan_group='CHECK_PLAN' and rule_no=
2023-02-26 20:54:13 515
原创 curl命令
curl -X POST -H "Content-Type: application/json" --data {\"poolName\":\"testConf\",\"type\":\"oracle\",\"driverClassName\":\"oracle.jdbc.OracleDriver\",\"url\":\"jdbc:oracle:thin:@10.144.5.177:1521/UATBIEEDB_s\",\"username\":\"vlog\",\"password\":\"oracle\
2023-02-21 16:00:16 200
原创 正则检验yyyy-MM-dd格式
@Test public void test24(){ String date = "2023-02-28" ; //正则匹配的日期格式为:yyyy-MM-dd String rexp = "^(((\\d{2}(([02468][048])|([13579][26]))[\\-]((((0?[13578])|(1[02]))[\\-]((0?[1-9])|([1-2][0-9])|(3[01])))|(((0?[469])|(11))[\\-]((0?[1-9])|([1-2][0-9])|(30
2023-02-02 15:40:26 858
原创 根据id获取版本号最大的
SELECT * FROM ( SELECT * ,row_number () over (PARTITION BY `mdis_id` ORDER BY mdis_version DESC ) AS v_rank from mdis_info) as a where a.v_rank=1 AND DeletionStateCode=0 AND mdis_fb_status IN ('10','30','40');
2023-01-30 18:50:08 54
原创 sql函数应用
时分秒为多个字段,排序时可用其他字段代替,用函数截取自己想要的结果SELECT m.end_time,m.start_at_hour,m.start_at_minute,m.start_at_second,RIGHT(subdate(STR_TO_DATE(CONCAT('2023-01-01 ',m.end_time), '%Y-%m-%d %H:%i:%s') , INTERVAL 5 MINUTE),8) order_time FROM mon_rule_properties m ORDER BY
2023-01-28 13:30:58 52
原创 根据实体类某个字段排序
package com.crm.indp.entity; import java.util.Date; import com.crm.indp.dto.MdisInfoComputeDeriveDTO; import lombok.Data; import org.jetbrains.annotations.NotNull; @Data public class MdisInfoComputeWd implements Comparable<MdisInfoComputeWd> { /** *
2022-10-11 10:14:21 104 1
原创 kill进程.bat
@echo off setlocal enabledelayedexpansion set /p port=请输入端口号: for /f "tokens=1-5" %%a in ('netstat -ano ^| find ":%port%"') do ( if "%%e%" == "" ( set pid=%%d ) else ( set pid=%%e )
2022-09-16 09:39:15 937
原创 java工具类用法
SpringUtil.getBean(UserService.class)获取类; StringUtils.isNotEmpty("判断字符串是否为空"); StringUtils.substring(string,1,string.length()); Properties p =PropertiesLoaderUtils.loadAllProperties("config/db.properties"); p.getProperty("second"); List<NoticeMember>
2022-08-31 14:10:58 134
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人