<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Mr_Dracy的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Mr_Dracy</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Mr_Dracy]]></copyright><item><title><![CDATA[连接kafka报错：java.io.IOException: Can‘t resolve address：]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/136529277</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/136529277</guid><author>Mr_Dracy</author><pubDate>Thu, 07 Mar 2024 11:39:05 +0800</pubDate><description><![CDATA[java实现kafka实现生产者和消费者时报错 java.io.IOException: Can’t resolve address: xxxxxx]]></description><category></category></item><item><title><![CDATA[对象转成json，由于数据量过大压缩成.json.zip格式]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/135402026</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/135402026</guid><author>Mr_Dracy</author><pubDate>Fri, 05 Jan 2024 09:52:24 +0800</pubDate><description><![CDATA[对象转成json，由于数据量过大压缩成.json.zip格式]]></description><category></category></item><item><title><![CDATA[Oracle数据库中的CLOB字段类型，映射到Map＜String，Object＞中异常问题解决]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/132231494</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/132231494</guid><author>Mr_Dracy</author><pubDate>Fri, 11 Aug 2023 14:58:47 +0800</pubDate><description><![CDATA[Oracle数据库中的CLOB字段类型，映射到Map中异常问题解决]]></description><category></category></item><item><title><![CDATA[SpringBoot整合XXL-JOB]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/130124067</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/130124067</guid><author>Mr_Dracy</author><pubDate>Thu, 13 Apr 2023 10:53:56 +0800</pubDate><description><![CDATA[SpringBoot整合XXL-JOB]]></description><category></category></item><item><title><![CDATA[BigDecimal类型序列化]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/128001197</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/128001197</guid><author>Mr_Dracy</author><pubDate>Wed, 23 Nov 2022 15:25:05 +0800</pubDate><description><![CDATA[BigDecimal类型序列化]]></description><category></category></item><item><title><![CDATA[SQL语句查询每周起止日期(周日开始)]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/125319599</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/125319599</guid><author>Mr_Dracy</author><pubDate>Thu, 16 Jun 2022 17:11:27 +0800</pubDate><description><![CDATA[SQL语句]]></description><category></category></item><item><title><![CDATA[获取服务器上图片的大小KB]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122721859</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122721859</guid><author>Mr_Dracy</author><pubDate>Thu, 27 Jan 2022 18:11:34 +0800</pubDate><description><![CDATA[public class ImageUtils {

 	// 图片size
    public static int size;
    
    /**
     * 根据图片地址返回图片大小kb或者 Mb
     *
     * @param imgPath 图片地址
     * @return
     */
    public static void pathSize(String imgPath){
        int urlSize;
        URL url = new ]]></description><category></category></item><item><title><![CDATA[关于MySQL ＞ 5.7的 order by，group by]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122681764</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122681764</guid><author>Mr_Dracy</author><pubDate>Tue, 25 Jan 2022 11:28:54 +0800</pubDate><description><![CDATA[先上一个SQL：
SELECT
temp.facility_id ,
temp.unit_id,
temp.user_id,
temp.`day`,
temp.time_period,
temp.stool_id,
temp.stool_abbreviation,
temp.situation_id,
temp.situation_abbreviation,
temp.stool_incontinence,
temp.bloody_stool
FROM
(
SELECT
mumr.bloody_stool ]]></description><category></category></item><item><title><![CDATA[sort根据多属性排序]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122259555</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122259555</guid><author>Mr_Dracy</author><pubDate>Fri, 31 Dec 2021 16:54:20 +0800</pubDate><description><![CDATA[Collections.sort(reservations, (o1, o2) -&gt; {
            String dateOne = ((JSONObject) o1).getJSONObject("time_info").getString("start_time");
            String dateTwo = ((JSONObject) o2).getJSONObject("time_info").getString("start_time");
 ...]]></description><category></category></item><item><title><![CDATA[PageHelper分页插件一对多导致总条数以及每页显示条数不对应问题]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122253058</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/122253058</guid><author>Mr_Dracy</author><pubDate>Fri, 31 Dec 2021 11:41:28 +0800</pubDate><description><![CDATA[要查询的响应数据List&lt;类&gt;：可以看出是一对多的查询
@Data
@ApiModel("カルテ一览响应参数")
public class BeautyChartResVo {
    @ApiModelProperty("カルテ ID")
    private Long id;
    @ApiModelProperty("ルテ做成者(店员)")
    private String staff_name;
    @ApiModelProperty("顾客ID")
    private ]]></description><category></category></item><item><title><![CDATA[临时表SQL优化]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/120901075</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/120901075</guid><author>Mr_Dracy</author><pubDate>Fri, 22 Oct 2021 10:36:59 +0800</pubDate><description><![CDATA[原SQL：
SELECT
COUNT(DISTINCT a.customerid)
FROM
sl_sales_record a LEFT JOIN
(SELECT
customerid
FROM
sl_sales_record
WHERE
shopid = 55
AND regdate &lt;= "2020-10-14"
AND regdate &gt; "2020-06-14"
GROUP BY customerid) b
ON a.customerid = b.customerid
WHERE b.]]></description><category></category></item><item><title><![CDATA[获取某一时间的前XX天/前XX个月的时间]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/120718218</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/120718218</guid><author>Mr_Dracy</author><pubDate>Tue, 12 Oct 2021 10:19:37 +0800</pubDate><description><![CDATA[/**
 * @Author: jiangwx
 * @Date: 2021/10/8 11:19
 */
public class PastDateUtil {

    public static long TIME = 86400000;

    public static String getPastDate(int interval,String endDate){
        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd")]]></description><category></category></item><item><title><![CDATA[xml转json工具类]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/120513281</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/120513281</guid><author>Mr_Dracy</author><pubDate>Mon, 27 Sep 2021 17:24:53 +0800</pubDate><description><![CDATA[public class XmlToJsonUtil {
    /**
     * String 转 org.dom4j.Document
     * @param xml
     * @return
     * @throws DocumentException
     */
    public static Document strToDocument(String xml){
        try {
            //去掉xml报文头部标志
            Stri]]></description><category></category></item><item><title><![CDATA[Base64转图片并上传至服务器]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/119461515</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/119461515</guid><author>Mr_Dracy</author><pubDate>Fri, 06 Aug 2021 18:41:02 +0800</pubDate><description><![CDATA[首先：附上图片转Base64的网址 →   不用客气，利人利己
其次：创建一个工具类，便于以后CV。

最终：上代码
import java.io.*;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.UUID;
import java.util.regex.Matcher;
import java.util.regex.Pattern;

import cn.hutool.core.util.StrUti]]></description><category></category></item><item><title><![CDATA[计算年龄的工具类]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/119328204</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/119328204</guid><author>Mr_Dracy</author><pubDate>Mon, 02 Aug 2021 16:30:50 +0800</pubDate><description><![CDATA[public class AgeUtil {

    public static int getAgeByBirth(Date birthDay) throws ParseException {

    int age = 0;
        Calendar cal = Calendar.getInstance();
        //出生日期晚于当前时间，无法计算
        if (cal.before(birthDay)) {
            throw new IllegalA]]></description><category></category></item><item><title><![CDATA[MyBatis中传递数组和list时if-test判空和判断长度的写法]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/118194164</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/118194164</guid><author>Mr_Dracy</author><pubDate>Thu, 24 Jun 2021 18:42:20 +0800</pubDate><description><![CDATA[xml：
&lt;if test="state != null and state.size &gt; 0"&gt;
      AND t.state IN
      &lt;foreach item="state" index="index" collection="state" open="(" separator="," close=")"&gt;
        #{state}
      &lt;/foreach&gt;
&lt;/if&gt;

array数组：
&lt;if test="]]></description><category></category></item><item><title><![CDATA[token的加密解密与校验]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117951182</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117951182</guid><author>Mr_Dracy</author><pubDate>Wed, 16 Jun 2021 10:58:57 +0800</pubDate><description><![CDATA[import io.jsonwebtoken.Claims;
import io.jsonwebtoken.JwtBuilder;
import io.jsonwebtoken.Jwts;
import io.jsonwebtoken.SignatureAlgorithm;

import java.util.Date;
import java.util.HashMap;
import java.util.Map;
import java.util.UUID;

public class JwtUtil .]]></description><category></category></item><item><title><![CDATA[@JsonInclude]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117950385</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117950385</guid><author>Mr_Dracy</author><pubDate>Wed, 16 Jun 2021 10:48:57 +0800</pubDate><description><![CDATA[前后端分离的项目，框架中封装了返回给前端的结果。
但是在数据库中查询到的数据为null 的时候，响应的内容没有了，但是前端想要得到这个类型的结构（比如说是个实体，那么就返回他的各个属性；是个数据或集合就返回 [ ] ）。最终发现是@JsonInclude这个注解过滤掉了当返回值为null 的时候的属性。
@JsonInclude(JsonInclude.Include.Include.ALWAYS) 默认
@JsonInclude(JsonInclude.Include.NON_DEFAULT ) 属性为默]]></description><category></category></item><item><title><![CDATA[xml中，返回的映射带有List＜Long＞这种类型resultMap应该如何去写]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117700528</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117700528</guid><author>Mr_Dracy</author><pubDate>Tue, 08 Jun 2021 14:07:16 +0800</pubDate><description><![CDATA[返回的映射type：
@Data
public class TerminalSettingVo {
    private String facility_name;
    private Integer voice_id;
    private Boolean is_poop_sound_on;
    private Boolean is_flatulence_sound_on;
    private Boolean is_poop_vibration_on;
    private Boolea]]></description><category></category></item><item><title><![CDATA[得到起止日期中间的日期List＜String＞]]></title><link>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117665460</link><guid>https://blog.youkuaiyun.com/Mr_Dracy/article/details/117665460</guid><author>Mr_Dracy</author><pubDate>Mon, 07 Jun 2021 16:13:10 +0800</pubDate><description><![CDATA[比如说想得到 2021-05-21     2021-06-07 中间的日期是
2021-05-21  2021-05-22 …  2021-06-06   2021-06-07
 private List&lt;String&gt; getBetweenDates(String start, String end) {

        List&lt;String&gt; result = new ArrayList&lt;String&gt;();

        SimpleDateFormat ]]></description><category></category></item></channel></rss>