Mrf_w的博客

nohup java --add-opens java.base/java.lang.reflect=ALL-UNNAMED --add-opens java.base/java.lang=ALL-UNNAMED -jar -Xms1000m -Xmx1000m -Xmn500m -XX:SurvivorRatio=8 manager-1.2023.jar --spring.profiles.active=pre --server.port=8100 --fastjson.parser.safeMode=t

public class ThreadLocalDateUtil { private static final String date_format = "yyyy-MM-dd HH:mm:ss"; private static ThreadLocal<DateFormat> threadLocal = new ThreadLocal<DateFormat>(); public static DateFormat getDateFormat() .

1.secure_file_priv=D:\ComputerProject\project\mysql-8.0.25-winx642.select * from bc_leibie into outfile 'D:\AAAAAAAAA\fans.txt'; 3.show variables like '%secure%';select @@basedir from dual;4.select * from bc_leibie into outfile 'D:/ComputerProject/.

SELECTa.table_name 表名,a.table_comment 表说明,b.COLUMN_NAME 字段名,b.column_comment 字段说明,b.column_type 字段类型FROMinformation_schema. TABLES aLEFT JOIN information_schema. COLUMNS b ON a.table_name = b.TABLE_NAMEWHEREa.table_schema = '2020dbsa'ORDER BYa

SELECT * FROM USERSHOW GRANTS FOR foo;SELECT * FROM USER WHERE USER='foo';SHOW VARIABLES LIKE '%log_bin%'; SHOW MASTER STATUS;SELECT * FROM USER WHERE USER='foo'SHOW MASTER STATUS;SHOW GRANTS FOR foo;

---修改字段类型为varbinarySELECT ks_xm, zjno from bk_ks where id=73623;UPDATE bk_ks set zjno='371581200307050851' where id=73623;UPDATE bk_ks set zjno=EncryptByPassPhrase('test',zjno) where id=73623;SELECT ks_xm, CONVERT(varchar,DECRYPTBYPASSPHRASE('test',

包括 API 文档工具、API 开发调试工具、API 自动化测试工具、API 监控工具SwaggerSwagger UIMarkdown/ReadMeApifoxYApiConfluenceWord文档/通用在线文档PostmanEolinkerApiPostApigeeRedoc.lyStoplightInsomniaRAPMeterSphere02API 调试工具*多选PostmanSwagger UIApifoxYApi

select 'update t_dw_jbxx set pcsdm=''' +temp.ybdz+ ''' where dwdm= ''' +rtrim(temp.bkh) + ''';'as updatesql from ( select sfz, bkyxdm,ybdz,bkh from bssxx where xm like '张%') temp

1、 检查系统环境Cpu：[root@db_master ~]# grep "modelname" /proc/cpuinfomodel name :Intel(R) Core(TM) i3 CPU M 350 @ 2.27GHzmodel name :Intel(R) Core(TM) i3 CPU M 350 @ 2.2...

1.ClassPathResource resource = new ClassPathResource(ExcelListener.path+"/" + filName);//File file = resource.getFile();2.DefaultResourceLoader defaultResourceLoader=new DefaultResourceLoader();...

关闭页面特效（一）将旧表复制到新表1、CREATE TABLE新表 SELECT* FROM旧表;该语句只是复制表结构以及数据，它不会复制与表关联的其他数据库对象，如索引，主键约束，外键约束，触发器等。CREATE TABLE if not exists new_tableSELECT col1, col2, col3FROMexisting_tableWHEREco...

SET GLOBAL group_concat_max_len=102400; 设置长度 客户端设置完后需要重启show variables like "group_concat_max_len" 查看长度

SELECT strategy.strategy_id, strategy.strategy_name, strategy.used_num, strategy.material_id, strate...

Velocity是一个基于java的模板引擎（template engine），它允许任何人仅仅简单的使用模板语言（template language）来引用由java代码定义的对象。作为一个比较完善的模板引擎，Velocity的功能是比较强大的，但强大的同时也增加了应用复杂性。一、基本语法1、"#"用来标识Velocity的脚本语句，包括#set、#if 、#else、#end、#f...

减少该死的 if else 嵌套写在前面不知大家有没遇到过像“横放着的金字塔”一样的if else嵌套：if(true){if(true){if(true){if(true){if(true){if(true){...

select 'update t_dw_jbxx set pcsdm= ''' || temp.pcsdm ||''' where dwdm= ''' || temp.dwdm || ''';' as updatesql from (select pcsdm, dwdm from t_dw_jbxx where pcsdm like '99%') temp