<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[JavaCoderWolf的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/JavaCoderWolf</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; JavaCoderWolf]]></copyright><item><title><![CDATA[MySQL数据去重]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/121559991</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/121559991</guid><author>JavaCoderWolf</author><pubDate>Fri, 26 Nov 2021 15:18:17 +0800</pubDate><description><![CDATA[删除重复数据
一次删除一批重复数据，需要多次执行
DELETE FROM TABLE_NAME 
WHERE ID IN(
	(
		SELECT MIN(ID) 
		FROM TABLE_NAME 
		GROUP BY COLUMNA,COLUMNB
		HAVING COUNT(1)&gt; 1
	)TEMPA 
)

REPLACE 插入新行之前删除旧行

https://dev.mysql.com/doc/refman/5.7/en/replace.html

REPLACE [LOW_PRIO]]></description><category></category></item><item><title><![CDATA[多线程与高并发(持续更新中)]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/112726263</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/112726263</guid><author>JavaCoderWolf</author><pubDate>Fri, 22 Jan 2021 09:43:24 +0800</pubDate><description><![CDATA[文章目录基础概念JUC同步工具线程池标题
基础概念
JUC同步工具
线程池
标题

]]></description><category></category></item><item><title><![CDATA[Redis 5]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/112309313</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/112309313</guid><author>JavaCoderWolf</author><pubDate>Mon, 11 Jan 2021 09:27:17 +0800</pubDate><description><![CDATA[Redis 5安装卸载集群搭建
安装
卸载
集群搭建

]]></description><category></category></item><item><title><![CDATA[Hadoop 学习笔记]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/108359938</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/108359938</guid><author>JavaCoderWolf</author><pubDate>Mon, 11 Jan 2021 09:26:51 +0800</pubDate><description><![CDATA[Hadoop 学习笔记存储模型架构设计
存储模型

文件线性按字节切割成块(BLOCK)，具有offset ，id
文件与文件的block大小可以不一样
一个文件除最后一个block，其他block大小一致
block的大小依据硬件的I/O特性调整
block被分散存放在集群的节点中，具有location
block具有副本（replication），没有主从概念，副本不能出现在同一个节点
副本是满足可靠性和性能的关键
文件上传可以指定block大小和副本数，上传后只能修改副本数
一次写入多次读取，不支持修]]></description><category></category></item><item><title><![CDATA[Linux 学习笔记]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/109330563</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/109330563</guid><author>JavaCoderWolf</author><pubDate>Mon, 11 Jan 2021 09:26:24 +0800</pubDate><description><![CDATA[1. Linux 用户管理
1.1 Linux 用户和用户组
1.1.1 用户分为普通用户、根用户、系统用户。

普通用户UID &gt; 500
根用户UID = 0
系统用户UID 1~499

1.1.2 确认自己的UID
id 

1.1.3 确认自己所属的用户组(GID)
groups

1.1.4 查询当前登录的所有用户
who

1.2 账号管理
涉及账号的添加、删除、修改等。
1.2.1 新增和删除用户：useradd 用户名

新增用户

useradd wolf


指定创建用户的UID]]></description><category></category></item><item><title><![CDATA[window 常用命令]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/112215771</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/112215771</guid><author>JavaCoderWolf</author><pubDate>Tue, 05 Jan 2021 10:27:49 +0800</pubDate><description><![CDATA[测试端口

telnet IP PORT


清除cmd

cls


]]></description><category></category></item><item><title><![CDATA[MYSQL数据库LOAD CSV数据]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/111288670</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/111288670</guid><author>JavaCoderWolf</author><pubDate>Wed, 16 Dec 2020 16:55:51 +0800</pubDate><description><![CDATA[LOAD DATA LOCAL INFILE '文件路径'  INTO TABLE tableName FIELDS TERMINATED BY ',';

注意问题:

分隔符不能是内容里边出现的符号，否则数据导入会错误
最后一个字段导入后会被加入换行符，如果是业务需要字段，要做处理


...]]></description><category></category></item><item><title><![CDATA[Centos]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/109741025</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/109741025</guid><author>JavaCoderWolf</author><pubDate>Tue, 17 Nov 2020 13:58:15 +0800</pubDate><description><![CDATA[查看文件类型

file 123.txt


查看命令类型

type cd


当前bashshell 进程号

echo $$


查看所有进程及进程号

ps -ef


彻底杀死一个进程

kill -9 pid


]]></description><category></category></item><item><title><![CDATA[html转excel 避免 字符串在excel中自动转成数字]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/105638854</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/105638854</guid><author>JavaCoderWolf</author><pubDate>Mon, 20 Apr 2020 16:47:49 +0800</pubDate><description><![CDATA[html转excel 避免 字符串在excel中自动转成数字
style 添加
vnd.ms-excel.numberformat:@


]]></description><category></category></item><item><title><![CDATA[Maven仓库安装本地jar]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/103778563</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/103778563</guid><author>JavaCoderWolf</author><pubDate>Tue, 31 Dec 2019 10:29:20 +0800</pubDate><description><![CDATA[Maven仓库安装本地jar
mvn install:install-file -Dfile=D:/pageoffice4.5.0.10.jar -DgroupId=com.zhuozhengsoft -DartifactId=pageoffice -Dversion=4.5.0.10 -Dpackaging=jar


]]></description><category></category></item><item><title><![CDATA[不支持background-size的IE浏览器背景自适应问题]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/102490811</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/102490811</guid><author>JavaCoderWolf</author><pubDate>Thu, 10 Oct 2019 21:03:57 +0800</pubDate><description><![CDATA[样式中添加
filter:progid:DXImageTransform.Microsoft.AlphaImageLoader(src='1.jpg',sizingMethod='scale');

.selected{
    background:url("image/rbbg6.gif") no-repeat center;
    background-size:100% 100%;
  ...]]></description><category></category></item><item><title><![CDATA[ORACLE MERGE INTO DELETE]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/99546078</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/99546078</guid><author>JavaCoderWolf</author><pubDate>Wed, 14 Aug 2019 10:38:39 +0800</pubDate><description><![CDATA[ORACLE MERGE INTO DELETE

注意源表和目标表数据都要唯一

merge into PERSONCERTIFICATEBAK b
using (select ids from person_cer_dele ) u
on (b.id = u.ids)
when matched then 
update set b.personguid = b.personguid
delet...]]></description><category></category></item><item><title><![CDATA[TOMCAT 8.5.3 控制台乱码问题]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/93174507</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/93174507</guid><author>JavaCoderWolf</author><pubDate>Fri, 21 Jun 2019 11:18:12 +0800</pubDate><description><![CDATA[TOMCAT 8.5.3 控制台乱码问题

找到 {tomcat}/conf/logging.properties 文件
修改  java.util.logging.ConsoleHandler.encoding = UTF-8

]]></description><category></category></item><item><title><![CDATA[oracle sql语句索引使用情况 查询]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/90287433</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/90287433</guid><author>JavaCoderWolf</author><pubDate>Fri, 17 May 2019 09:52:20 +0800</pubDate><description><![CDATA[生成执行计划
explain plan for select * from xxxx where xxx = xxx;
查看索引使用明细
select * from table(dbms_xplan.display);


]]></description><category></category></item><item><title><![CDATA[Tomcat安全配置]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80584324</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80584324</guid><author>JavaCoderWolf</author><pubDate>Tue, 05 Jun 2018 21:31:11 +0800</pubDate><description><![CDATA[1. 关闭8005端口


文件位置：tomcat目录/conf/server.xml
原配置 

改为 

避免通过telnet ip 8005 SHUTDOWN 命令关闭Tomcat


2. 关闭自动部署


原配置 

改为 

防止文件篡改后启动


3.删除Tomcat管理页面


Tomcat目录/webapps
删除该目录下所有文件，避免
...]]></description><category></category></item><item><title><![CDATA[JQuery 获取单选按钮值]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80488384</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80488384</guid><author>JavaCoderWolf</author><pubDate>Mon, 28 May 2018 20:44:03 +0800</pubDate><description><![CDATA[
var val = $(‘input[name=”myAnswer”]:checked ‘).val();
]]></description><category></category></item><item><title><![CDATA[EasyUI DataGrid 自动换行]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80429484</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80429484</guid><author>JavaCoderWolf</author><pubDate>Thu, 24 May 2018 09:07:12 +0800</pubDate><description><![CDATA[&amp;lt;table id=&quot;dg&quot;&amp;gt;&amp;lt;/table&amp;gt; 
&amp;lt;script&amp;gt;
$('#dg').datagrid({
    nowrap:false
});
&amp;lt;/script&amp;gt;



官网地址

easyui datagrid 
nowrap:True to display data in one line. Set to true can improve ...]]></description><category></category></item><item><title><![CDATA[修改input背景色]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80270080</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80270080</guid><author>JavaCoderWolf</author><pubDate>Thu, 10 May 2018 16:39:13 +0800</pubDate><description><![CDATA[document.getElementById(&amp;amp;quot;xxx&amp;amp;quot;).css(&amp;amp;quot;background&amp;amp;quot;,&amp;amp;quot;red&amp;amp;quot;);]]></description><category></category></item><item><title><![CDATA[Tomcat 项目部署及配置]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80177833</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80177833</guid><author>JavaCoderWolf</author><pubDate>Thu, 03 May 2018 11:48:30 +0800</pubDate><description><![CDATA[配置管理用户


tomcat安装目录→conf  →tomcat-users.xml


&amp;lt;?xml version='1.0' encoding='utf-8'?&amp;gt;
&amp;lt;!--
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements...]]></description><category></category></item><item><title><![CDATA[MyEclise 常用快捷键]]></title><link>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80075405</link><guid>https://blog.youkuaiyun.com/JavaCoderWolf/article/details/80075405</guid><author>JavaCoderWolf</author><pubDate>Wed, 25 Apr 2018 10:23:08 +0800</pubDate><description><![CDATA[
撤销 Ctrl + Z
全文搜索 Ctrl + H
代码提示 Alt + /
重做 Ctrl + Y（可以对撤销还原）
向下复制当前行 Ctrl + Alt +  ↓
向上复制当前行 Ctrl + Alt +  ↑
当前行往上移一行 Alt + ↑
当前行往下移一行 Alt + ↓
删除 Ctrl + D
查询/替换 Ctrl + F
小写替换大写 Ctrl + Shift + X
大写替换小写...]]></description><category></category></item></channel></rss>