<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[springlan的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/springlan</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; springlan]]></copyright><item><title><![CDATA[查看oracle数据库锁表并解锁]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/116752997</link><guid>https://blog.youkuaiyun.com/springlan/article/details/116752997</guid><author>springlan</author><pubDate>Thu, 13 May 2021 15:45:19 +0800</pubDate><description><![CDATA[SELECT SESS.SID,  SESS.SERIAL#,  LO.ORACLE_USERNAME,  LO.OS_USER_NAME,  AO.OBJECT_NAME 被锁对象名, LO.LOCKED_MODE 锁模式, sess.LOGON_TIME 登录数据库时间,
'ALTER SYSTEM KILL SESSION ''' || SESS.SID || ','||SESS.SERIAL#||'''' FREESQL
FROM V$LOCKED_OBJECT LO,  DBA_OBJECTS .]]></description><category></category></item><item><title><![CDATA[查看某个数据库所有用户已使用的表空间大小情况]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/116491010</link><guid>https://blog.youkuaiyun.com/springlan/article/details/116491010</guid><author>springlan</author><pubDate>Fri, 07 May 2021 13:49:50 +0800</pubDate><description><![CDATA[select sum(GB),owner from (select segment_name,bytes/1024/1024/1024 as GB,owner from dba_segments  order by bytes desc ) group by owner order by sum(GB) desc



]]></description><category></category></item><item><title><![CDATA[eclipse中启动maven项目控制台乱码处理方式]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/114953419</link><guid>https://blog.youkuaiyun.com/springlan/article/details/114953419</guid><author>springlan</author><pubDate>Wed, 17 Mar 2021 22:31:15 +0800</pubDate><description><![CDATA[1.点击run-&gt;run configurations



2.选择你的maven项目，选择common，将encoding中的编码修改为utf-8即可


]]></description><category></category></item><item><title><![CDATA[linux中配置定时压缩文件以及删除文件并配置定时器]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/114385203</link><guid>https://blog.youkuaiyun.com/springlan/article/details/114385203</guid><author>springlan</author><pubDate>Fri, 05 Mar 2021 10:36:31 +0800</pubDate><description><![CDATA[1.编写定时脚本


#!/bin/bash
function zipLogFun(){
	cd "$homePath$tomcatPath"
	echo "进入$homePath$tomcatPath"
	if [ ! -d $zipLog ];
	        then
			echo "创建压缩文件夹"
        	        mkdir $zipLog
	else
        	echo $zipLog exist
	fi
#echo '将前天的各日期文件夹打包、压缩到指定文件夹下.]]></description><category></category></item><item><title><![CDATA[Centos 虚拟机中 无法使用jmap命令 报错“-bash: jmap: command not found”]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/113991647</link><guid>https://blog.youkuaiyun.com/springlan/article/details/113991647</guid><author>springlan</author><pubDate>Tue, 23 Feb 2021 15:31:55 +0800</pubDate><description><![CDATA[1.执行yum -y whatprovides '*/jmap'，查看可以使用的版本



2.选择其中一个，这里我选择java-1.8.0-openjdk-devel-1.8.0.282.b08-1.el7_9.x86_64，执行命令yum install -y java-1.8.0-openjdk-devel-1.8.0.282.b08-1.el7_9.x86_64，安装成功(使用root用户安装)：

1:java-11-openjdk-devel-11.0.8.10-1.el7.x86_64 : .]]></description><category></category></item><item><title><![CDATA[redis重启后出现最新的数据丢失的问题(windows系统)]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/113100393</link><guid>https://blog.youkuaiyun.com/springlan/article/details/113100393</guid><author>springlan</author><pubDate>Sun, 24 Jan 2021 23:53:45 +0800</pubDate><description><![CDATA[原因是默认的保存RDB的持久化方式，解决方式有一下两种：


关闭redis服务的时候手动触发RDB持久化，命令有两种：


save
该命令会阻塞当前Redis服务器，执行save命令期间，Redis不能处理其他命令，直到RDB过程完成为止。

显然该命令对于内存比较大的实例会造成长时间阻塞，这是致命的缺陷，为了解决此问题，Redis提供了第二种方式。

bgsave
执行该命令时，Redis会在后台异步进行快照操作，快照同时还可以响应客户端请求。具体操作是Redis进程执行fork操作创建子进程，RDB]]></description><category></category></item><item><title><![CDATA[oracle数据库恢复删除的表或者覆盖的表]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/112983407</link><guid>https://blog.youkuaiyun.com/springlan/article/details/112983407</guid><author>springlan</author><pubDate>Fri, 22 Jan 2021 14:04:49 +0800</pubDate><description><![CDATA[使用以下语句查询删除的表，根据节点恢复表

select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin where type='TABLE' order by droptime desc;

根据查询object_name恢复表，如果该表名已经存在，需要删除对应的表才能够恢复表

flashback table "BIN$uXeD0+B1K1LgVfz8/vRAFw==$0"]]></description><category></category></item><item><title><![CDATA[ORA-28040: 没有匹配的验证协议（12c或者12c rac）]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/107137011</link><guid>https://blog.youkuaiyun.com/springlan/article/details/107137011</guid><author>springlan</author><pubDate>Sun, 05 Jul 2020 11:59:09 +0800</pubDate><description><![CDATA[在oracle的安装目录下，D:\oracle\product\12.2.0\dbhome_1\network\admin，找到sqlnet.ora或者添加该文件，打开该文件并添加一下语句，不需要重启数据库


SQLNET.ALLOWED_LOGON_VERSION=8


]]></description><category></category></item><item><title><![CDATA[eclipse添加server插件]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/107117449</link><guid>https://blog.youkuaiyun.com/springlan/article/details/107117449</guid><author>springlan</author><pubDate>Sat, 04 Jul 2020 00:12:39 +0800</pubDate><description><![CDATA[1. 先查看eclipse的版本，打开eclipse-&gt;Help-&gt;About Eclipse IDE



2. 引入插件，打开Help-&gt;Install New Software，点击add





3.填入插件下载地址，http://download.eclipse.org/releases/2018-09，name随便填都可以，选择最后一个，点击next





4. 进去，点击next，勾选同意，点击Finish





5.等待右下角下载完依赖即可。


...]]></description><category></category></item><item><title><![CDATA[pl/sql中置顶table、views等以及设置默认显示My Objects]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/107030383</link><guid>https://blog.youkuaiyun.com/springlan/article/details/107030383</guid><author>springlan</author><pubDate>Mon, 29 Jun 2020 22:55:00 +0800</pubDate><description><![CDATA[1. 置顶table、views

打开configure-&gt;object browser folders



选择需要置顶的选项即可



2. 默认显示My Objects

打开configure-&gt;object browser filters



选择需要置顶的选项即可


]]></description><category></category></item><item><title><![CDATA[pl/sql设置记住密码]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/107030163</link><guid>https://blog.youkuaiyun.com/springlan/article/details/107030163</guid><author>springlan</author><pubDate>Mon, 29 Jun 2020 22:43:04 +0800</pubDate><description><![CDATA[打开pl/sql的configure-&gt;preferences


打开logon history-&gt;，勾选store history和store with password


在登陆页面选择记录的密码即可

]]></description><category></category></item><item><title><![CDATA[mysql和oracle中将一列数据显示为一个字符串]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/107018442</link><guid>https://blog.youkuaiyun.com/springlan/article/details/107018442</guid><author>springlan</author><pubDate>Mon, 29 Jun 2020 13:35:05 +0800</pubDate><description><![CDATA[mysql中使用group_concat
	
1. 例如，默认的连接符是，


select GROUP_CONCAT(id) as id from  t_student

2. 自定义连接符，使用;连接：


select GROUP_CONCAT(id SEPARATOR ';') as id from  t_student

3. 如果查询的字段值太长显示不全，是由于group_concat的group_concat_max_len参数的值太小造成的，默认查询如下



这条设置语句必须加在每...]]></description><category></category></item><item><title><![CDATA[没有安装oracle数据库的时候如何直接使用plsql连接数据库]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/106740720</link><guid>https://blog.youkuaiyun.com/springlan/article/details/106740720</guid><author>springlan</author><pubDate>Sun, 14 Jun 2020 00:23:21 +0800</pubDate><description><![CDATA[1.安装pl/sql

2.下载instantclient解压

2.1 在文件夹下找到oci.dll



2.2 不登陆sql/sql，直接进去



2.3 找到configure-&gt;preferences



2.4 找到connection



2.5 在oracle home中填入instantclient的解压路径，在ocl library中填入oci.dll的路径



2.6重启pl/sql即可。
...]]></description><category></category></item><item><title><![CDATA[数组的三个基本特点]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/104763772</link><guid>https://blog.youkuaiyun.com/springlan/article/details/104763772</guid><author>springlan</author><pubDate>Wed, 10 Jun 2020 22:33:39 +0800</pubDate><description><![CDATA[长度是声明数组对象的时候就确定的，数组一旦被创建，它的大小就不可以更改。
	起元素必须是相同类型的，不能是混合型。
	数组类型可以是任何数据类型，包括基本类型和引用类型。
创建数组的三种方式为：

直接添加元素
	类型[] 数组名 = {元素，元素，元素，……};
	int[] arr={1,2,3,4};
	先定义数组长度再添加元素
	类型[] 数组名 = new 类型[长度];
	int[] ...]]></description><category></category></item><item><title><![CDATA[免安装mysql的配置]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/97016098</link><guid>https://blog.youkuaiyun.com/springlan/article/details/97016098</guid><author>springlan</author><pubDate>Wed, 10 Jun 2020 22:32:34 +0800</pubDate><description><![CDATA[在mysql的主目录下进入控制台，安装 mysqld.exe -install  服务
	启动mysql服务：net start mysql
	如果出现下面的提示启动失败，则在控制台执行sc delete mysql删除mysql服务，然后在主目录的my.ini文件中填入mysql的注主目录路径以及数据存放路径：
   

   

重新执行mysqld.exe -ins...]]></description><category></category></item><item><title><![CDATA[oracle和mysql自动备份，循环定时使用windows任务计划程序设置程序定时任务]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/106666100</link><guid>https://blog.youkuaiyun.com/springlan/article/details/106666100</guid><author>springlan</author><pubDate>Wed, 10 Jun 2020 15:14:12 +0800</pubDate><description><![CDATA[if not exist c:\数据库备份\%date:~0,4%-%date:~5,2%-%date:~8,2%\oracle (
	md c:\数据库备份\%date:~0,4%-%date:~5,2%-%date:~8,2%\oracle
)else (
    echo c:\数据库备份\%date:~0,4%-%date:~5,2%-%date:~8,2%\oracle is exist!
)
if not exist C:\数据库备份\%date:~0,4%-%date:~5,2%-%date.]]></description><category></category></item><item><title><![CDATA[forfiles的使用]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/106661885</link><guid>https://blog.youkuaiyun.com/springlan/article/details/106661885</guid><author>springlan</author><pubDate>Wed, 10 Jun 2020 11:25:33 +0800</pubDate><description><![CDATA[Forfiles 从文件夹或树中选择要进行批处理的文件。

例子：


forfiles.exe /p "D:\Kugou" /m *.tar /d -14 /c "cmd /c del @path"

说明：寻找D:/Kugou目录下的任意后缀名为tar的文件，查看其日期属性是否为14天之前的（-14表示之前，+14表示之后），然后执行删除命令

语法
forfiles [/p Path ] [/m SearchMask ] [/s ] [/c Command ] [/d [{+ | - }] [{MM ]]></description><category></category></item><item><title><![CDATA[js和java数字正则验证]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/106659149</link><guid>https://blog.youkuaiyun.com/springlan/article/details/106659149</guid><author>springlan</author><pubDate>Wed, 10 Jun 2020 09:56:06 +0800</pubDate><description><![CDATA[js:

/^(\+?|-?)\d+(\.\d+|\d*)$/


测试：/^(\+?|-?)\d+(\.\d+|\d*)$/.test("123456789");

java



^(\+?|-?)\d+(\.\d+|\d*)$


测试：Pattern.matches("^(\+?|-?)\d+(\.\d+|\d*)$","123456789");


]]></description><category></category></item><item><title><![CDATA[table中cellspacing和cellpadding的区别]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/106441686</link><guid>https://blog.youkuaiyun.com/springlan/article/details/106441686</guid><author>springlan</author><pubDate>Sat, 30 May 2020 15:10:58 +0800</pubDate><description><![CDATA[cellspacing：(作用于table)，表格中单个单元格之间的距离

cellpadding：(作用于table)设置单元格的内边距，相当于使用padding


&lt;table border='1px' cellspacing="5px" cellpadding="0"&gt;
    &lt;tr&gt;
        &lt;td style='width:100px;padding-left: 100px;'&gt;你好&lt;/td&gt;
        &lt;td&gt;这是&l]]></description><category></category></item><item><title><![CDATA[html中权重标签]]></title><link>https://blog.youkuaiyun.com/springlan/article/details/106434571</link><guid>https://blog.youkuaiyun.com/springlan/article/details/106434571</guid><author>springlan</author><pubDate>Fri, 29 May 2020 23:18:10 +0800</pubDate><description><![CDATA[&lt;H&gt;标题

&lt;b&gt;：会将内容加粗显示，没有凸显语气，只是单纯的加粗

&lt;strong&gt;：会将内容加粗显示，一个加强语气夸张的标签，它的夸张作用重要是通过把字体加粗来实现的

&lt;em&gt;：会将内容加粗显示，它的夸张作用仅仅次于&lt;strong&gt;标签

&lt;i&gt;：会将字体倾斜显示

&lt;u&gt;：在内容下面提添加下划线

&lt;del&gt;：添加中划线


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