<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[leeeonnn的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/leeeonnn</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; leeeonnn]]></copyright><item><title><![CDATA[idea 生成方法、类注释的快捷键]]></title><link>https://blog.youkuaiyun.com/leeeonnn/article/details/113376385</link><guid>https://blog.youkuaiyun.com/leeeonnn/article/details/113376385</guid><author>leeeonnn</author><pubDate>Fri, 29 Jan 2021 12:12:05 +0800</pubDate><description><![CDATA[一、新建Template Group

如图1：点击右上角+号，选中Template Group，取名为MyComment

二、新建注释模板Live Template

如图1：选中MyComment，点击右上角+号，选中Live Template


三、配置注释模板与注释快捷键


Abbreviation 设置快捷键。如：cl（在方法或类上依次按cl+Tab即可）
Description 模板的描述
Template text 模板内容（自定义，参考如图2、3）
define 选中Java（在Te.]]></description><category></category></item><item><title><![CDATA[Mybatis-SQL语句替换、拼接、转换日期处理]]></title><link>https://blog.youkuaiyun.com/leeeonnn/article/details/112671481</link><guid>https://blog.youkuaiyun.com/leeeonnn/article/details/112671481</guid><author>leeeonnn</author><pubDate>Fri, 15 Jan 2021 15:47:24 +0800</pubDate><description><![CDATA[用了函数式后没有索引

start_time = replace(start_time,left(start_time,4),#{liveYear}),


CONCT：字符串拼接（有年月日形式的字符串不用转换也能和Date类型比较）

select * from tb_holiday tb
        where
         CONCAT(#{date},'-01') between tb.start_time and tb.end_time


DATE_FORMAT：字符串/日期转换成 '.]]></description><category></category></item><item><title><![CDATA[Java环境变量配置-win10]]></title><link>https://blog.youkuaiyun.com/leeeonnn/article/details/112508033</link><guid>https://blog.youkuaiyun.com/leeeonnn/article/details/112508033</guid><author>leeeonnn</author><pubDate>Tue, 12 Jan 2021 11:07:50 +0800</pubDate><description><![CDATA[一、JDK

新建JAVA_HOME
浏览目录选中下载好的jdk目录



Path新建，复制以下内容
%JAVA_HOME%\bin;%JAVA_HOME%\jre\bin;
分行时注意别带分号



新建CLASSPATH，复制以下内容
.;%JAVA_HOME%\bin;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar



检验是否配置成功
按快捷键 win+r 输入 cmd 再输入 java -version



...]]></description><category></category></item><item><title><![CDATA[idea更换git地址]]></title><link>https://blog.youkuaiyun.com/leeeonnn/article/details/112344766</link><guid>https://blog.youkuaiyun.com/leeeonnn/article/details/112344766</guid><author>leeeonnn</author><pubDate>Fri, 08 Jan 2021 09:18:32 +0800</pubDate><description><![CDATA[找到当前项目所在文件夹位置


修改.git中的git地址



]]></description><category></category></item><item><title><![CDATA[Mybatis中example类实现用and连接不同的Criteria、同个Criteria对象内可用or连接]]></title><link>https://blog.youkuaiyun.com/leeeonnn/article/details/111747154</link><guid>https://blog.youkuaiyun.com/leeeonnn/article/details/111747154</guid><author>leeeonnn</author><pubDate>Sat, 26 Dec 2020 15:39:28 +0800</pubDate><description><![CDATA[效果
SELECT count(0)
 FROM tb_holiday
 WHERE (holiday_type = '0') AND (end_time BETWEEN '2020-01-01 00:00:00.0' AND '2021-01-01 00:00:00.0' OR is_loop = '0');

Service类

service层list方法内

//criteria对象要放在list，才能和xml文件的oredCriteria对应
List&lt;TbHolidayExample1.C]]></description><category></category></item><item><title><![CDATA[SQL语句实现查询一段时间内所有日期并与数据库比较后匹配的数据集]]></title><link>https://blog.youkuaiyun.com/leeeonnn/article/details/111745753</link><guid>https://blog.youkuaiyun.com/leeeonnn/article/details/111745753</guid><author>leeeonnn</author><pubDate>Sat, 26 Dec 2020 15:06:23 +0800</pubDate><description><![CDATA[select hd.*
from
(
    select selected_date  from
        (select adddate('2020-12-05', t3.i*1000 + t2.i*100 + t1.i*10 + t0.i) selected_date from
        (select 0 i union select 1 union select 2 union select 3 union select 4 union select 5 union select 6 ]]></description><category></category></item></channel></rss>