<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[weixin_44916640的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/weixin_44916640</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; weixin_44916640]]></copyright><item><title><![CDATA[AES256 加密报错 Illegal key size 问题 升级jdk即可]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/131571629</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/131571629</guid><author>weixin_44916640</author><pubDate>Thu, 06 Jul 2023 11:07:26 +0800</pubDate><description><![CDATA[AES256 加密报错 Illegal key size 问题  jdk8 1.6以上版本应该就可以。]]></description><category></category></item><item><title><![CDATA[结束端口占用]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/129127754</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/129127754</guid><author>weixin_44916640</author><pubDate>Mon, 20 Feb 2023 16:59:29 +0800</pubDate><description><![CDATA[windows 结束端口占用]]></description><category></category></item><item><title><![CDATA[通过Mybatis 实现 一对多 多对一的关系，实现JSON 类型的数据结构]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/123849467</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/123849467</guid><author>weixin_44916640</author><pubDate>Wed, 30 Mar 2022 16:20:04 +0800</pubDate><description><![CDATA[自定义映射resultMap
通过Mybatis 实现 一对多 多对一的关系，实现JSON 类型的数据结构
关键字 resultMap  association 处理
resultMap处理字段和属性的映射关系
resultMap：设置自定义映射
    属性：
        id：表示自定义映射的唯一标识，不能重复
        type：查询的数据要映射的实体类的类型
    子标签：
        id：设置主键的映射关系
        result：设置普通字段的映射关系
        子]]></description><category></category></item><item><title><![CDATA[2020-10-29]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/109351286</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/109351286</guid><author>weixin_44916640</author><pubDate>Thu, 29 Oct 2020 09:24:17 +0800</pubDate><description><![CDATA[获取月最大最小 日期
/** 
* 
* moth 当前月 前后加减 月值
*/
public Map&lt;String,String&gt; getMonthBeginLastDay(Integer month){
        Calendar calendar = Calendar.getInstance();
        calendar.add(calendar.MONTH,month);
        calendar.set(Calendar.DAY_OF_MONTH, calend]]></description><category></category></item><item><title><![CDATA[2020-10-23]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/109239284</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/109239284</guid><author>weixin_44916640</author><pubDate>Fri, 23 Oct 2020 11:33:58 +0800</pubDate><description><![CDATA[查询日期转换思路
需求：根据前端传的string 类型日期 转成 需要的 ‘/’分隔的日期 String类型的日期
public Message dateFormat(String s) {
        String[] split = s.split("/");
        // =1 表示不是 "-" 分隔
        if (split.length == 1) {
            String[] sp = s.split("-");
            if (sp.len]]></description><category></category></item><item><title><![CDATA[2020-10-23]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/109239168</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/109239168</guid><author>weixin_44916640</author><pubDate>Fri, 23 Oct 2020 11:27:12 +0800</pubDate><description><![CDATA[SQLserver 去除重复数据 有id的
delete from table where ItemId not in ( select min(ItemId) from table  group by code,EnterpriseId ,......);


]]></description><category></category></item><item><title><![CDATA[mysql 判断 查询星期几]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/105077124</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/105077124</guid><author>weixin_44916640</author><pubDate>Tue, 24 Mar 2020 17:40:27 +0800</pubDate><description><![CDATA[mysql 判断 查询星期几
select date_format(curdate(),’%w’) from dual;
更多参考：
MySQL中DATE_FORMAT(date, format)函数可根据format字符串格式化日期或日期和时间值date，返回结果值。
字符串也可以查出是星期几
也可用DATE_FORMAT( ) 来格式化DATE 或DATETIME 值，以便得到所希望的格式。根...]]></description><category></category></item><item><title><![CDATA[mysql 多表多数据关联删除]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/103836820</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/103836820</guid><author>weixin_44916640</author><pubDate>Sat, 04 Jan 2020 19:38:44 +0800</pubDate><description><![CDATA[DELETE
w,
o
FROM
sys_user_waiting as w
LEFT JOIN sys_user_wait_opt as o ON w.ucid = o.OPTBillID
AND w.EnterpriseID ANd w.EnterpriseID = 182@TOC
delete 后面的是对应表的别名
欢迎使用Markdown编辑器
你好！ 这是你第一次使用 Markdown编...]]></description><category></category></item><item><title><![CDATA[Mysql排序方式中的升序与降序]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/102839398</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/102839398</guid><author>weixin_44916640</author><pubDate>Thu, 31 Oct 2019 15:48:19 +0800</pubDate><description><![CDATA[order by 根据排序的属性  desc   为从高到低
order by 根据排序的属性  asc    为从低到高

		ORDER BY
			distance ASC


]]></description><category></category></item><item><title><![CDATA[MYSQL查询今天、昨天、7天前、30天、本月数据]]></title><link>https://blog.youkuaiyun.com/weixin_44916640/article/details/101205775</link><guid>https://blog.youkuaiyun.com/weixin_44916640/article/details/101205775</guid><author>weixin_44916640</author><pubDate>Mon, 23 Sep 2019 14:53:49 +0800</pubDate><description><![CDATA[@[TOC]MYSQL查询今天、昨天、7天前、30天、本月数据
MYSQL查询今天、昨天、7天前、30天、本月数据
今天：
SELECT * FROM 表名 WHERE TO_DAYS( 时间字段名) = TO_DAYS(NOW());
昨天：
SELECT * FROM 表名 WHERE TO_DAYS( NOW( ) ) - TO_DAYS( 时间字段名) &lt;= 1;
7天前：
SELE...]]></description><category></category></item></channel></rss>