<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[spjhandsomeman的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/spjhandsomeman</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; spjhandsomeman]]></copyright><item><title><![CDATA[各个历史版本mysql/tomcat/Redis/Jdk/Apache/gitlab下载地址]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/147986239</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/147986239</guid><author>spjhandsomeman</author><pubDate>Thu, 15 May 2025 16:28:38 +0800</pubDate><description><![CDATA[mysql 各版本下载地址：tomcat 各版本下载地址：Apache产品下载地址：Redis下载地址Jdk下载地址：gitlab 下载地址]]></description><category></category></item><item><title><![CDATA[Windows 强制删除文件夹/文件（删除提示“你需要来自 Administrators 的权限才能对此文件夹进行更改”）]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/147477841</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/147477841</guid><author>spjhandsomeman</author><pubDate>Thu, 24 Apr 2025 14:49:17 +0800</pubDate><description><![CDATA[Windows 删除文件夹/文件提示“你需要来自 Administrators 的权限才能对此文件夹进行更改通过命令删除。]]></description><category></category></item><item><title><![CDATA[EXCEL 或 WPS 列下划线转驼峰]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/143731629</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/143731629</guid><author>spjhandsomeman</author><pubDate>Wed, 13 Nov 2024 10:15:26 +0800</pubDate><description><![CDATA[需要将下划线转驼峰，直接在excel或wps中第一行使用公式，然后快速刷整个列格式即可。]]></description><category></category></item><item><title><![CDATA[java Guava 分割 List]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/131066129</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/131066129</guid><author>spjhandsomeman</author><pubDate>Tue, 06 Jun 2023 13:53:19 +0800</pubDate><description><![CDATA[java Guava 分割 List。]]></description><category></category></item><item><title><![CDATA[vscode 离线插件地址]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/127028225</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/127028225</guid><author>spjhandsomeman</author><pubDate>Sat, 24 Sep 2022 17:33:47 +0800</pubDate><description><![CDATA[vscode 离线插件]]></description><category></category></item><item><title><![CDATA[vscode 离线汉化]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/127028075</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/127028075</guid><author>spjhandsomeman</author><pubDate>Sat, 24 Sep 2022 17:27:22 +0800</pubDate><description><![CDATA[vscode 汉化插件下载、安装、vscode下载，]]></description><category></category></item><item><title><![CDATA[java ThreadPoolExecutor 单例线程池]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/127026562</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/127026562</guid><author>spjhandsomeman</author><pubDate>Sat, 24 Sep 2022 16:00:01 +0800</pubDate><description><![CDATA[java ThreadPoolExecutor  单例线程池。]]></description><category></category></item><item><title><![CDATA[idea Debug 模式下tomcat无法启用]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/125420329</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/125420329</guid><author>spjhandsomeman</author><pubDate>Thu, 23 Jun 2022 09:06:25 +0800</pubDate><description><![CDATA[问题：

idea 中tomcat一直好好的，可以正常启动，突然出现启动时，卡死在某一个节点或者无法启动，也不报错。

解决方式：

去除debug模式下所有的短点，可以正常启动了。

注意问题：

出现这种因断点而无法debug模式下启动的情况是，run模式下是可以正常启动的。所以debug模式下，一定要注意断点可能导致无法正常启动哦🙄


...]]></description><category></category></item><item><title><![CDATA[idea 2020 - tomcat 9 中文乱码问题]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/125379329</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/125379329</guid><author>spjhandsomeman</author><pubDate>Mon, 20 Jun 2022 19:36:13 +0800</pubDate><description><![CDATA[使用环境：Idea 2020.2Tomcat 9遇到的问题：Idea中启动 tomcat 服务时，Server output、Tomcat Localhost.log、Tomcat Cataliana.log 启动后中文乱码问题。解决步骤：1、配置 File Encoding 编码2、配置console 编码3、配置 Help 中 Custom Properties 和 Custom VM Option ，均增加 -Dfile.encoding = UTF-84、配置tomat Edit Configura]]></description><category></category></item><item><title><![CDATA[解决IDEA编译（java找不到符号）问题]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/125112733</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/125112733</guid><author>spjhandsomeman</author><pubDate>Fri, 03 Jun 2022 15:18:22 +0800</pubDate><description><![CDATA[idea 升级后，源代码导入之后，编译报错java 无符号]]></description><category></category></item><item><title><![CDATA[mapstruct 1.2.0.Final 使用问题及配置]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/122359844</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/122359844</guid><author>spjhandsomeman</author><pubDate>Fri, 07 Jan 2022 10:59:56 +0800</pubDate><description><![CDATA[1、mapstruct 1.2.0.Final 转换后属性为null问题：mapstruct 、lombok版本不匹配：

&lt;org.mapstruct.version&gt;1.2.0.Final&lt;/org.mapstruct.version&gt;&lt;lombok.version&gt;1.18.10&lt;/lombok.version&gt;

2、属性方法 setXX 找不到符号问题的解决方法：


&lt;plugin&gt;
   &lt;artifactId&gt;mave.]]></description><category></category></item><item><title><![CDATA[idea 设置类、方法、类属性注释]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/119764493</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/119764493</guid><author>spjhandsomeman</author><pubDate>Tue, 17 Aug 2021 20:08:18 +0800</pubDate><description><![CDATA[第一部分：类注释、接口注释

注释生成格式：


/**
 * @Title:  ${NAME}
 * @Description: TODO
 * @author shipj
 * @date ${DATE} ${TIME} 
 * @version 1.0
 */

idea配置注释自动生成配置：





生成样例：



第二部分：方法生成注释、类属性生成注释

首先创建自定义组，在该组下面创建模版：本文中，MyDefine:自定义组，通过Template Group创建；MyDefine子项目...]]></description><category></category></item><item><title><![CDATA[mongodb下查询某个字段不为空的文档]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/119324640</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/119324640</guid><author>spjhandsomeman</author><pubDate>Mon, 02 Aug 2021 14:37:44 +0800</pubDate><description><![CDATA[//不为空包括不为null、部位空字符串
$nin 类似于关系型数据库中的INdb.getCollection('goods_index').find({"activityPriceJson":{$nin:[null,""]}})



其他：

1. $ne
$ne：表示not equals 就是不等于的意思
# 查询某字段不为null的数据
db.getCollection('goods_index').find({activityPriceJson: {$ne:null}})
# 查询字段等于null]]></description><category></category></item><item><title><![CDATA[java 多线程分页读取放入队列，多线程写入EasyExcel]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/119243744</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/119243744</guid><author>spjhandsomeman</author><pubDate>Fri, 30 Jul 2021 11:55:01 +0800</pubDate><description><![CDATA[@Test
    public void test() throws InterruptedException, ExecutionException {
        String resStr = "{\"languageCode\":\"en-US\",\"categoryType\":\"\",\"categoryLevel\":\"\"}";
        GoodsPriceSellListDTO condition = JSON.parseObject(resStr, GoodsPr..]]></description><category></category></item><item><title><![CDATA[EasyExcel 自定义Excel模版数据填充]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/118108846</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/118108846</guid><author>spjhandsomeman</author><pubDate>Tue, 22 Jun 2021 16:31:47 +0800</pubDate><description><![CDATA[1、自定义模版如下：

销量校验异常数据
		序号
			spu编码
			sku编码
			商品名称
			销量
			巡检时间
		mysql
			redis
			mongodb
		{.rowIndex}
			{.productCode}
			{.skuCode}
			{.productName}
			{.salesVolume}
			{.redisVolume}
			{.mongoVolume}
			{.inspectionTime}
		
			
			
			
			...]]></description><category></category></item><item><title><![CDATA[EasyExcel读取Excel并返回Excel行内容、生成并写入Excel内容、字符串提取图片url地址、java 8 分组、过滤、去重]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/116003519</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/116003519</guid><author>spjhandsomeman</author><pubDate>Thu, 22 Apr 2021 10:44:25 +0800</pubDate><description><![CDATA[EasyExcel涉及使用内容

1、EasyExcel读取Excel并返回Excel行内容；

2、EasyExcel生成并写入Excel内容；

实体对象类：



ProductDetailTestDTO.java


package com.spj.test.manager.service.productimg;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

import java.io.Seria.]]></description><category></category></item><item><title><![CDATA[mysql 索引最左原则测试执行情况]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/116002727</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/116002727</guid><author>spjhandsomeman</author><pubDate>Thu, 22 Apr 2021 10:24:04 +0800</pubDate><description><![CDATA[表结构语句：

CREATE TABLE `t_test_price` (
 `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键，自增',
 `activity_id` varchar(20) NOT NULL COMMENT '活动ID',
 `product_code` varchar(32) NOT NULL COMMENT 'product_code',
 `sku_code` varchar(32) NOT NULL COMMENT 's...]]></description><category></category></item><item><title><![CDATA[java List分为N个List获取每个子List集合，并把子List集合放入线程池处理]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/115750684</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/115750684</guid><author>spjhandsomeman</author><pubDate>Fri, 16 Apr 2021 10:53:46 +0800</pubDate><description><![CDATA[/**
  * @return void
  * @Author shipj
  * @Description审核通过的图片集合分批次（批次为3）处理
  * @Date 16:37 2021-04-10
  * @Param []
  **/
  @Override
  public void updateProductPictureDealByGroup(){
    //查询审核通过的商品 product_code
    List&...]]></description><category></category></item><item><title><![CDATA[java 网络图片压缩、富文本图片提取、获取图片MB大小、图片File按比例压缩并重命名、图片File转MultipartFile对象并上传到接口工具类]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/115749806</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/115749806</guid><author>spjhandsomeman</author><pubDate>Fri, 16 Apr 2021 10:15:51 +0800</pubDate><description><![CDATA[工具类主要功能：
网络图片加载到本地Fille（getFileByNetUrlHttp）
获取文件File大小，并转换为MB单位（formatFileSize）
图片按照比例压缩成新文件File，重命名（renameAndReduceFile）
图片File转换为MultipartFile对象（getMultipartFile）
提交MultipartFile对象到图片上传接口（sendMultipartFilePost）
富文本中提取图片（img标签src属性）（getImgStr）]]></description><category></category></item><item><title><![CDATA[mysql 创建表 设置创建时间、更新时间数据库自动更新]]></title><link>https://blog.youkuaiyun.com/spjhandsomeman/article/details/115749325</link><guid>https://blog.youkuaiyun.com/spjhandsomeman/article/details/115749325</guid><author>spjhandsomeman</author><pubDate>Fri, 16 Apr 2021 09:57:54 +0800</pubDate><description><![CDATA[mysql创建表设置创建时间、更新时间数据库自动更新脚本：

 `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
 `modify_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',


实例：

CREATE TABLE `t_activity_price` (
 `id` bigint(20) NOT NULL ...]]></description><category></category></item></channel></rss>