<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[linanqi_java的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/linanqi_java</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; linanqi_java]]></copyright><item><title><![CDATA[通过redis 有序集合(sorted set) 实现排行榜]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/120157823</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/120157823</guid><author>linanqi_java</author><pubDate>Tue, 07 Sep 2021 15:01:18 +0800</pubDate><description><![CDATA[1.业务背景

因公司业务需要，要实现某段时间内的实时榜单。如果实时count mysql数据库，用户流量一大，数据库肯定承受不住，而恰好redis提供了有序集合这个数据类型。

2.代码实践

1.Redis工具类


 
@Component
public class RedisComponent {
 
    @Autowired
    private StringRedisTemplate redisTemplate;
 
    /**
     * 添加一个元素, zset与set最大的区别]]></description><category></category></item><item><title><![CDATA[spring boot 通过redisTemplate 执行lua脚本]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/120156825</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/120156825</guid><author>linanqi_java</author><pubDate>Tue, 07 Sep 2021 14:35:13 +0800</pubDate><description><![CDATA[1.为什么要实现lua脚本

redis单一命令可以保证原子性，但是多个命令组合起来就不能保证原子性。比如先incry后


expire，incry命令是不能设置key的过期时间的，但是在工作中经常会设置incry key的过期时间，但是要保证原子性，所以引入lua脚本，同时lua脚本也可以实现分布式锁。

2.实践中遇到的坑

先贴代码


public Long incrEx(String key, Long defaultExpire){

    final String script =
   ]]></description><category></category></item><item><title><![CDATA[spring boot 整合quartz 遇到的坑]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/120134299</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/120134299</guid><author>linanqi_java</author><pubDate>Mon, 06 Sep 2021 15:09:23 +0800</pubDate><description><![CDATA[1.先描述一下问题

在开发过程中意外发现，在启动spring boot项目时quartz cronTirgger自动执行，也就是说定时任务被自动触发。

2.问题解决

查阅资料之后发现，和quartzmisfire(失火)策略有关，我们看下源码：



可以看到默认的失火策略为0，目前还不知道为0的具体含义，我们在看下面具体的方法：



这里定义了三种misfire策略(仅限于CronTrigger)，查阅资料：

1.withMisfireHandlingInstructionIgnoreMisf.]]></description><category></category></item><item><title><![CDATA[Apache POI 实现word(doc/docx)浏览器预览]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/109291562</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/109291562</guid><author>linanqi_java</author><pubDate>Mon, 26 Oct 2020 16:16:03 +0800</pubDate><description><![CDATA[一、环境准备

1.jdk：1.8

2.maven：3.6

3.springboot：2.2.2

二、maven主要依赖


&lt;dependency&gt;
    &lt;groupId&gt;org.apache.poi&lt;/groupId&gt;
    &lt;artifactId&gt;poi&lt;/artifactId&gt;
    &lt;version&gt;4.1.0&lt;/version&gt;
&lt;/dependency&gt;

&lt;dependency]]></description><category></category></item><item><title><![CDATA[pagehelper分页失效]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/103580177</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/103580177</guid><author>linanqi_java</author><pubDate>Tue, 17 Dec 2019 14:43:30 +0800</pubDate><description><![CDATA[1、问题描述

数据库总共12条记录，分页参数pageNum为3，pageSize为10，最后返回了两条数据

2.问题解决

pagehelper:
 helperDialect: mysql
 reasonable: true #开启优化，如果开启优化，在分页页码结果没有数据的时候,会显示最近有数据的页码数据
 supportMethodsArguments: true #是否支持接口...]]></description><category></category></item><item><title><![CDATA[关于freemarker一些属性值被maven属性值代替的问题]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/99459120</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/99459120</guid><author>linanqi_java</author><pubDate>Tue, 13 Aug 2019 18:20:18 +0800</pubDate><description><![CDATA[项目中freemarker模板中使用了${id}，结果id的值为maven的工程名，一查资料才知道，${name}，${version} ，${id}，${project.version}，${project.packaging}和${project.artifactId}等是被maven预定义的，出现此类问题，只需要把变量名修改一下即可。
...]]></description><category></category></item><item><title><![CDATA[IDEA下Maven依赖包下载不完整的解决方案]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/94019795</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/94019795</guid><author>linanqi_java</author><pubDate>Fri, 28 Jun 2019 17:04:05 +0800</pubDate><description><![CDATA[相信大家用idea的时候也会遇到相同的问题，我最开始的解决方案是把maven本地仓库删除重新下载，非常苦恼，但是今天get到了新的解决方案，在settings.xml中加入以下配置


&lt;mirror&gt;
    &lt;id&gt;nexus&lt;/id&gt;
    &lt;name&gt;internal nexus repository&lt;/name&gt;
    &l...]]></description><category></category></item><item><title><![CDATA[mybatis BigDecimal货币类型的值不能保存为0的问题]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/90670848</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/90670848</guid><author>linanqi_java</author><pubDate>Wed, 29 May 2019 14:54:47 +0800</pubDate><description><![CDATA[mybatis xml中之前的写法



&lt;if test="balance != null and balance!=''"&gt;
   balance = #{balance},
&lt;/if&gt;

更改后的写法


&lt;if test="balance != null"&gt;
   balance = #{balance},
&lt;/if&gt;

在debug调试的...]]></description><category></category></item><item><title><![CDATA[java 调用微信JsApi支付]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/89556519</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/89556519</guid><author>linanqi_java</author><pubDate>Fri, 26 Apr 2019 16:53:20 +0800</pubDate><description><![CDATA[1、首先查看微信支付官方文档了解支付流程

https://pay.weixin.qq.com/wiki/doc/api/jsapi.php?chapter=7_3



2、编写统一下单接口


public class WxPayUtil  {
   public static final String PAY_URL="https://api.mch.weixin.qq.com/pay/un...]]></description><category></category></item><item><title><![CDATA[解决jdk1.7https 请求是TLS1不支持TLS1.2的问题]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/89504411</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/89504411</guid><author>linanqi_java</author><pubDate>Wed, 24 Apr 2019 22:33:35 +0800</pubDate><description><![CDATA[如果可以升级jdk把jdk升级到1.8就可以解决，今天被这个困扰了一上午，老是抛出异常connection reset，下面来说一下解决方法


package com.miaodiyun.httpapidemo.common;

import java.io.ByteArrayInputStream;
import java.io.ByteArrayOutputStream;  
import...]]></description><category></category></item><item><title><![CDATA[mybatis 批量insert和批量update]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/89466759</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/89466759</guid><author>linanqi_java</author><pubDate>Tue, 23 Apr 2019 10:07:29 +0800</pubDate><description><![CDATA[首先在数据库连接的url中增加allowMultiQueries=true的配置

1、批量insert

&lt;insert id="insertBatch" parameterType="java.util.List"&gt;
  INSERT recharge_record(
    equipment_id,
   recharge_amo...]]></description><category></category></item><item><title><![CDATA[spring mvc 解决跨域问题]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/89213024</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/89213024</guid><author>linanqi_java</author><pubDate>Thu, 11 Apr 2019 16:03:32 +0800</pubDate><description><![CDATA[1、在web.xml中配置

&lt;filter&gt;

&lt;filter-name&gt;CORS&lt;/filter-name&gt;

&lt;filter-class&gt;com.thetransactioncompany.cors.CORSFilter&lt;/filter-class&gt;

&lt;init-param&g...]]></description><category></category></item><item><title><![CDATA[nginx 安装和配置]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/84553658</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/84553658</guid><author>linanqi_java</author><pubDate>Mon, 26 Nov 2018 18:05:58 +0800</pubDate><description><![CDATA[一、安装

wget -c https://nginx.org/download/nginx-1.10.1.tar.gz

tar -zxvf nginx-1.10.1.tar.gz
cd nginx-1.10.1

make
make install
查找安装路径：

whereis nginx

启动、停止nginx
cd /usr/local/nginx/sbin/
./nginx 
./n...]]></description><category></category></item><item><title><![CDATA[spring boot 登录拦截]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/84404322</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/84404322</guid><author>linanqi_java</author><pubDate>Fri, 23 Nov 2018 22:11:42 +0800</pubDate><description><![CDATA[一、pom 文件配置

&amp;lt;parent&amp;gt;
    &amp;lt;groupId&amp;gt;org.springframework.boot&amp;lt;/groupId&amp;gt;
    &amp;lt;artifactId&amp;gt;spring-boot-starter-parent&amp;lt;/artifactId&amp;gt;
    &amp;lt;version&amp;gt;2.0.3.RELEASE&amp;lt;/version&amp;]]></description><category></category></item><item><title><![CDATA[layui 下拉框三级联动]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/84394141</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/84394141</guid><author>linanqi_java</author><pubDate>Fri, 23 Nov 2018 15:32:24 +0800</pubDate><description><![CDATA[项目需要用layui的三级联动，自己瞎整了一下，做个记录

1.表结构设计

CREATE TABLE `dt_area` (
 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '区域主键',
 `area_name` varchar(16) DEFAULT NULL COMMENT '区域名称',
 `area_code` varchar(128)...]]></description><category></category></item><item><title><![CDATA[kaptcha验证码]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/83508409</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/83508409</guid><author>linanqi_java</author><pubDate>Mon, 29 Oct 2018 16:49:12 +0800</pubDate><description><![CDATA[1.引入maven依赖


&amp;lt;!--验证码--&amp;gt;
&amp;lt;dependency&amp;gt;
   &amp;lt;groupId&amp;gt;com.github.penggle&amp;lt;/groupId&amp;gt;
   &amp;lt;artifactId&amp;gt;kaptcha&amp;lt;/artifactId&amp;gt;
   &amp;lt;version&amp;gt;2.3.2&amp;lt;/version&amp;gt;
 ]]></description><category></category></item><item><title><![CDATA[spring boot 整合mybatis+generator插件+pagehelper插件]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/83508041</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/83508041</guid><author>linanqi_java</author><pubDate>Mon, 29 Oct 2018 16:38:31 +0800</pubDate><description><![CDATA[mybatis相信大家都用过，就不做过多阐述，数据库用的是mysql，以mysql为例

1.引入maven依赖


&amp;lt;/dependency&amp;gt;
&amp;lt;!-- 分页插件 --&amp;gt;
&amp;lt;dependency&amp;gt;
   &amp;lt;groupId&amp;gt;com.github.pagehelper&amp;lt;/groupId&amp;gt;
   &amp;lt;artifactId&amp;gt;pageh...]]></description><category></category></item><item><title><![CDATA[spring boot thymeleaf简单使用]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/83507310</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/83507310</guid><author>linanqi_java</author><pubDate>Mon, 29 Oct 2018 16:17:33 +0800</pubDate><description><![CDATA[spring4推荐使用thymeleaf模板进行开发，刚好最近需要使用，一起来学习一下

1.加入maven依赖


&amp;lt;dependency&amp;gt;
   &amp;lt;groupId&amp;gt;net.sourceforge.nekohtml&amp;lt;/groupId&amp;gt;
   &amp;lt;artifactId&amp;gt;nekohtml&amp;lt;/artifactId&amp;gt;
   &amp;lt;version...]]></description><category></category></item><item><title><![CDATA[spring boot 配置druid连接池+后台管理]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/83506313</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/83506313</guid><author>linanqi_java</author><pubDate>Mon, 29 Oct 2018 15:34:25 +0800</pubDate><description><![CDATA[1.引入maven依赖

由于我用的是mysql数据库，引入的是mysql的驱动包


&amp;lt;dependency&amp;gt;
   &amp;lt;groupId&amp;gt;mysql&amp;lt;/groupId&amp;gt;
   &amp;lt;artifactId&amp;gt;mysql-connector-java&amp;lt;/artifactId&amp;gt;
&amp;lt;/dependency&amp;gt;


&amp;lt;dependency...]]></description><category></category></item><item><title><![CDATA[ckeditor 文件上传]]></title><link>https://blog.youkuaiyun.com/linanqi_java/article/details/59490665</link><guid>https://blog.youkuaiyun.com/linanqi_java/article/details/59490665</guid><author>linanqi_java</author><pubDate>Thu, 02 Mar 2017 13:18:48 +0800</pubDate><description><![CDATA[1.从官网下载ckeditor最新版本,ckeditor-full-4.6.1.zip


2.解压压缩文件，把解压出来的文件放到项目的WebRoot文件夹下


3.在需要使用在线编辑的页面导入ckeditor.js(由于我们使用ssm框架，一定要记得放行，不然会被拦截)

    
    
    CKEDITOR.replace( "editor1")(此处textar]]></description><category></category></item></channel></rss>