<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[YRn_V的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/YRn_V</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; YRn_V]]></copyright><item><title><![CDATA[导出导入中可能存在得数据乱码问题]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/145858505</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/145858505</guid><author>YRn_V</author><pubDate>Tue, 25 Feb 2025 17:37:18 +0800</pubDate><description><![CDATA[导入乱码]]></description><category></category></item><item><title><![CDATA[oracle数据库，其他人连接报错：ORA-12541:TNS:no listener]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/142463244</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/142463244</guid><author>YRn_V</author><pubDate>Mon, 23 Sep 2024 17:14:07 +0800</pubDate><description><![CDATA[ORA-12541:TNS:no listener]]></description><category></category></item><item><title><![CDATA[clob类型值转blob类型并存入数据库中 oracle]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/135501804</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/135501804</guid><author>YRn_V</author><pubDate>Wed, 10 Jan 2024 13:57:04 +0800</pubDate><description><![CDATA[clob转blob，字符串转blob]]></description><category></category></item><item><title><![CDATA[不区分大小写的map]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/134383144</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/134383144</guid><author>YRn_V</author><pubDate>Mon, 13 Nov 2023 17:55:20 +0800</pubDate><description><![CDATA[CaseInsensitiveMap]]></description><category></category></item><item><title><![CDATA[监控某个线程异常导致整个线程池奔溃的问题]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/133807730</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/133807730</guid><author>YRn_V</author><pubDate>Fri, 13 Oct 2023 11:50:45 +0800</pubDate><description><![CDATA[通过设置时间段，来监控回调函数s在一定时间内未返回，则认为此函数异常，此时抛出该异常，释放当前线程，避免因为某个线程一直不释放导致整体线程池出问题]]></description><category></category></item><item><title><![CDATA[oracel数据库sql语句双重循环]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/130089484</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/130089484</guid><author>YRn_V</author><pubDate>Tue, 11 Apr 2023 17:40:07 +0800</pubDate><description><![CDATA[双重循环查询sql语句]]></description><category></category></item><item><title><![CDATA[读取文件内容，并转成字符串]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/129948860</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/129948860</guid><author>YRn_V</author><pubDate>Tue, 04 Apr 2023 11:25:30 +0800</pubDate><description><![CDATA[String filePath = “文件的绝对路径+文件名称”;废话不多说，直接赋代码。]]></description><category></category></item><item><title><![CDATA[代码重构学习感悟]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/129948233</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/129948233</guid><author>YRn_V</author><pubDate>Tue, 04 Apr 2023 11:12:15 +0800</pubDate><description><![CDATA[代码结构的流失是累积性的，愈难看出代码所代表的设计意图，就愈难保护其中设计，于是该设计就腐败的愈快。为即将修改的代码建立一组可靠的测试环境，同时测试程序需要给出具体的测试结果，要么确认通过，要么给出列出具体的失败清单，保证说测试程序能够自我校验。代码重构，需了解重构的原理和最佳实践方式，并明确何时、何地、何处挖掘代码，通过不同的手法和技术变动，并通过代码的验证，减少开发过程中存在的风险。每遇到某种变化，都必须在不同的类内做出许多小修改，修改的代码散布四处，不但很难找到，且容易忘记某个重要的修改。]]></description><category></category></item><item><title><![CDATA[Cacheable注解使用注意事项]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/125233811</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/125233811</guid><author>YRn_V</author><pubDate>Sat, 11 Jun 2022 13:36:21 +0800</pubDate><description><![CDATA[@Cacheable]]></description><category></category></item><item><title><![CDATA[复杂对象集合与map之间的相互转换]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/119897275</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/119897275</guid><author>YRn_V</author><pubDate>Tue, 24 Aug 2021 19:42:46 +0800</pubDate><description><![CDATA[一、泛型是map的list集合转换成对象集合


/**
 * 转换复杂的对象集合
 *
 * @param listMap
 * @param T
 * @param &lt;T&gt;
 * @return
 */
public static &lt;T&gt; List&lt;T&gt; castComplexObjectList(List&lt;Map&lt;String, Object&gt;&gt; listMap, Class T) {
    List&lt;T&gt; beanList =]]></description><category></category></item><item><title><![CDATA[泛型为Map的List集合中Double和BigDecimal类型数据求和]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/109036787</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/109036787</guid><author>YRn_V</author><pubDate>Mon, 12 Oct 2020 21:00:08 +0800</pubDate><description><![CDATA[泛型为Map的List集合中Double和BigDecimal类型数据求和
1》Double类型
Double pfs = collects.stream().mapToDouble(c -&gt; CommonUtils.isNumber(StringUtil.nvl(c.get(“pfs”), “0”)) ?
Double.parseDouble(StringUtil.nvl(c.get(“pfs”), “0”)) : 0.00).summaryStatistics().getSum();
2》BigD]]></description><category></category></item><item><title><![CDATA[Activiti数据库表结构(表详细版)]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108853005</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108853005</guid><author>YRn_V</author><pubDate>Mon, 28 Sep 2020 16:52:22 +0800</pubDate><description><![CDATA[Activiti数据库表结构(表详细版)
转载地址：https://blog.youkuaiyun.com/hj7jay/article/details/51302829

]]></description><category></category></item><item><title><![CDATA[excel导入，解决数值型千分位逗号的问题]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108652147</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108652147</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 20:17:58 +0800</pubDate><description><![CDATA[excel导入，解决数值型千分位逗号的问题
Double cellValue = cell.getNumericCellValue();
if (cellValue == null || cellValue - 0.0 &lt; 1e-6) {
value = “0”;
} else {
value = new DecimalFormat(“0.00”).format(cellValue);
}
if (value.indexOf(",") &gt;= 0) {
value = value.replaceA]]></description><category></category></item><item><title><![CDATA[excel文件导入，同时兼容.xls和.xlsx]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108652072</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108652072</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 20:16:14 +0800</pubDate><description><![CDATA[**
excel文件导入，同时兼容.xls和.xlsx
这里呢多说无益，直接附上代码，供各位小伙伴查询，如有不足之处，还望大家踊跃指出，互相进步
/
* 导入excel文件
*
* @param importDataQo
* @return
*/
@Override
public CheckMsg impData(ImportDataQo importDataQo) {
Map&lt;String, Object&gt; resultMap = new HashMap&lt;&gt;();
File exc]]></description><category></category></item><item><title><![CDATA[IDEA启动环境中找不到SpringBoot图标]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108651709</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108651709</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 19:59:14 +0800</pubDate><description><![CDATA[**
IDEA启动环境中找不到SpringBoot图标
转载：https://blog.youkuaiyun.com/AdminPwd/article/details/90713406
1》写项目的时候，不小心把右上角SpringBoot启动环境给整没了，解决方案
File 》Settings》Plugins

再重启IDEA软件，并在启动类里启动，就好了
2》如果这里没有这个选项就重新安装一个就好

...]]></description><category></category></item><item><title><![CDATA[handsontable结合js-xlsx实现可编辑xlsx导入导出功能(参考)]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108651639</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108651639</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 19:53:47 +0800</pubDate><description><![CDATA[**
handsontable结合js-xlsx实现可编辑xlsx导入导出功能(参考)
**转载：https://blog.youkuaiyun.com/weixin_34015860/article/details/89611049?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromMachineLearnPai2-1.channel_param&amp;depth_1-utm_source=distribute.pc_relevant.n]]></description><category></category></item><item><title><![CDATA[本地不同电脑之间的mysql互相访问失败解决方案]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108651616</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108651616</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 19:51:56 +0800</pubDate><description><![CDATA[**
本地不同电脑之间的mysql互相访问失败解决方案
第一步：先找到控制面板中的防火墙，关闭所有的防火墙设置
第二步：找到防火墙中的入站规则，开启这俩个
1》报错：Access denied for user ‘root’@‘DESKTOP-1J7MF9C’(using password:YES)
解决办法：
2》报错：1045 - Access denied for user’root’@‘192.168.1.0’(using password:YES)
这个是说远程连接的root用户没有远程的权限
解]]></description><category></category></item><item><title><![CDATA[mysql数据库表结构引擎的小知识]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108651584</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108651584</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 19:49:48 +0800</pubDate><description><![CDATA[**
mysql数据库表结构引擎的小知识
**
mysql innodb引擎支持最大字段上线为1017；
mysql myisam引擎最大字段上限为2410；

]]></description><category></category></item><item><title><![CDATA[oracle数据库的dmp备份文件导入到本地]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108651545</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108651545</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 19:48:34 +0800</pubDate><description><![CDATA[oracle数据库的dmp备份文件导入到本地
注意：备份数据库的表空间与本地表空间要一致，否则无法导入
–建表空间
CREATE TABLESPACE pty
LOgging
DataFILE ‘E:\oracle\install\fileLocation\pty.DBF’
SIZE 50M
AUTOEXTEND ON
NEXT 50M MAXSIZE 20480M
EXTENT MANAGEMENT LOCAL;
–建用户
CREATE USER pitaya IDENTIFIED BY “123456”]]></description><category></category></item><item><title><![CDATA[mysql中出现Incorrect DECIMAL value: ‘0’ for column ‘’ at row -1错误解决方案]]></title><link>https://blog.youkuaiyun.com/YRn_V/article/details/108651489</link><guid>https://blog.youkuaiyun.com/YRn_V/article/details/108651489</guid><author>YRn_V</author><pubDate>Thu, 17 Sep 2020 19:46:01 +0800</pubDate><description><![CDATA[mysql中出现Incorrect DECIMAL value: ‘0’ for column ‘’ at row -1错误解决方案：	
原因：存储过程中使用了：函数CONVERT(IF(IN_YYJHFDL IS NULL,0,IN_EYJHFDL),DECIMAL(12,4))
　  在网上找了说是因为mysql的两个版本不一样造成的，是mysql的一个bug，5以上的版本如果是空值应该要写NULL
解决方案一：
my.ini中查找sql-mode
默认为sql-mode=“STRICT_TRANS_T]]></description><category></category></item></channel></rss>