<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[书之岁华]]></title><description><![CDATA[书读就，之为后，岁须臾，华横溢。]]></description><link>https://blog.youkuaiyun.com/yeyiting</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; yeyiting]]></copyright><item><title><![CDATA[FTP之FileZilla Server]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/129203608</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/129203608</guid><author>yeyiting</author><pubDate>Fri, 24 Feb 2023 17:17:50 +0800</pubDate><description><![CDATA[FTP服务部署]]></description><category></category></item><item><title><![CDATA[Mysql常用命令]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/107605971</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/107605971</guid><author>yeyiting</author><pubDate>Mon, 27 Jul 2020 14:13:40 +0800</pubDate><description><![CDATA[1、启动/停止 Mysql服务

net stop mysql
net start mysql


2、CMD 登录 Mysql

mysql -u用户名 -p用户密码
如：mysql -uroot -p123456


3、新建数据库

create database db;


3、用户增删改查

（1）查看所有用户：
	select * from mysql.user;
	
（2）创建用户：
指定ip：172.21.33.1的yyt用户登录
	create user 'yyt'@'172.21.33.]]></description><category></category></item><item><title><![CDATA[捕捉异常时getMessage()为null：NullPointerException]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/106200164</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/106200164</guid><author>yeyiting</author><pubDate>Tue, 19 May 2020 09:20:57 +0800</pubDate><description><![CDATA[场景：try…catch…模块中抛出NullPointerException，而e.getMessage()为null。
e.printStackTrace()或者logger.error(“msg”, e)把异常的信息打印出来。

]]></description><category></category></item><item><title><![CDATA[数据库表空间扩展处理]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/106120050</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/106120050</guid><author>yeyiting</author><pubDate>Fri, 15 May 2020 11:03:25 +0800</pubDate><description><![CDATA[一、Oracle
--查看表空间使用情况
SELECT a.tablespace_name "表空间名称", 
round(total/(1024*1024*1024),2) "表空间总量(G)", 
round(free/(1024*1024*1024),2) "表空间剩余(G)", 
round((total-free)/(1024*1024*1024),2) "表空间使用(G)", 
round((total-free)/total,4)*100 "使用率%" 
FROM (SELECT tables]]></description><category></category></item><item><title><![CDATA[计算数据库表单条记录所占空间大小]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/105652333</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/105652333</guid><author>yeyiting</author><pubDate>Wed, 13 May 2020 16:45:43 +0800</pubDate><description><![CDATA[bit &gt;&gt;8&gt;&gt; Bytes &gt;&gt;1024&gt;&gt; KB &gt;&gt;1024&gt;&gt; MB &gt;&gt;1024&gt;&gt; GB &gt;&gt;1024&gt;&gt; TB

一、Oracle
英文字符占：1Bytes		中文字符、符号：2Bytes		1 CHAR：1 Bytes


普通记录

select vsize(...]]></description><category></category></item><item><title><![CDATA[数据库大数据量表SQL语句执行耗时久]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/105854611</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/105854611</guid><author>yeyiting</author><pubDate>Wed, 13 May 2020 10:24:44 +0800</pubDate><description><![CDATA[发时达

]]></description><category></category></item><item><title><![CDATA[Log日志定期备份（Windows定时任务）]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/104607193</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/104607193</guid><author>yeyiting</author><pubDate>Tue, 12 May 2020 19:14:07 +0800</pubDate><description><![CDATA[一、系统定时任务

屏幕左下角右键 》计算机管理 》任务计划程序 》任务计划


]]></description><category></category></item><item><title><![CDATA[echarts折线图“有点无线”问题]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/102696345</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/102696345</guid><author>yeyiting</author><pubDate>Wed, 04 Dec 2019 14:32:30 +0800</pubDate><description><![CDATA[几天用echarts做图表，之前采用的是hightchart做，发现hightchart有的插件没有，相反echarts有。为了统一，我就选择了采用echart来实现，这样我的导出图片这块就同统一了，后面发现出来的结果，折线图中只有点没有线。为何会出现这个问题？
     经过查资料发现，原来echarts中采用h5画布，存在动画，会延迟加载，所以通过getDataURL()获取的图片，因为动画原...]]></description><category></category></item><item><title><![CDATA[服务器宕机维护——机房停电篇]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/103197211</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/103197211</guid><author>yeyiting</author><pubDate>Wed, 27 Nov 2019 09:34:56 +0800</pubDate><description><![CDATA[服务器宕机后确保事件：


1. 开机正常
2. 数据库、tomcat、其他服务正常启动
3. 防火墙开放服务端口
4. 接口正常访问
5. 网站正常登录

一、Linux服务器

1.开机正常（不幸中的万幸）



2.数据库、tomcat、其他服务正常启动


2.1. 启动数据库服务
（1）su - oracle  使用oracle用户登录Linux
（2）lsnrctl status  ...]]></description><category></category></item><item><title><![CDATA[List遍历Map中values加减乘除]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/102892609</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/102892609</guid><author>yeyiting</author><pubDate>Mon, 04 Nov 2019 10:47:30 +0800</pubDate><description><![CDATA[将Object对象toString()再转化成想要的类型最后加减乘除操作一波

List&lt;Map&lt;String, Object&gt;&gt; list...
for (Map&lt;String, Object&gt; map : list) {
	JYJG = Integer.parseInt(map.get("JYJG").toString())+JYJG;
	...
}
Ma...]]></description><category></category></item><item><title><![CDATA[Sql  行转列]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/102620161</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/102620161</guid><author>yeyiting</author><pubDate>Fri, 18 Oct 2019 10:23:53 +0800</pubDate><description><![CDATA[1、未转换前
2、 行转列函数：UNPIVOT()
SELECT * FROM (select std0, std1,std2,std3,std4,std5,std6,std9 from table t) 
UNPIVOT("value" FOR "name" IN(std0 as '哈哈1',std1 as '哈哈2',std2 as '哈哈3',std3 as '哈哈4',std4 as '哈...]]></description><category></category></item><item><title><![CDATA[XML文件首行出现红叉，却不影响项目运行]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/102389062</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/102389062</guid><author>yeyiting</author><pubDate>Tue, 08 Oct 2019 15:49:26 +0800</pubDate><description><![CDATA[1、问题：XML文件首行出现红叉，却不影响项目运行，但看着很不爽！
2、查看问题描述

Referenced file contains errors (http://www.springframework.org/schema/aop/spring-aop.xsd).  For more information, right click on the message in the Problem...]]></description><category></category></item><item><title><![CDATA[修改JAVA WEB项目名称]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/98595273</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/98595273</guid><author>yeyiting</author><pubDate>Tue, 06 Aug 2019 11:39:02 +0800</pubDate><description><![CDATA[步骤一：Eclipse修改项目名称

1、修改项目名称：项目重命名，项目右键Rename


2、项目右键 》Properties选项 》Web Project Settings 选项 》修改 Context root


3、修改项目名称：修改服务器（Tomcat）运行项目，项目URL中的项目名称


...]]></description><category></category></item><item><title><![CDATA[Eclipse导入Maven项目]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/91381458</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/91381458</guid><author>yeyiting</author><pubDate>Mon, 10 Jun 2019 16:02:05 +0800</pubDate><description><![CDATA[1、File 》Import 》Maven 》Existing Maven Projects ；
2、找到需要导入的Maven项目；
3、点击Finish即可。
注意1：如果导入后发现项目结构不对，按以下逐个排除。

1、展示窗体不对

项目 》右击 》 Show In 》 Project Explorer

如果没有“Project Explorer”，说明现在正处于“Project Explo...]]></description><category></category></item><item><title><![CDATA[联想笔记本——进入PE系统]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/89921598</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/89921598</guid><author>yeyiting</author><pubDate>Tue, 07 May 2019 15:13:17 +0800</pubDate><description><![CDATA[1、F2：进入BIOS设置界面，Boot选项下Boot Mode系统默认是UEFI，修改为Legacy Support(传统支持)
2、F12：进入Boot Menu，选择USB HDD选项，回车即可进入PE系统。

]]></description><category></category></item><item><title><![CDATA[win10无法登录Microsoft账号（登录页面无法加载）]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/89435745</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/89435745</guid><author>yeyiting</author><pubDate>Sun, 21 Apr 2019 17:18:54 +0800</pubDate><description><![CDATA[原因：网络问题，连接不上Microsoft服务器
解决：IPv4配置DNS服务器地址（111.230.23.23）

]]></description><category></category></item><item><title><![CDATA[JSP_输入框字符校验]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/87799734</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/87799734</guid><author>yeyiting</author><pubDate>Wed, 20 Feb 2019 15:25:45 +0800</pubDate><description><![CDATA[&amp;lt;input onKeyUp=&quot;verify(this)&quot; class=&quot;form-control&quot; type=&quot;text&quot;&amp;gt;

function verify(t){
   var num = t.value;
   
   var re=/[=\\| ·！￥……（）——【】、；’‘：“”《》，。？`~!@#$%^&amp;amp;*()+&amp;lt;&amp;gt;?&quot;{}\/;'[\]]/i]]></description><category></category></item><item><title><![CDATA[Linux_网络下载 wget: unable to resolve host address问题]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/87783336</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/87783336</guid><author>yeyiting</author><pubDate>Wed, 20 Feb 2019 11:18:15 +0800</pubDate><description><![CDATA[wget：无法解析主机地址。DNS解析的问题。

解决：
以root身份进入/etc/resolv.conf。
修改内容为下
nameserver 8.8.8.8 #google域名服务器
nameserver 8.8.4.4 #google域名服务器


...]]></description><category></category></item><item><title><![CDATA[React随记]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/87609539</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/87609539</guid><author>yeyiting</author><pubDate>Mon, 18 Feb 2019 11:59:08 +0800</pubDate><description><![CDATA[
React是Facebook开源的一款JavaScript库，只专注于MVC框架中的V，即视图。

一、React和其他一些JS框架的比较

1.不是MVC框架，只专注于view层。
2.单向数据绑定，单向的从数据到视图的渲染。
3.不直接操作DOM对象，而是通过虚拟DOM通过diff算法以最小的步骤作用到真实的DOM上。

在使用react.js之前要先搭建nodeJs，因为要引用其中大量的库...]]></description><category></category></item><item><title><![CDATA[JQuery AJAX方法]]></title><link>https://blog.youkuaiyun.com/yeyiting/article/details/87066436</link><guid>https://blog.youkuaiyun.com/yeyiting/article/details/87066436</guid><author>yeyiting</author><pubDate>Tue, 12 Feb 2019 09:00:23 +0800</pubDate><description><![CDATA[JQuery

]]></description><category></category></item></channel></rss>