<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[wz2008的专栏]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/wz2008</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; wz2008]]></copyright><item><title><![CDATA[idea好用插件]]></title><link>https://blog.csdn.net/wz2008/article/details/159833879</link><guid>https://blog.csdn.net/wz2008/article/details/159833879</guid><author>wz2008</author><pubDate>Sat, 04 Apr 2026 20:26:02 +0800</pubDate><description><![CDATA[mapper.java和mapper.xml之间，快速跳转。]]></description><category></category></item><item><title><![CDATA[cursor学习笔记]]></title><link>https://blog.csdn.net/wz2008/article/details/155640882</link><guid>https://blog.csdn.net/wz2008/article/details/155640882</guid><author>wz2008</author><pubDate>Sat, 06 Dec 2025 13:16:23 +0800</pubDate><description><![CDATA[一款AI开发工具IDE——cursor]]></description><category></category></item><item><title><![CDATA[属性注解：序列化 、bean拷贝、导出excel格式转化]]></title><link>https://blog.csdn.net/wz2008/article/details/130012700</link><guid>https://blog.csdn.net/wz2008/article/details/130012700</guid><author>wz2008</author><pubDate>Fri, 07 Apr 2023 15:25:48 +0800</pubDate><description><![CDATA[ExcelProperty(value ="确认时间", index = 33, converter = DateTimeConverter.class)// 导出excel列名称。@JsonDeserialize(using = LocalDateTimeToDateLongDeserializer.class) //反序列化类型转换。@JsonSetter("signConfirmTime")  //反序列化名称变化，源名称。//反序列化，转为es的viewdto。]]></description><category></category></item><item><title><![CDATA[按业务分组，如果，有做过变更1取最新一次的金额，否则，金额求和]]></title><link>https://blog.csdn.net/wz2008/article/details/129769068</link><guid>https://blog.csdn.net/wz2008/article/details/129769068</guid><author>wz2008</author><pubDate>Sat, 25 Mar 2023 16:57:49 +0800</pubDate><description><![CDATA[SUBSTRING_INDEX(SUBSTRING_INDEX(GROUP_CONCAT(money order by ci.create_time desc),',',locate('1',GROUP_CONCAT(change_type order by ci.create_time desc separator ''))),',',-1) -- 取最后一次变更金额。如果，组内有为chang_type =1的，则取最新一个change_type=1的金额，如图：按arrair_id分组，]]></description><category></category></item><item><title><![CDATA[查询sql优化]]></title><link>https://blog.csdn.net/wz2008/article/details/129648774</link><guid>https://blog.csdn.net/wz2008/article/details/129648774</guid><author>wz2008</author><pubDate>Sun, 19 Mar 2023 11:59:11 +0800</pubDate><description><![CDATA[问题：当limit偏移量越来越大时，耗时越来越大。]]></description><category></category></item><item><title><![CDATA[ElasticSearch的Long字段截取]]></title><link>https://blog.csdn.net/wz2008/article/details/129648383</link><guid>https://blog.csdn.net/wz2008/article/details/129648383</guid><author>wz2008</author><pubDate>Sun, 19 Mar 2023 11:51:36 +0800</pubDate><description><![CDATA[ElasticSearch的Long字段截取]]></description><category></category></item><item><title><![CDATA[mysql char_length()与length()区别]]></title><link>https://blog.csdn.net/wz2008/article/details/123817834</link><guid>https://blog.csdn.net/wz2008/article/details/123817834</guid><author>wz2008</author><pubDate>Tue, 29 Mar 2022 11:53:32 +0800</pubDate><description><![CDATA[select char_length('aA啊')
结果：3 。字符
select length('aA啊')
库utf8字符集下，结果：5。 字节。因为utf8编码下，一个汉字占用3个字节
]]></description><category></category></item><item><title><![CDATA[org.springframework.http.converter.HttpMessageNotReadableException: Required request body is missing]]></title><link>https://blog.csdn.net/wz2008/article/details/123280514</link><guid>https://blog.csdn.net/wz2008/article/details/123280514</guid><author>wz2008</author><pubDate>Fri, 04 Mar 2022 17:06:07 +0800</pubDate><description><![CDATA[问题场景：

postman的POST请求在body里传json格式的参数。

自定义filter过滤Controller，filter用于记录接口调用日志，filter里记录日志时，需要获取json格式的body数据，使用了


request.getReader();

或


 request.getInputStream()

那么Controller就报错：

org.springframework.http.converter.HttpMessageNotReadableException: R]]></description><category></category></item><item><title><![CDATA[mysql sql性能优化基础 sql的执行顺序]]></title><link>https://blog.csdn.net/wz2008/article/details/122491974</link><guid>https://blog.csdn.net/wz2008/article/details/122491974</guid><author>wz2008</author><pubDate>Fri, 14 Jan 2022 13:08:59 +0800</pubDate><description><![CDATA[sql的执行顺序
手写顺序




机读顺序




总结




①From：对from左边的表和右边的表计算笛卡尔积，产生虚拟表c1
②On：对c1中的数据进行on过滤，只有符合过滤条件的数据记录才会记录在虚拟表c2中
③Join：若指定了连接条件(left、right)，主表中的未匹配的行就会作为外部行添加到c2中，生成虚拟表c3
④Where：对虚拟表c3中的数据进行条件过滤，符合过滤条件的记录插入到虚拟表c4中
⑤Group by：根据group by子句中的列，对c4中的记录进行分组操作，生成.]]></description><category></category></item><item><title><![CDATA[mysql select 查询，使用列别名无效问题]]></title><link>https://blog.csdn.net/wz2008/article/details/80594785</link><guid>https://blog.csdn.net/wz2008/article/details/80594785</guid><author>wz2008</author><pubDate>Wed, 06 Jun 2018 14:49:17 +0800</pubDate><description><![CDATA[select s_username as username from userinfo结果别名没生效，查询结果还是s_username，而不是username解决办法：jdbc 5.1.x版本驱动，请在数据库连接url指定 useOldAliasMetadataBehavior=true 即可如：jdbc:mysql://localhost:3306/rimmsfz?useOldAliasMeta...]]></description><category></category></item><item><title><![CDATA[myeclipse8.5内置eclipse3.5]]></title><link>https://blog.csdn.net/wz2008/article/details/78830132</link><guid>https://blog.csdn.net/wz2008/article/details/78830132</guid><author>wz2008</author><pubDate>Mon, 18 Dec 2017 10:03:15 +0800</pubDate><description><![CDATA[myeclipse8.5 

支持 Tomcat4、5、6
支持jdk编译版本1.3、1.4、1.5、1.6
内置eclipse3.5.2]]></description><category></category></item><item><title><![CDATA[mybatis 获取id错误]]></title><link>https://blog.csdn.net/wz2008/article/details/46302637</link><guid>https://blog.csdn.net/wz2008/article/details/46302637</guid><author>wz2008</author><pubDate>Mon, 01 Jun 2015 11:31:59 +0800</pubDate><description><![CDATA[配置：
 
  
   select * from spis_attachment where irecordid in 
  ]]>
   
    
     #{item.irecordid}
     ]]>
   
  
执行报错：
 
[2015-06-01 11:03:40,860][ERROR] - 获取id为cn.gov.pbc.spis.common.]]></description><category></category></item><item><title><![CDATA[启动tomcat 停止在信息: Initializing Spring root WebApplicationContext]]></title><link>https://blog.csdn.net/wz2008/article/details/45869099</link><guid>https://blog.csdn.net/wz2008/article/details/45869099</guid><author>wz2008</author><pubDate>Wed, 20 May 2015 12:15:45 +0800</pubDate><description><![CDATA[在eclipse（ luna版）中，启tomcat8，停止在
信息: Initializing Spring root WebApplicationContext
犯的低级错误，没启动db2数据，一直等待，把db2启动后，再启动正常。
 
这个问题之前，tomcat 启动超时45，把server启动timeouts-start改为450，之后，就一直停留在
信息: Initializin]]></description><category></category></item><item><title><![CDATA[activiti-explorer 使用db2数据库，启动tomcat时报错]]></title><link>https://blog.csdn.net/wz2008/article/details/45669225</link><guid>https://blog.csdn.net/wz2008/article/details/45669225</guid><author>wz2008</author><pubDate>Tue, 12 May 2015 14:55:16 +0800</pubDate><description><![CDATA[﻿﻿


com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2030][11211][4.16.53] 在对连接的底层 socket、socket input stream 或 socket output stream 执行操作期间 

发生通信错误。错误位置：Reply.fill() - in]]></description><category></category></item><item><title><![CDATA[db2 导出数据 db2move &dbname export]]></title><link>https://blog.csdn.net/wz2008/article/details/9019625</link><guid>https://blog.csdn.net/wz2008/article/details/9019625</guid><author>wz2008</author><pubDate>Tue, 04 Jun 2013 09:51:24 +0800</pubDate><description><![CDATA[问题：
>db2move WMDW export
 
 
Error opening list file db2move.lst for writing (errno 2).  Terminating ...
 
**Error occured while opening a file.
 
 
End time:  Tue Jun  4 18:29:34 2013

解决方]]></description><category></category></item><item><title><![CDATA[com.microsoft.sqlserver.jdbc.SQLServerException: 不支持此服务器版本。目标服务器必须是 SQL Server 2000 或更高版本。]]></title><link>https://blog.csdn.net/wz2008/article/details/8699989</link><guid>https://blog.csdn.net/wz2008/article/details/8699989</guid><author>wz2008</author><pubDate>Thu, 21 Mar 2013 10:39:31 +0800</pubDate><description><![CDATA[使用hibernate连接sqlserver2008（之前连的是2005），错误：
com.microsoft.sqlserver.jdbc.SQLServerException: 不支持此服务器版本。目标服务器必须是 SQL Server 2000 或更高版本。


办法：下载新的支持2008的jdbc驱动：sqljdbc4.jar   。

下载后导入工程lib目录中，再把旧的sq]]></description><category></category></item><item><title><![CDATA[com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机 localhost 的 TCP/IP 连接失败]]></title><link>https://blog.csdn.net/wz2008/article/details/8699512</link><guid>https://blog.csdn.net/wz2008/article/details/8699512</guid><author>wz2008</author><pubDate>Thu, 21 Mar 2013 09:37:31 +0800</pubDate><description><![CDATA[JDBC连接sql server 2008问题：
com.microsoft.sqlserver.jdbc.SQLServerException: 通过端口 1433 连接到主机 localhost 的 TCP/IP 连接失败。错误:“Connection refused: connect。请验证连接属性，并检查 SQL Server 的实例正在主机上运行，且在此端口接受 TCP/IP 连接，还]]></description><category></category></item><item><title><![CDATA[The type javax.servlet.http.HttpServletRequest cannot be resolved. It is indirectly   referenced fro]]></title><link>https://blog.csdn.net/wz2008/article/details/8664779</link><guid>https://blog.csdn.net/wz2008/article/details/8664779</guid><author>wz2008</author><pubDate>Tue, 12 Mar 2013 17:35:04 +0800</pubDate><description><![CDATA[错误：
The type javax.servlet.http.HttpServletRequest cannot be resolved. It is indirectly

 referenced from required .class files


缺少jar包，我增加了JavaEE 5的包即可
一般缺少的包，可这么做：


1、右键工程找到build path项]]></description><category></category></item><item><title><![CDATA[jbpm5.3的web设计器事物监听空指针错误，解决办法]]></title><link>https://blog.csdn.net/wz2008/article/details/8282662</link><guid>https://blog.csdn.net/wz2008/article/details/8282662</guid><author>wz2008</author><pubDate>Tue, 11 Dec 2012 15:28:56 +0800</pubDate><description><![CDATA[执行：http://localhost:8080/drools-guvnor时报错

NullPointerException 

                           org.jboss.seam.transaction.TransactionServletListener.requestInitialized(TransactionServletListener.jav]]></description><category></category></item><item><title><![CDATA[jbpm5.3+tomcat7+mysql5 进入jbpm-gwt-console时输入用户名密码（如krisv，krisv）报错]]></title><link>https://blog.csdn.net/wz2008/article/details/8216866</link><guid>https://blog.csdn.net/wz2008/article/details/8216866</guid><author>wz2008</author><pubDate>Fri, 23 Nov 2012 15:31:39 +0800</pubDate><description><![CDATA[java.lang.RuntimeException: Could not initialize stateful knowledge session: javax.naming.NameNotFoundException: Name [jboss/TransactionManager] is not bound in this Context. Unable to find [jboss].]]></description><category></category></item></channel></rss>