<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[learnjava1989的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/learnjava1989</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; learnjava1989]]></copyright><item><title><![CDATA[SQLServer 迁移 MySQL：存储过程与 SQL 方言改造实录]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/170131954</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/170131954</guid><author>learnjava1989</author><pubDate>Thu, 05 Nov 2026 11:22:03 +0800</pubDate><description><![CDATA[三十来个存储过程，平均两百行，最长的一个七百多行。本来打算一个一个翻译：变量去掉 @、临时表换写法、异常处理换写法、IF 语法调一调。翻到第五个就发现方向不对。三个原因：一是 MySQL 的存储过程不好调试，出错只能临时加查询打点，改完自己都不敢确认逻辑对不对；二是嵌套 IF 一多，翻完的代码没人看得懂；三是这套东西后面还要维护。最后全部拆成 Java。拆法是按阶段拆，每个阶段落一张中间表：取基础数据 → 算中间指标 → 汇总 → 输出。每步能单独跑，能看中间结果，某个指标算错只改那一步。]]></description><category></category></item><item><title><![CDATA[docker 拉取镜像失败。报Error response from daemon]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/148762926</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/148762926</guid><author>learnjava1989</author><pubDate>Thu, 19 Jun 2025 11:51:12 +0800</pubDate><description><![CDATA[3.设置镜像地址（下载docker的镜像，非docker的images。解决：修改/etc/docker/daemon.json。配置阿里云镜像加速器：登录。4.安装docker。]]></description><category></category></item><item><title><![CDATA[CentOS 7停止在线更新 yum源失效解决办法]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/148761893</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/148761893</guid><author>learnjava1989</author><pubDate>Thu, 19 Jun 2025 11:14:44 +0800</pubDate><description><![CDATA[2.在etc/yum.repos.d/创建文件，名称为CentOS-Vault.repo。原因不多说，按照以下步骤可以替换成清华大学的yum源。1.先删除自带的源，反正已停更，留着也是累赘..！]]></description><category></category></item><item><title><![CDATA[sql查询中将表中的记录按照某个字段中的分割符分成多行]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/142177434</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/142177434</guid><author>learnjava1989</author><pubDate>Thu, 12 Sep 2024 15:49:40 +0800</pubDate><description><![CDATA[数据库表记录一行转多行]]></description><category></category></item><item><title><![CDATA[idea配置jdk版本遇到的坑!--java: 源发行版 18 与 --enable-preview 一起使用时无效]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/140666252</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/140666252</guid><author>learnjava1989</author><pubDate>Wed, 24 Jul 2024 16:41:21 +0800</pubDate><description><![CDATA[java: 源发行版 18 与 --enable-preview 一起使用时无效
新特性无法使用！]]></description><category></category></item><item><title><![CDATA[sqlserver 存储过程模板 备用]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/134673231</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/134673231</guid><author>learnjava1989</author><pubDate>Tue, 28 Nov 2023 17:47:02 +0800</pubDate><description><![CDATA[【代码】sqlserver 存储过程模板 备用。]]></description><category></category></item><item><title><![CDATA[查询条件为同一表中的两个字段]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/134144671</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/134144671</guid><author>learnjava1989</author><pubDate>Tue, 31 Oct 2023 17:14:06 +0800</pubDate><description><![CDATA[需求：表中有两个字段 a  b  其中 b的值为preStr_x（如preStr_width,preStr_height）要求查询出a=x的记录,即上图中第2，4条记录。废话不多说，直接上sql。]]></description><category></category></item><item><title><![CDATA[sqlserver 过滤手机号]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/134144481</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/134144481</guid><author>learnjava1989</author><pubDate>Tue, 31 Oct 2023 16:59:34 +0800</pubDate><description><![CDATA[项目中从第三方拉取的数据，需要过滤掉非手机号的数据，当然可以通过写java脚本进行过滤，但是我们已经把数据拉取到数据库了，为了方便，我想直接通过sql把不符合要求的数据删除了，话不多说，直接上sql。]]></description><category></category></item><item><title><![CDATA[控制台打印sql语句设置总结]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/133386947</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/133386947</guid><author>learnjava1989</author><pubDate>Thu, 28 Sep 2023 17:04:18 +0800</pubDate><description><![CDATA[其中的xxx替换成mapper包的路径即可如com.a.b.c。直接修改mybatis-config.xml添加如下代码到。标签里面。]]></description><category></category></item><item><title><![CDATA[java 使用httppost设置json参数发送请求]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/132857217</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/132857217</guid><author>learnjava1989</author><pubDate>Wed, 13 Sep 2023 16:29:05 +0800</pubDate><description><![CDATA[核心代码如下，其中有个对参数进行hash+salt加密方法名为 getSignature（），httppost设置参数主要靠xxxeneity,详情可以百度查看使用！对接第三方接口时，有时接口要求参数为json格式，留个笔记备用！getSignature（）具体代码如下图一。发送请求并获取响应的代码如下图二。]]></description><category></category></item><item><title><![CDATA[dubbo加zookeeper遇到的坑]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/132534061</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/132534061</guid><author>learnjava1989</author><pubDate>Mon, 28 Aug 2023 10:46:44 +0800</pubDate><description><![CDATA[项目昨天还可以正产启动，今天突然驱动报错：Opening socket connection to server localhost/127.0.0.1:2181. Will not attempt to.....  发现zookeeper服务无法启动，手动启动后发现启动失败，去查zookeeper日志发现报Severe unrecoverable error, exiting，百度后说是由于zookeeper生成大量的日志及快照文件，导致了zookeeper安装目录内的分区磁盘使用率达到100%，快速进入]]></description><category></category></item><item><title><![CDATA[根据pdm自动生成java代码操作记录]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/131705940</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/131705940</guid><author>learnjava1989</author><pubDate>Thu, 13 Jul 2023 16:53:03 +0800</pubDate><description><![CDATA[用工具直接生成即可出现上图中的各层代码。工具：powderdsigner 16。1.打开pdm新建module。生成的目录结构大概如下。]]></description><category></category></item><item><title><![CDATA[使用vagant 和 Virtualbox时需要注意的事项]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/131111068</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/131111068</guid><author>learnjava1989</author><pubDate>Thu, 08 Jun 2023 16:57:26 +0800</pubDate><description><![CDATA[vagant up 无反应]]></description><category></category></item><item><title><![CDATA[BigDecimal判断为零避坑]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/129921382</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/129921382</guid><author>learnjava1989</author><pubDate>Mon, 03 Apr 2023 09:03:39 +0800</pubDate><description><![CDATA[后来查文档发现，BigDecimal用equals时会进行两个判断，先判断精度是否相同，如果不相同直接返回false，经度相同的情况下再判断值是否相同。在需要判断BigDecimal是否为0时需要用compareto（）方法。看代码如下，刚开始没发现问题。]]></description><category></category></item><item><title><![CDATA[mybaties使用笔记]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/129815601</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/129815601</guid><author>learnjava1989</author><pubDate>Tue, 28 Mar 2023 14:34:56 +0800</pubDate><description><![CDATA[2.当条件为判断给定的字符串是否是数据库中字段的某个元素时。1.当条件中有and和or时。]]></description><category></category></item><item><title><![CDATA[js以map形式组装数据]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/129666723</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/129666723</guid><author>learnjava1989</author><pubDate>Mon, 20 Mar 2023 14:23:18 +0800</pubDate><description><![CDATA[【代码】js以map形式组装数据。]]></description><category></category></item><item><title><![CDATA[Dubbo在工作中的使用流程]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/129545709</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/129545709</guid><author>learnjava1989</author><pubDate>Wed, 15 Mar 2023 10:54:36 +0800</pubDate><description><![CDATA[简单流程：根据配置文件访问zookeeper获取服务的地址列表，进而远程调用服务.3.在xxx-dubbo模块引入api模块及xxx-serviceImpl。2.在xxx-serviceImpl模块编写serviceImpl。前提：在各个模块引入dubbo依赖，或者只在公共模块引入也行。1.在公共模块xxx-api编写service。4.xxx-dubbo模块暴露服务。6.在web模块代码中使用。5.在web模块暴露服务。dubbo配置文件示例。]]></description><category></category></item><item><title><![CDATA[根据提供的规格数据（Map＜规格名称，List＜规格值＞＞），实现生成规格商品]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/129530158</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/129530158</guid><author>learnjava1989</author><pubDate>Tue, 14 Mar 2023 15:49:54 +0800</pubDate><description><![CDATA[前提是规格项数量不确定，按照顺序，同一规格项的数据自动合并单元格，简单的实现逻辑如下。其中getRows（）方法如下。]]></description><category></category></item><item><title><![CDATA[对日期的各种操作]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/129529146</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/129529146</guid><author>learnjava1989</author><pubDate>Tue, 14 Mar 2023 15:35:05 +0800</pubDate><description><![CDATA[由于需要统计某一时间段内的数据，必须以起止时间作为条件进行查询，并且需要跟其他周期的数据进行对比，所以需要对时间进行各种操作，记录方便后面查看！Calendar 根据指定的字符串生成指定的日期，并可方便的获取年份，月份，周几，几号，本月最大天数，等信息。如果按月或者按天，则上一个统计周期直接在月份上减1或者在日期上减1会出现边界问题，所以需要进行如下处理。需求，根据传参以年、月，日为时间段获取统计数据，并且获取上一个统计周期的数据进行比较。例如2023-3-14 15:25:25。]]></description><category></category></item><item><title><![CDATA[小程序装修重构思维导图]]></title><link>https://blog.youkuaiyun.com/learnjava1989/article/details/129528677</link><guid>https://blog.youkuaiyun.com/learnjava1989/article/details/129528677</guid><author>learnjava1989</author><pubDate>Tue, 14 Mar 2023 15:12:42 +0800</pubDate><description><![CDATA[自用。]]></description><category></category></item></channel></rss>