<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[han_xiaoxue的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/han_xiaoxue</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; han_xiaoxue]]></copyright><item><title><![CDATA[mysql视图的创建查询和删除]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106237064</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106237064</guid><author>han_xiaoxue</author><pubDate>Wed, 20 May 2020 15:21:30 +0800</pubDate><description><![CDATA[CREATE VIEW myView AS 
select
         tss.channel_id as channelId,
        tssr.risk_id as riskId,
        count(tssr.risk_id) as riskCount
        from  t_slaq_salesman_20191225 tss 
        JOIN t_slaq_salesman_risk_20191225 tssr
        on tssr.salesma]]></description><category></category></item><item><title><![CDATA[select查询语句直接insert入库]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106236321</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106236321</guid><author>han_xiaoxue</author><pubDate>Wed, 20 May 2020 14:55:26 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[mybatis mysql批量插入数据]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106235811</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106235811</guid><author>han_xiaoxue</author><pubDate>Wed, 20 May 2020 14:43:53 +0800</pubDate><description><![CDATA[在数据落库过程中，如有数据量过大，通过for循环多次连接数据库插入数据，会非常消耗性能，并且数据量越大，会发现执行速度越慢。
代码中for循环落库示例
for(TESSChouDangResult result :haveqyResult){
		tESSChouDangResultMapper.insertChouDangResultOne(result );
}

int insertChouDangResultOne(TESSChouDangResult haveqyResult);

上边这个循环，]]></description><category></category></item><item><title><![CDATA[mybatis mysql插入和修改语句，去掉或替换指定字符]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106235678</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/106235678</guid><author>han_xiaoxue</author><pubDate>Wed, 20 May 2020 14:32:42 +0800</pubDate><description><![CDATA[有的时候数据过来的时候带着一些，我们并不想存入到数据库中的字符，我们可以在mybatis中替换成空或者我们想要的字符。
如下图：将字段中的 # 换成 ‘’


]]></description><category></category></item><item><title><![CDATA[kafka学习笔记]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103994163</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103994163</guid><author>han_xiaoxue</author><pubDate>Wed, 15 Jan 2020 18:26:13 +0800</pubDate><description><![CDATA[一、为什么要用kafka（消息队列）
1.1 解耦
解耦这个词，是开发里老生常谈的东西了，从分布式，到微服务。从消息队列到kafka，各种优点，貌似都要提到这个解耦。那么中间件解耦的原理主要是什么呢 ？

1.2 异步

1.3 降压

...]]></description><category></category></item><item><title><![CDATA[mybatis mysql存储过程]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103972933</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103972933</guid><author>han_xiaoxue</author><pubDate>Tue, 14 Jan 2020 14:48:20 +0800</pubDate><description><![CDATA[mapper里原始sql
select
        tss.channel_id as channelId,
        tssr.risk_id as riskId,
        count(tssr.risk_id) as riskCount
        from  ${riskTableName} tssr
        right JOIN ${salesmanTable...]]></description><category></category></item><item><title><![CDATA[kafka的安装及启动消费者报 Connection to node could not be established. Broker may not be vailable]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103895977</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103895977</guid><author>han_xiaoxue</author><pubDate>Wed, 08 Jan 2020 18:15:56 +0800</pubDate><description><![CDATA[下载地址
https://www.apache.org/dyn/closer.cgi?path=/kafka/2.4.0/kafka_2.12-2.4.0.tgz

解压并启动
下载后，解压放在D:\kafka目录下。
找到文件"D:\kafka\kafka_2.11-2.2.0\configserver.properties"
修改此处log.dirs=/tmp/kafka-logs to lo...]]></description><category></category></item><item><title><![CDATA[端口被占用，杀死进程,释放端口]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103857065</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103857065</guid><author>han_xiaoxue</author><pubDate>Mon, 06 Jan 2020 14:31:34 +0800</pubDate><description><![CDATA[端口被占用，杀死进程,释放端口根据端口号找到对应pid并删除
根据端口号找到对应pid并删除



]]></description><category></category></item><item><title><![CDATA[combotree下拉树模糊查询联动查询]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103703782</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103703782</guid><author>han_xiaoxue</author><pubDate>Wed, 25 Dec 2019 18:33:25 +0800</pubDate><description><![CDATA[combotree下拉树模糊查询联动查询combotree基本查询js写法联想搜索
combotree基本查询js写法
默认折叠子节点，想要联想搜索好使  把这注释掉，默认展开所有节点
&lt;div style="margin-bottom:20px"&gt;
            &lt;input id="organTree" class="easyui-combotree"  promp...]]></description><category></category></item><item><title><![CDATA[ajax传递json字符串，后台接收]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103664525</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103664525</guid><author>han_xiaoxue</author><pubDate>Mon, 23 Dec 2019 14:13:11 +0800</pubDate><description><![CDATA[JS

Controller


]]></description><category></category></item><item><title><![CDATA[JS和controller传特殊字符]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103664200</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/103664200</guid><author>han_xiaoxue</author><pubDate>Mon, 23 Dec 2019 14:08:41 +0800</pubDate><description><![CDATA[JS和controller传特殊字符JS调用方法传参（特殊字符）** is not defind代码调用后台方法传参（特殊字符）encodeURIComponent()
JS调用方法传参（特殊字符）
** is not defind
传的参数是“A+1”，js报下边的错

代码

很简单的一个function调用，报错原因起初以为是“+”是特殊字符，才会出现这种情况。但后来发现，参数传递，所谓的特...]]></description><category></category></item><item><title><![CDATA[多线程应用 —— Future+Callable]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/90601072</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/90601072</guid><author>han_xiaoxue</author><pubDate>Mon, 27 May 2019 12:07:11 +0800</pubDate><description><![CDATA[业务场景
调用第三方接口，对方一次最多返回30条数据，想查取更多条数据时，使用多线程多次取值，最后整合数据，获取想要结果集。
Spring 配置线程池
&lt;bean id="queryFlightLowPriceExecutor" 
	    class="org.springframework.scheduling.concurrent.ThreadPoolTaskExecutor"&gt;...]]></description><category></category></item><item><title><![CDATA[EasyUI —— 下拉选模糊匹配搜索]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/90031545</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/90031545</guid><author>han_xiaoxue</author><pubDate>Thu, 09 May 2019 13:52:48 +0800</pubDate><description><![CDATA[一、静态拼接下拉框
效果

html
&lt;input id="channelCompanyName" name="channelCompanyName" class="easyui-combobox" data-options="" style="width:140px"/&gt;

JS
$(function(){
    	   autoChannelCompanyData("channe...]]></description><category></category></item><item><title><![CDATA[工具 —— excel导出页面数据到本地]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/89182061</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/89182061</guid><author>han_xiaoxue</author><pubDate>Wed, 10 Apr 2019 14:17:26 +0800</pubDate><description><![CDATA[工具 —— excel导出页面数据到本地Controller代码工具一：将制定数据拼成可导出格式工具二：拼excel 表头和数据1、表头和与之对应的字段名2、 拼excel表格——ExcelUtil.createWorkBook(list, 字段名, 列名);
Controller代码
数据可以前台页面传过来并且接收，在这里写死
public void exportExcal(HttpServle...]]></description><category></category></item><item><title><![CDATA[工具 —— JAVA.MyUtils]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88872953</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88872953</guid><author>han_xiaoxue</author><pubDate>Thu, 28 Mar 2019 16:59:43 +0800</pubDate><description><![CDATA[工具 —— JAVA.MyUtils一、正则1.1只能输入英文和中文1.2只能输入数字和英文二、日期时间2.1判断是否是合法的日期类型2.2将String类型日期，转成Date三、字符串3.1 判断字符串是否为空3.2 判断字符串是否包含、是否以...开始、以..介绍
一、正则
1.1只能输入英文和中文
public boolean isEngAndCn(String str){
    	boo...]]></description><category></category></item><item><title><![CDATA[IO —— java导入文件（上传）]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88823209</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88823209</guid><author>han_xiaoxue</author><pubDate>Tue, 26 Mar 2019 16:16:04 +0800</pubDate><description><![CDATA[业务背景
上传excel表格，后台接收并解析文件，遍历表格中的数据，并返回前台
一、导入文件JSP
&lt;div id="psgDiv" class="easyui-dialog" data-options="modal:true,closed:true" style="width:600px;height:320px"&gt;
			&lt;p style="margin-top: 20px;...]]></description><category></category></item><item><title><![CDATA[IO —— 下载模板java]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88822543</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88822543</guid><author>han_xiaoxue</author><pubDate>Tue, 26 Mar 2019 15:56:38 +0800</pubDate><description><![CDATA[IO —— 下载模板java一、业务前提二、文件存放位置三、JSP代码四、下载功能的JS代码五、下载功能的controller代码六 导入文件路径
一、业务前提
下载模板，然后填写一些乘机人信息，再上传，后台解析数据，返回给前端页面，将数据拼接到表格中。


二、文件存放位置

三、JSP代码
&lt;div id="psgDiv" class="easyui-dialog" data-optio...]]></description><category></category></item><item><title><![CDATA[dubbo —— 使用maven构建dubbo服务可执行jar包]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88397060</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/88397060</guid><author>han_xiaoxue</author><pubDate>Mon, 11 Mar 2019 16:31:59 +0800</pubDate><description><![CDATA[使用maven构建dubbo服务可执行jar包一、dubbo服务启动方式分析1、使用Servlet容器运行（Tomcat、Jetty等）----不可取2、自建Main方法运行（Spring容器） ----不建议（本地调试可用）3、Dubbo框架提供Main方法类运行（Spring容器）----推荐使用可实现优雅关机 dubbo.shutdown.hook二、修改spring-context.xml...]]></description><category></category></item><item><title><![CDATA[dubbo —— domain下载安装]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/87921126</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/87921126</guid><author>han_xiaoxue</author><pubDate>Mon, 25 Feb 2019 17:38:04 +0800</pubDate><description><![CDATA[dubbo domain下载安装版本及下载地址解压tomcat安装zookeper安装domain运行tomcat访问domain跑服务（生产者 消费者）
版本及下载地址
tomcat 7.0.85
zookeper 3.4.12
dubbo-domain 2.5.8
解压tomcat
eclipse 中有一个tomcat  再弄一个 方便测试

更改server.xml 中的端口号，以免启动的时...]]></description><category></category></item><item><title><![CDATA[第一个dubbo项目]]></title><link>https://blog.youkuaiyun.com/han_xiaoxue/article/details/87281795</link><guid>https://blog.youkuaiyun.com/han_xiaoxue/article/details/87281795</guid><author>han_xiaoxue</author><pubDate>Thu, 14 Feb 2019 16:42:10 +0800</pubDate><description><![CDATA[第一个dubbo项目创建四个项目消费者项目dubbo-consumer.xml生产者项目dubbo-provider.xmlDubboProvider运行
创建四个项目
下载项目地址：

消费者项目

dubbo-consumer.xml

生产者项目

dubbo-provider.xml

DubboProvider
public class DubboProvider {
	
	privat...]]></description><category></category></item></channel></rss>