<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[sinat_38531349的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/sinat_38531349</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; sinat_38531349]]></copyright><item><title><![CDATA[浏览器控制台进行接口调试-fetch，使用浏览器直接做接口调测、参数修改]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/148775225</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/148775225</guid><author>sinat_38531349</author><pubDate>Thu, 19 Jun 2025 21:06:24 +0800</pubDate><description><![CDATA[使用浏览器控制台进行接口调试的快捷方法：1）在【网络】选项卡复制目标请求的fetch代码；2）在【控制台】粘贴并修改参数后执行；3）在【网络】中查看最新请求的响应结果。若响应空白，需在fetch末尾添加.then(response =&gt; response.json()).then(data =&gt; console.log(data))进行JSON转换，低版本浏览器尤其需要注意这一步。该方法无需其他工具即可快速完成接口测试和参数调试。]]></description><category></category></item><item><title><![CDATA[JVM 故障排查工具脚本]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/148592083</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/148592083</guid><author>sinat_38531349</author><pubDate>Wed, 11 Jun 2025 18:56:08 +0800</pubDate><description><![CDATA[使用获取当前存活对象的类名、实例数量及大小。该脚本是一个完整的 JVM 故障排查工具，适用于生产环境出现性能问题或内存异常时快速收集现场信息。]]></description><category></category></item><item><title><![CDATA[java服务异常时的jvm问题排查， JVM 故障排查工具，根据服务名称一键输出jstack、jmap等关键信息，并配置定时任务监控]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/148591728</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/148591728</guid><author>sinat_38531349</author><pubDate>Wed, 11 Jun 2025 18:51:33 +0800</pubDate><description><![CDATA[使用获取当前存活对象的类名、实例数量及大小。该脚本是一个完整的 JVM 故障排查工具，适用于生产环境出现性能问题或内存异常时快速收集现场信息。]]></description><category></category></item><item><title><![CDATA[java获取jvm运行信息]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/144383069</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/144383069</guid><author>sinat_38531349</author><pubDate>Tue, 10 Dec 2024 20:36:34 +0800</pubDate><description><![CDATA[获取当前 Java 应用程序的调试信息，包括内存使用情况、处理器数量、JVM 运行时间、线程信息、堆内存和非堆内存使用情况以及垃圾回收信息]]></description><category></category></item><item><title><![CDATA[根据数据构造sql临时表、根据条件数据构建exists语法内容, 解决PreparedStatement can have at most 65,535 parameters]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/144382577</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/144382577</guid><author>sinat_38531349</author><pubDate>Tue, 10 Dec 2024 20:33:59 +0800</pubDate><description><![CDATA[PreparedStatement can have at most 65,535 parameters
pg/cmdb 语法
mysql/pg/cmdb 语法
Oracle 语法 ]]></description><category></category></item><item><title><![CDATA[Drools规则编译失败，变量无法解析:Rule Compilation error xxx cannot be resolved to a variable]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/142959230</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/142959230</guid><author>sinat_38531349</author><pubDate>Tue, 15 Oct 2024 17:27:21 +0800</pubDate><description><![CDATA[解决 Drools 的规则变量无法解析的问题，Rule Compilation error codeList cannot be resolved to a variable ]]></description><category></category></item><item><title><![CDATA[MYSQL存储过程：判断索引不存在时添加,入参和日志返回]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/128132124</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/128132124</guid><author>sinat_38531349</author><pubDate>Thu, 01 Dec 2022 14:59:04 +0800</pubDate><description><![CDATA[存储过程：判断索引不存在时添加，支持入参和日志返回。]]></description><category></category></item><item><title><![CDATA[SQL 交叉表]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/127308551</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/127308551</guid><author>sinat_38531349</author><pubDate>Thu, 13 Oct 2022 20:19:58 +0800</pubDate><description><![CDATA[SQL交叉表]]></description><category></category></item><item><title><![CDATA[SQL行列转置，汇总再揭]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/127308259</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/127308259</guid><author>sinat_38531349</author><pubDate>Thu, 13 Oct 2022 20:08:58 +0800</pubDate><description><![CDATA[SQL行列转置，汇总再揭
1.使用case when进行性别翻译 ，并将性别字段的 case when 表达式放在group by中，根据性别将数据分两行。2. 根据表头条件设置列，case when第一层 放性别（匹配性别分的两行），第二层 统计匹配条件的人口。初始数据，有区域、性别（1为男，2为女）、和人口；将数据根据、区、市、省对不同性别的人口进行分别汇总。行列转置，汇总再揭后的报表结果。]]></description><category></category></item><item><title><![CDATA[ORA-00923: 未找到要求的 FROM 关键字]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/127308011</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/127308011</guid><author>sinat_38531349</author><pubDate>Thu, 13 Oct 2022 19:50:20 +0800</pubDate><description><![CDATA[在写case when取别名时，把sql语句从mysql复制到Oracle，爆了这个错误；]]></description><category></category></item><item><title><![CDATA[SQL删除重复行、记录（MYSQL、ORACLE）]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/127307662</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/127307662</guid><author>sinat_38531349</author><pubDate>Thu, 13 Oct 2022 19:39:46 +0800</pubDate><description><![CDATA[示例中表有两个字段，两个字段的值都相同的视为重复记录;处理：先having count(1) > 1找到重复数据，将重复数据中每条独立记录备份一份，删除重复数据，再将备份的数据恢复。]]></description><category></category></item><item><title><![CDATA[Java计算标会（会子）利率]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/126598415</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/126598415</guid><author>sinat_38531349</author><pubDate>Tue, 30 Aug 2022 10:22:25 +0800</pubDate><description><![CDATA[计算标会、会子利率；如下的计算方式，为最后一期总收利息、本金的情况。]]></description><category></category></item><item><title><![CDATA[JS树的查找 根据树中某一节点的任一属性值，找到对应节点]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/126060841</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/126060841</guid><author>sinat_38531349</author><pubDate>Fri, 29 Jul 2022 17:42:11 +0800</pubDate><description><![CDATA[JS根据树中某一节点的任一属性值，找到对应节点，仅找第一个匹配的节点]]></description><category></category></item><item><title><![CDATA[Jmockit：Missing 1 invocation to]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/125223686</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/125223686</guid><author>sinat_38531349</author><pubDate>Fri, 10 Jun 2022 16:21:03 +0800</pubDate><description><![CDATA[默认情况下 Expectations 录制的函数，必须被执行一次，否则会报错 Missing 1 invocation to: 之类的错误。]]></description><category></category></item><item><title><![CDATA[Feign的BUG，调用时，请求头的传入实际参数为null，却接受到参数名为参数]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/123428987</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/123428987</guid><author>sinat_38531349</author><pubDate>Fri, 11 Mar 2022 16:52:12 +0800</pubDate><description><![CDATA[当使用Feign调用接口时，
@RequestHeader(value = “参数名”, required = false)
参数位于 请求头，为非必填项，请求时将null传入，但被调用到的接口，实际接受的参数值却为参数名；
解决方案：
1.不传null，传入空字符串 “”；
2.将该参数移至body就不会有该问题。

...]]></description><category></category></item><item><title><![CDATA[MongoDB入门学习以及Spring操作MongoDB]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/123428091</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/123428091</guid><author>sinat_38531349</author><pubDate>Fri, 11 Mar 2022 16:45:56 +0800</pubDate><description><![CDATA[MongoDB入门学习以及Spring操作MongoDB
spring-data-mongodb]]></description><category></category></item><item><title><![CDATA[Drools规则引擎入门使用_在springboot项目中]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/122823088</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/122823088</guid><author>sinat_38531349</author><pubDate>Tue, 08 Feb 2022 16:15:42 +0800</pubDate><description><![CDATA[Drools规则引擎入门使用_在springboot项目中]]></description><category></category></item><item><title><![CDATA[MySQL/GreatDB 获取表元数据信息、采集表信息、获取表列表、列信息、索引 信息、主键信息、分区信息]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/122467819</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/122467819</guid><author>sinat_38531349</author><pubDate>Thu, 13 Jan 2022 10:05:51 +0800</pubDate><description><![CDATA[MySQL/GreatDB 获取表元数据信息、采集表信息、获取表列表、列信息、索引 信息、主键信息、分区信息]]></description><category></category></item><item><title><![CDATA[MySQL/GreatDB 创建分区表、联合主键、联合索引、唯一索引、普通索引]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/122467708</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/122467708</guid><author>sinat_38531349</author><pubDate>Thu, 13 Jan 2022 10:01:45 +0800</pubDate><description><![CDATA[MySQL/GreatDB 创建分区表、联合主键、联合索引、唯一索引、普通索引]]></description><category></category></item><item><title><![CDATA[JS 对象和数组的互相转换]]></title><link>https://blog.youkuaiyun.com/sinat_38531349/article/details/121807130</link><guid>https://blog.youkuaiyun.com/sinat_38531349/article/details/121807130</guid><author>sinat_38531349</author><pubDate>Thu, 09 Dec 2021 10:08:46 +0800</pubDate><description><![CDATA[JS 对象和数组的互相转换
js对象转为数组 ，js数组转为对象
js对象转为对象数组，js对象数组转为对象]]></description><category></category></item></channel></rss>