<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[开发随笔-猫咪酱]]></title><description><![CDATA[爱生活，爱编程]]></description><link>https://blog.youkuaiyun.com/ranran0224</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; ranran0224]]></copyright><item><title><![CDATA[【前端】yarn install error]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/148766972</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/148766972</guid><author>ranran0224</author><pubDate>Thu, 19 Jun 2025 15:02:40 +0800</pubDate><description><![CDATA[【摘要】在运行yarn install时遇到"https://registry.npm.taobao.org证书过期"错误，原因是淘宝npm镜像源证书失效。解决方法为：1)清除npm缓存(npm cache clean --force)；2)将镜像源切换为https://registry.npmmirror.com；3)验证配置后重新执行yarn install成功。虽然安装过程中出现多个依赖版本警告，但最终完成构建。该问题涉及npm镜像源证书更新，使用国内新镜像源可有效解决此类网络请求失败问题。
]]></description><category></category></item><item><title><![CDATA[代码调试，mybatis输出sql]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/145929452</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/145929452</guid><author>ranran0224</author><pubDate>Fri, 28 Feb 2025 15:07:41 +0800</pubDate><description><![CDATA[方便调试，下面这两个加到local配置文件即可。有的项目里没有这个，记录下。]]></description><category></category></item><item><title><![CDATA[【mybatis】一对多查询]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/145323037</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/145323037</guid><author>ranran0224</author><pubDate>Thu, 23 Jan 2025 14:46:58 +0800</pubDate><description><![CDATA[书接上文，当多表查询，为了一个查询出全部，使用了GROUP_CONCAT和json_object函数，但是当数据量过大时，需要更改mysql的数据库配置，调大group_concat_max_len配置参数。2.Mapper中使用collection标签，使用select查询，通过group_id关联，一次查询出关联表对应user和user信息。表：group、group_user_ref、user。类结构：类Group和类GroupUser。使用以下方法实现，一次查询，一对多。]]></description><category></category></item><item><title><![CDATA[【json_object】mysql中json_object函数过长，显示不全]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/145265539</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/145265539</guid><author>ranran0224</author><pubDate>Mon, 20 Jan 2025 17:10:36 +0800</pubDate><description><![CDATA[重启mysql修改后重启mysql。问题：json只显示部分。]]></description><category></category></item><item><title><![CDATA[【OOM】idea出现oom修改启动阐述无效]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/145001991</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/145001991</guid><author>ranran0224</author><pubDate>Wed, 08 Jan 2025 10:56:34 +0800</pubDate><description><![CDATA[修改setting-build-compiler中shared build process heap size为1024启动成功。问题：出现堆溢出，idea VM options中 -Xmx1024m 无效，不停调大参数也无法启动。]]></description><category></category></item><item><title><![CDATA[【sql】CAST(GROUP_CONCAT（））实现一对多对象json输出]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/144891654</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/144891654</guid><author>ranran0224</author><pubDate>Thu, 02 Jan 2025 18:16:18 +0800</pubDate><description><![CDATA[mysql中实现一对多个对象输出为一条数据，将多个字段转换成json对象，对个json对象以集合形式输出。涉及json_object函数、cast函数、GROUP_CONCAT函数、concat函数]]></description><category></category></item><item><title><![CDATA[【mybatis】mapper.xml文件DOCTYPE含义]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/144537224</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/144537224</guid><author>ranran0224</author><pubDate>Tue, 17 Dec 2024 15:44:34 +0800</pubDate><description><![CDATA[mapper.xml文件DOCTYPE的含义，mybatis-3-mapper.dtd文件是什么，作用。
]]></description><category></category></item><item><title><![CDATA[【前端】安装hadoop后，前端启动报错，yarn命令]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/144192417</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/144192417</guid><author>ranran0224</author><pubDate>Mon, 02 Dec 2024 16:53:43 +0800</pubDate><description><![CDATA[新安装hadoop后，前端启动项目用yarn命令，报错。检查：yarn -version，不报错，可以查看信息。解决：删掉hadoop目录下yarn的文件。报错：系统找不到指定的路径。]]></description><category></category></item><item><title><![CDATA[【mysql】Public Key Retrieval is not allowed]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/144054108</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/144054108</guid><author>ranran0224</author><pubDate>Tue, 26 Nov 2024 11:24:34 +0800</pubDate><description><![CDATA[解决方法：JDBC 连接串中加入 allowPublicKeyRetrieval=true。问题：项目通过jdbc连接MySQL后时候报错。]]></description><category></category></item><item><title><![CDATA[【前端】vscode中error image-size@1.1.1: The engine “node“ is incompatible with this module. Expected ver]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/144031908</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/144031908</guid><author>ranran0224</author><pubDate>Mon, 25 Nov 2024 16:58:23 +0800</pubDate><description><![CDATA[解决方法：执行yarn config set ignore-engines true。问题：vscode中执行yarn install时候报错。]]></description><category></category></item><item><title><![CDATA[【前端】vscode报错： 无法加载文件 D:\nodejs\node_global\yarn.ps1，因为在此系统上禁止运行脚本。]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/144031645</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/144031645</guid><author>ranran0224</author><pubDate>Mon, 25 Nov 2024 16:51:55 +0800</pubDate><description><![CDATA[问题： 无法加载文件 D:\nodejs\node_global\yarn.ps1，因为在此系统上禁止运行脚本。查看 get-ExecutionPolicy，Restricted代表禁止。修改 set-ExecutionPolicy RemoteSigned。vscode运行前端代码时候，执行yarn install时候报错。修改后查看状态，执行yarn install成功。首先用管理员身份运行vscode。]]></description><category></category></item><item><title><![CDATA[XSS过滤器Filter实现]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/143628783</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/143628783</guid><author>ranran0224</author><pubDate>Fri, 08 Nov 2024 16:35:07 +0800</pubDate><description><![CDATA[针对xxs攻击实现XssFilter实战，后端全代码解析。其中包括过滤器实现代码和配置类以及ApplicationContextUtils、multipartResolver配置]]></description><category></category></item><item><title><![CDATA[SpringBoot使用ApplicationContext.getBean启动报空指针处理记录]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/143596383</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/143596383</guid><author>ranran0224</author><pubDate>Thu, 07 Nov 2024 15:39:43 +0800</pubDate><description><![CDATA[ApplicationContextUtils是否在Configuration的Bean初始化之前初始化是未知的。用到的@DependsOn注解，先把SpringContextUtils注册到Spring容器里面。注解含义就是组件A要依赖于另一个组件B，也就是说被依赖的组件B会比组件A先注册到Spring容器中。定位：新增filter中init方法使用getbean控制。解决：在新增filter上加注解。问题：项目启动报空指针。]]></description><category></category></item><item><title><![CDATA[org.springframework.boot:type=Admin,name=SpringApplication异常]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/143427219</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/143427219</guid><author>ranran0224</author><pubDate>Fri, 01 Nov 2024 11:17:32 +0800</pubDate><description><![CDATA[launch optimization 和 Enable JMX agent 勾选项去掉。问题：更换最新版本idea之后，启动springboot项目报错。idea自动默认的启动设置需要更改。]]></description><category></category></item><item><title><![CDATA[idea git 设置Local Changes窗口]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/143414135</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/143414135</guid><author>ranran0224</author><pubDate>Thu, 31 Oct 2024 18:23:31 +0800</pubDate><description><![CDATA[idea本地查看代码更改的窗口，设置]]></description><category></category></item><item><title><![CDATA[【idea】idea更新遇到的坑]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/143404917</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/143404917</guid><author>ranran0224</author><pubDate>Thu, 31 Oct 2024 16:13:37 +0800</pubDate><description><![CDATA[点击一级菜单 HKEY_CURRENT_USER， 右键查找，输入idea，会找到jetbrains，然后，右键删除。点击一级菜单 HKEY_CURRENT_USER， 右键查找，输入jetbrain，会找到jetbrain相关，然后，右键删除。C:\Users\${用户名称}\AppData\Roaming\JetBrains。解决：提高jdk版本，2024版本最低jdk17，jdk8更新到jdk22 OK了。1.卸载程序，部分破解版没有卸载.exe，删除安装目录后在处理其他下面两步。]]></description><category></category></item><item><title><![CDATA[【mysql】转义字符反斜杠，正则表达式]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/143146297</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/143146297</guid><author>ranran0224</author><pubDate>Tue, 22 Oct 2024 15:56:53 +0800</pubDate><description><![CDATA[​         在MySQL中，反斜杠在字符串中是属于转义字符，insert语句和查询等于语句、查询like语句红的不同]]></description><category></category></item><item><title><![CDATA[【redis】本地windows五分钟快速安装redis]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/141935445</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/141935445</guid><author>ranran0224</author><pubDate>Thu, 05 Sep 2024 17:01:31 +0800</pubDate><description><![CDATA[选择版本：Redis-7.4.0-Windows-x64-msys2-with-Service，zip。4.修改redis.conf（redis窗口中设置密码是临时的，配置文件是永久的）在redis目录中复制一份conf命名为redis.windows.conf。3.cmd命令行，使用redis-cli ping 命令测试redis已安装。用处：本地自测，有时候公司redis环境不稳定，用自己的。1.下载，github下载一个解压缩在自己想要的位置。在redis文件中cmd执行命令让配置文件生效。]]></description><category></category></item><item><title><![CDATA[【mysql】mysql修改sql_mode之后无法启动]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/141932960</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/141932960</guid><author>ranran0224</author><pubDate>Thu, 05 Sep 2024 15:45:11 +0800</pubDate><description><![CDATA[原因：MySQL在8以后sql_mode已经取消了NO_AUTO_CREATE_USER这个关键字。去掉这个关键字后，启动就可以了。现象：修改后mysql无法启动，不报错。]]></description><category></category></item><item><title><![CDATA[【无标题】]]></title><link>https://blog.youkuaiyun.com/ranran0224/article/details/131570258</link><guid>https://blog.youkuaiyun.com/ranran0224/article/details/131570258</guid><author>ranran0224</author><pubDate>Thu, 06 Jul 2023 10:29:18 +0800</pubDate><description><![CDATA[public FileOutputStream(File file,boolean append):创建一个向指定 File 对象表示的文件中写入      数据的文件输出流。FileOutputStream(File file):创建一个向指定 File 对象表示的文件中写入数据的文件输出流。FileOutputStream(String name)：创建一个向具有指定名称的文件中写入数据的输出文件流。创建一个新的缓冲输出流，以将具有指定缓冲区大小的数据写入指定的底层输出流.]]></description><category></category></item></channel></rss>