<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cy5151的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cy5151</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cy5151]]></copyright><item><title><![CDATA[mysql列按照中文拼音排序]]></title><link>https://blog.youkuaiyun.com/cy5151/article/details/129437016</link><guid>https://blog.youkuaiyun.com/cy5151/article/details/129437016</guid><author>cy5151</author><pubDate>Fri, 10 Mar 2023 10:08:52 +0800</pubDate><description><![CDATA[mysql 字段中文排序]]></description><category></category></item><item><title><![CDATA[linux根据进程PID查找任务安装目录]]></title><link>https://blog.youkuaiyun.com/cy5151/article/details/129366450</link><guid>https://blog.youkuaiyun.com/cy5151/article/details/129366450</guid><author>cy5151</author><pubDate>Mon, 06 Mar 2023 17:11:12 +0800</pubDate><description><![CDATA[Linux ]]></description><category></category></item><item><title><![CDATA[mysql表中文字段提取拼音首字母最便捷实现，中文按拼音首字母排序]]></title><link>https://blog.youkuaiyun.com/cy5151/article/details/127861299</link><guid>https://blog.youkuaiyun.com/cy5151/article/details/127861299</guid><author>cy5151</author><pubDate>Tue, 15 Nov 2022 10:39:08 +0800</pubDate><description><![CDATA[mysql表中文字段按拼音首字母排序。mysql表中文字段提取拼音首字母。]]></description><category></category></item><item><title><![CDATA[解决NoClassDefFoundError 解决maven 依赖冲突]]></title><link>https://blog.youkuaiyun.com/cy5151/article/details/124996369</link><guid>https://blog.youkuaiyun.com/cy5151/article/details/124996369</guid><author>cy5151</author><pubDate>Fri, 27 May 2022 06:11:47 +0800</pubDate><description><![CDATA[项目爆出 NoClassDefFoundError  有很大部分情况是因为依赖版本冲突导致
有的时候我们在本地编译和运行项目不会报错，但发布到线上环境就会有问题
这个时候我们可以通过 打印当前ClassLoader 加载了哪些Jar文件来排查问题
代码如下：
URL[] urLs = Launcher.getBootstrapClassPath().getURLs();
        System.out.println("启动类加载器加载的jar：");
        for (URL urL : u]]></description><category></category></item><item><title><![CDATA[java 操作 word 循环输出内容 动态表格 word模板]]></title><link>https://blog.youkuaiyun.com/cy5151/article/details/124958864</link><guid>https://blog.youkuaiyun.com/cy5151/article/details/124958864</guid><author>cy5151</author><pubDate>Wed, 25 May 2022 08:47:48 +0800</pubDate><description><![CDATA[word动态模板
循环输出内容
引入依赖

            com.deepoove
            poi-tl
            1.12.0

如果也可以直接使用POI原生API直接操作更灵活

]]></description><category></category></item><item><title><![CDATA[mysql 查询今天、昨天、7天、本周，本月、上一月 SQL]]></title><link>https://blog.youkuaiyun.com/cy5151/article/details/124855769</link><guid>https://blog.youkuaiyun.com/cy5151/article/details/124855769</guid><author>cy5151</author><pubDate>Thu, 19 May 2022 08:51:37 +0800</pubDate><description><![CDATA[今天
select * from 表名 where to_days(时间字段名) = to_days(now());
昨天
SELECT * FROM 表名 WHERE TO_DAYS( NOW( ) ) - TO_DAYS( 时间字段名) &lt;= 1
7天
SELECT * FROM 表名 where DATE_SUB(CURDATE(), INTERVAL 7 DAY) &lt;= date(时间字段名)
近30天
SELECT * FROM 表名 where DATE_SUB(CURDATE(),]]></description><category></category></item></channel></rss>