<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[JoeFive的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/joefive</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; joefive]]></copyright><item><title><![CDATA[VMtools安装办法解决本地与虚机拷贝]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/142785550</link><guid>https://blog.youkuaiyun.com/joefive/article/details/142785550</guid><author>joefive</author><pubDate>Wed, 09 Oct 2024 14:13:31 +0800</pubDate><description><![CDATA[二、等待虚拟机开启，点开运行(Win+R)输入D:/setup.exe。前提正常引用虚拟机光盘介质，保证光驱位置处于D盘，下一步进行安装完成。一、打开虚拟机选项-重新安装VMware Tools。]]></description><category></category></item><item><title><![CDATA[字段去重的两种办法]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/141896496</link><guid>https://blog.youkuaiyun.com/joefive/article/details/141896496</guid><author>joefive</author><pubDate>Wed, 04 Sep 2024 16:07:56 +0800</pubDate><description><![CDATA[1.根据ROWID保留1条数据。2.根据日期保留最新1条数据。]]></description><category></category></item><item><title><![CDATA[Docker下安装OpenProject]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/119409550</link><guid>https://blog.youkuaiyun.com/joefive/article/details/119409550</guid><author>joefive</author><pubDate>Thu, 05 Aug 2021 14:28:46 +0800</pubDate><description><![CDATA[1.下载openproject对应镜像


docker pull  openproject/community:8

2.启动对应服务并挂起


docker run -it -p 8080:80 -e SECRET_KEY_BASE=secret openproject/community:8

使用ctrl+q+p挂起后台

3.
]]></description><category></category></item><item><title><![CDATA[SpringBoot问题总结]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/117482998</link><guid>https://blog.youkuaiyun.com/joefive/article/details/117482998</guid><author>joefive</author><pubDate>Wed, 02 Jun 2021 20:52:14 +0800</pubDate><description><![CDATA[使用JSR303校验@Validated

校验电子邮箱@Email()无效问题

新版需要再pom.xml中增加依赖




]]></description><category></category></item><item><title><![CDATA[Centos安装Docker]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/116130790</link><guid>https://blog.youkuaiyun.com/joefive/article/details/116130790</guid><author>joefive</author><pubDate>Sun, 25 Apr 2021 16:30:46 +0800</pubDate><description><![CDATA[1.配置本地yum


#配置阿里云镜像源
wget -O /etc/yum.repos.d/CentOS-Base.repo http://mirrors.aliyun.com/repo/Centos-7.repo
wget -O /etc/yum.repos.d/epel.repo http://mirrors.aliyun.com/repo/epel-7.repo
yum clean all

2.卸载本地已安装Docker


yum remove docker

3.安装所需依赖


#安装所需.]]></description><category></category></item><item><title><![CDATA[Mybatis遇到几个问题]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/115741657</link><guid>https://blog.youkuaiyun.com/joefive/article/details/115741657</guid><author>joefive</author><pubDate>Thu, 15 Apr 2021 22:21:46 +0800</pubDate><description><![CDATA[Mybatis遇到几个问题：

1.在配置文件可能包含有中文注释，导致在编译后中文注释在配置文件乱码抛异常，使用Maven构建需要在pom文件中增加配置；


&lt;!--无法识别properties或者xml文件--&gt;    
&lt;build&gt;
        &lt;resources&gt;
            &lt;resource&gt;
                &lt;directory&gt;src/main/java&lt;/directory&gt;
   ]]></description><category></category></item><item><title><![CDATA[MYSQL常用操作命令]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/107414033</link><guid>https://blog.youkuaiyun.com/joefive/article/details/107414033</guid><author>joefive</author><pubDate>Fri, 17 Jul 2020 17:46:19 +0800</pubDate><description><![CDATA[常用mysql安装命令：

1.解压创建完配置文件BIN目录下初始化：(记录初始化密码)


mysqld --initialize --console

2.安装mysql服务


mysqld --install mysql

3.启动mysql服务


net start mysql

4.登陆数据库


mysql -u root -p 输入默认密码

5.修改root密码


set password=password('newpassword');
#mysql8版本以上修改密码
alte...]]></description><category></category></item><item><title><![CDATA[数据库三大范式与事务的四大特征]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/107361840</link><guid>https://blog.youkuaiyun.com/joefive/article/details/107361840</guid><author>joefive</author><pubDate>Wed, 15 Jul 2020 16:26:22 +0800</pubDate><description><![CDATA[数据库三大范式：

1.第一范式：每一列都是不可分割的原子性数据项，不能是集合、数组非原子数据项；如果一个列中存在多个值，需要将改了拆分成不同的列；第一范式就是每一列保证不可拆分，保证原子性；

  ID
			  NAME
			  AGE
		  001
			  张三
			   30
		  002
			  李四
			   35
		2.第二范式：在满足数据库第一范式的前提下，所有数据必须要完全依赖于主键；
...]]></description><category></category></item><item><title><![CDATA[MYSQL中相关约束]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/107333593</link><guid>https://blog.youkuaiyun.com/joefive/article/details/107333593</guid><author>joefive</author><pubDate>Tue, 14 Jul 2020 14:50:51 +0800</pubDate><description><![CDATA[1.非空约束(NOT NULL)


--测试用表
CREATE TABLE STUDENT (
	ID INT,
	NAME VARCHAR (40),
	AGE INT,
	SCORE INT,
	MOBILE VARCHAR(20),
	BIRTHDAY DATE,
	EXCHANGE_TIME TIMESTAMP
);

增加、删除非空约束：


--增加非空约束
ALTER TABLE STUDENT MODIFY SCORE INT NOT NULL;
--删除非空约束
ALTER TABLE ]]></description><category></category></item><item><title><![CDATA[HashSet中hashCode方法]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/106120259</link><guid>https://blog.youkuaiyun.com/joefive/article/details/106120259</guid><author>joefive</author><pubDate>Thu, 14 May 2020 16:25:52 +0800</pubDate><description><![CDATA[HashSet实现了Set接口，是无序集合没有索引，无重复元素；

hashCode()方法是十进制整数，系统模拟出的逻辑地址值，不是对象的物理地址值；

整型返回的hashCode值根据源码：


Integer num = 123;
System.out.println(num.hashCode()); //123


public static int hashCode(int value) { 
    return value;
}

布尔值返回的hashCode值根据源码：


Boolean ]]></description><category></category></item><item><title><![CDATA[GitHub中配置SSHkey]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/106016761</link><guid>https://blog.youkuaiyun.com/joefive/article/details/106016761</guid><author>joefive</author><pubDate>Sat, 09 May 2020 13:19:57 +0800</pubDate><description><![CDATA[在GitHub中配置SSHkey来验证登录远程仓储

首先登陆GitHub账号在Settings-SSH and GPG keys创建



点击New SSH key，后需要填写title跟key；title手动填写，key需要使用git-bash中获取；

进入git-bash，输入命令，连续3次回车


$ ssh-keygen -t rsa -b 4096 -C "你的邮箱名称"



Generating public/private rsa key pair.
Enter file ...]]></description><category></category></item><item><title><![CDATA[Java数据类型]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/105431080</link><guid>https://blog.youkuaiyun.com/joefive/article/details/105431080</guid><author>joefive</author><pubDate>Fri, 10 Apr 2020 13:07:49 +0800</pubDate><description><![CDATA[Java中数据类型分分为基本类型、引用类型两种。其中基本类型又分为四类八种，以下列图标进行说明：

类型
			名称
			取值范围
			二进制位数
			备注
		基本类型
			整数型
			byte
			-128至127
			8
			byte类型占用的空间只有int类型的1/4
		short
			-32768至32767
			16
			一个short变量是int型变量所...]]></description><category></category></item><item><title><![CDATA[同时安装两个版本MYSQL数据库]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/105051030</link><guid>https://blog.youkuaiyun.com/joefive/article/details/105051030</guid><author>joefive</author><pubDate>Mon, 23 Mar 2020 16:40:17 +0800</pubDate><description><![CDATA[本地已经安装过mysql5.1版本，应项目需求需要安装mysql5.7版本；

官方网站下载对应版本：https://downloads.mysql.com/archives/community/



压缩包下载完成后解压至本地磁盘，使用CMD命令行进入根目录下bin文件夹，进行初始化：


D:\mysql-5.7.28\bin&gt;mysqld --initialize --console...]]></description><category></category></item><item><title><![CDATA[ORACLE中多条数据合并某个字段]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/104963739</link><guid>https://blog.youkuaiyun.com/joefive/article/details/104963739</guid><author>joefive</author><pubDate>Thu, 19 Mar 2020 11:43:13 +0800</pubDate><description><![CDATA[假设需要合并EMP表中相同JOB人员的ENAME与MGR字段；


SELECT E.JOB,E.ENAME,E.MGR FROM EMP E;



1.可以使用WM_CONCAT函数来实现：


SELECT E.JOB,WMSYS.WM_CONCAT(E.ENAME),WMSYS.WM_CONCAT(E.MGR) FROM EMP E GROUP BY E.JOB;



2.也可以使用LI...]]></description><category></category></item><item><title><![CDATA[离线机器安装Python3.6对应包]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/104427929</link><guid>https://blog.youkuaiyun.com/joefive/article/details/104427929</guid><author>joefive</author><pubDate>Fri, 21 Feb 2020 15:08:47 +0800</pubDate><description><![CDATA[在线机器下载对应所需包


pip install jinjia2
pip install pymysql
pip install jsonify

在线机器可以查看本地安装完成包并打包至packages文件夹中


#查询本地安装
pip list
Jinja2 (2.11.1)
PyMySQL (0.9.3)
jsonify (0.5)

#生成安装包列表
pip freeze &gt;req...]]></description><category></category></item><item><title><![CDATA[ORACLE查询过滤条件中不等于会过滤掉NULL]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/102815050</link><guid>https://blog.youkuaiyun.com/joefive/article/details/102815050</guid><author>joefive</author><pubDate>Wed, 30 Oct 2019 11:07:24 +0800</pubDate><description><![CDATA[TESTA表需要根据C字段(VARCHAR2)进行过滤选取C字段不等于1的数据；


SELECT * FROM TESTA;



使用以下SQL语句查询得过滤掉为空数据。


SELECT * FROM TESTA T WHERE T.C &lt;&gt; '1';



但是过滤掉了C字段中值为NULL的数据。

采用以下两种办法进行查询。


SELECT * FROM TESTA T W...]]></description><category></category></item><item><title><![CDATA[WINSERVER2012安装ORACLE12C遇到问题]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/101756575</link><guid>https://blog.youkuaiyun.com/joefive/article/details/101756575</guid><author>joefive</author><pubDate>Mon, 30 Sep 2019 10:47:45 +0800</pubDate><description><![CDATA[近期在WINSERVER2012虚机上安装12C，安装第二步环境校验出现错误：[INS-30131]执行安装程序验证所需的初始设置失败（原因：无法访问临时位置），按照报错提示信息服务器需要创建共享位置，共享位置创建完成后仍然报改错误。经查询按以下办法解决：

针对客户端安装，在cmd中执行命令；


setup.exe -ignorePrereq -J"-Doracle.install.clien...]]></description><category></category></item><item><title><![CDATA[使用VNC远程访问LINUX桌面]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/90695985</link><guid>https://blog.youkuaiyun.com/joefive/article/details/90695985</guid><author>joefive</author><pubDate>Thu, 30 May 2019 14:37:15 +0800</pubDate><description><![CDATA[登陆linux服务器首先查看vncserver相关依赖包


[root@localhost data]# rpm -qa|grep vnc
tigervnc-server-1.1.0-8.0.2.AXS4.x86_64
gtk-vnc-0.3.10-3.AXS4.x86_64
tigervnc-1.1.0-8.0.2.AXS4.x86_64
libvncserver-0.9.7-4.AXS4.x...]]></description><category></category></item><item><title><![CDATA[SCP提示CONNECTION CLOSED BY HOST(IP)]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/88783974</link><guid>https://blog.youkuaiyun.com/joefive/article/details/88783974</guid><author>joefive</author><pubDate>Sun, 24 Mar 2019 22:58:33 +0800</pubDate><description><![CDATA[两台linux服务器传输文件遇到如下问题：


scp /opt/data/xxx.logroot@172.1.1.1:/opt/databak/


root@172.1.1.1's password:
Connection closed by 172.1.1.1
lost connection

经检查防火墙已关闭，修改/etc/hosts.allow文件解决该问题：

在/etc/hos...]]></description><category></category></item><item><title><![CDATA[ECLIPSE下TOMCAT启动报错PermGen space（永久区内存溢出）]]></title><link>https://blog.youkuaiyun.com/joefive/article/details/86711829</link><guid>https://blog.youkuaiyun.com/joefive/article/details/86711829</guid><author>joefive</author><pubDate>Thu, 31 Jan 2019 10:43:13 +0800</pubDate><description><![CDATA[使用TOMCAT启动WEB工程报错：java.lang.OutOfmemoryError:PermGen Space，TOMCAT配置界面中增加参数：-Xms256m -Xmx512m -XX:PermSize=256m -XX:MaxPermSize=512m

]]></description><category></category></item></channel></rss>