<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[dequ7489的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/dequ7489</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dequ7489]]></copyright><item><title><![CDATA[java集合中寻找指定对象的集合或对象数据]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884521</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884521</guid><author>dequ7489</author><pubDate>Mon, 24 Dec 2018 10:51:00 +0800</pubDate><description><![CDATA[package com.xiniunet.web.tool;import java.lang.reflect.InvocationTargetException;import java.lang.reflect.Method;import java.util.ArrayList;import java.util.HashSet;import java.util.List;import j...]]></description><category></category></item><item><title><![CDATA[Nginx反向代理实现会话（session）保持的两种方式]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884516</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884516</guid><author>dequ7489</author><pubDate>Mon, 21 May 2018 15:16:00 +0800</pubDate><description><![CDATA[Nginx反向代理实现会话（session）保持的两种方式
2013年11月27日⁄Web技术⁄ 共 714字⁄暂无评论⁄ 被围观 17,172 views+


一、ip_hash：
ip_hash使用源地址哈希算法，将同一客户端的请求总是发往同一个后端服务器，除非该服务器不可用。
ip_hash语法：

upstream backend {
    ip...]]></description><category></category></item><item><title><![CDATA[iBatis 与 myBatis 调用存储过程方式 1.0 2.0 3.0 之间的区别]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884514</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884514</guid><author>dequ7489</author><pubDate>Tue, 08 May 2018 08:54:00 +0800</pubDate><description><![CDATA[sqlMapConfig.xml中的异同.








iBATIS_v1


iBATIS_v2


iBATIS_v3




DOCTYPE


sql-map-config.dtd


sql-map-config-2.dtd


ibatis-3-config.dtd




configuration...]]></description><category></category></item><item><title><![CDATA[闲的无聊写了个仿MySQL replaceall() 函数]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884519</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884519</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 18:08:00 +0800</pubDate><description><![CDATA[BEGIN
		-- 用于控制循环是否结束		DECLARE DONE INT DEFAULT -1;
		-- 变量声明		DECLARE PARAM_OUT VARCHAR(512) DEFAULT '';		DECLARE VAR_STR VARCHAR(512) DEFAULT '';		DECLARE VAR_STR_NEW VARCHAR(512) DEF...]]></description><category></category></item><item><title><![CDATA[MySQL While取出汉字字符串首字母存储过程(不区分多音字)]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884512</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884512</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 17:34:00 +0800</pubDate><description><![CDATA[--pinyin返回整个汉字字符串所有首字母
BEGIN    DECLARE V_COMPARE VARCHAR(255);    DECLARE V_RETURN VARCHAR(255);    DECLARE I INT;    SET I = 1;    SET V_RETURN = '';    while I &lt; LENGTH(P_NAME) do      ...]]></description><category></category></item><item><title><![CDATA[Oracle查询库中已有存储过程、创建定时刷新视图、角色权限传递、创建序列触发器...]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884517</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884517</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 17:13:00 +0800</pubDate><description><![CDATA[SELECT * FROM V$ACCESS O WHERE O.TYPE LIKE 'PROCEDURE%'
创建物化视图且定时刷新create materialized view mv_name refresh force on demand start with sysdate next sysdate + 1create materialized view mv_name re...]]></description><category></category></item><item><title><![CDATA[Oracle DBlink相关]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884510</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884510</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 17:01:00 +0800</pubDate><description><![CDATA[1、已经配置本地服务　　create public database link link_nameconnect to username identified by passwordusing 'connect_string';注：link_name是连接名字，可以自定义；username是登陆数据库的用户名；password是登陆数据库的用户密码；connect_string是数据库连...]]></description><category></category></item><item><title><![CDATA[Hive Hadoop数据迁移工具配置]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884515</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884515</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 16:04:00 +0800</pubDate><description><![CDATA[squirrel Config
Add DriverNAME:Hive1.2Example URL:jdbc:hive2://132.228.24.35:8901/cwdsjdbWebsite URL:[不填]Class Name:org.apache.hive.jdbc.HiveDriver
Add AliasNAME:[随意]Driver:Hive1.2URL:[选好Driver...]]></description><category></category></item><item><title><![CDATA[Oracle关闭锁表进程]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884508</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884508</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 16:03:00 +0800</pubDate><description><![CDATA[关闭锁表进程ALTER SYSTEM KILL SESSION '579,31071';CALL SYS.KILL_SESSION(1929,6893);EXEC SYS.KILL_SESSION(1929,6893);

转载于:https://www.cnblogs.com/Dream-Lasting/p/8991082.html]]></description><category></category></item><item><title><![CDATA[定时任务间隔时间]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884513</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884513</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 16:02:00 +0800</pubDate><description><![CDATA[-- 查询定时任务
select * from user_jobs;
-- 停止JOBbegin dbms_job.broken(jobno,true);end;begin dbms_job.remove(jobno);commit;end;/-- 启动JOBbegin dbms_job.run(jobno);end;-- 修改JOB运行内容begin dbms_job.what(j...]]></description><category></category></item><item><title><![CDATA[OracleSQL语句时间格式转换]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884511</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884511</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 16:02:00 +0800</pubDate><description><![CDATA[TO_CHAR(ADD_MONTHS(SYSDATE,-1),'YYYY'),TO_CHAR(ADD_MONTHS(SYSDATE,-1),'MM')TO_CHAR(ADD_MONTHS(SYSDATE,0),'YYYY'),TO_CHAR(ADD_MONTHS(SYSDATE,0),'MM')TO_DATE('20151231','YYYY-MM-DD') - TO_DATE(ERSD...]]></description><category></category></item><item><title><![CDATA[Oracle数据库表根据时间戳(AS OF TIMESTAMP)备份数据]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884506</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884506</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 16:01:00 +0800</pubDate><description><![CDATA[AS OF TIMESTAMP SYSDATE - 1AS OF TIMESTAMP TO_TIMESTAMP('2016-06-22 12:30:00','YYYY-MM-DD HH24:MI:SS')CREATE TABLE [TABLENAME] AS SELECT * FROM (SELECT * FROM [TABLENAME] AS OF TIMESTAMP SYSDATE ...]]></description><category></category></item><item><title><![CDATA[MySQL基本语句写法]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884509</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884509</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 16:00:00 +0800</pubDate><description><![CDATA[-- 查看数据库中表的字段属性SELECT COLUMN_NAME 列名, COLUMN_COMMENT 名称, COLUMN_TYPE 数据类型, IF(COLUMN_KEY='PRI', "主键", "非主键") 主键,IF(IS_NULLABLE='NO', "可空", "非空") 是否为空, "" 二级注释 , COLUMN_DEFAULT 默认值, TABLE_SCHEMA ...]]></description><category></category></item><item><title><![CDATA[LINUX版本 TOMCAT 启动、关闭、查看状态以及软连接命令ln -s使用]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884507</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884507</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 15:59:00 +0800</pubDate><description><![CDATA[查看CHROME密码:chrome//settings/passwords 点开保存密码的网站审查元素
LINUX版本: cat /proc/version当前版本及使用系统名称 gcc version 4.8.5 20150623 (Red Hat 4.8.5-11) (GCC) Linux version 3.10.0-514.16.1.el7.x86_64查看文件末尾50行内容:...]]></description><category></category></item><item><title><![CDATA[Linux Tomcat使用之前预配置(端口开放关闭 防火墙设置 硬盘挂载 安装文件)]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884504</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884504</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 15:59:00 +0800</pubDate><description><![CDATA[语法 yum(选项)(参数) 选项-h：显示帮助信息；-y：对所有的提问都回答“yes”；-c：指定配置文件；-q：安静模式；-v：详细模式；-d：设置调试等级（0-10）；-e：设置错误等级（0-10）；-R：设置yum处理一个命令的最大等待时间；-C：完全从缓存中运行，而不去下载或者更新任何头文件。参数install：安装rpm软件包；update：更新rpm...]]></description><category></category></item><item><title><![CDATA[ORACLE 更新表数据10/11G UPDATE视图约束更新与MERGE多线程写法]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884505</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884505</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 15:58:00 +0800</pubDate><description><![CDATA[-- ORACLE 更新表数据10GUPDATE (SELECT /*+ BYPASS_UJVC */A.SSXID, A.SSZ, A.SSZID FROM P_ZJ_CZDDW A, (SELECT C.ID, C.ND, C.SSQCODE, C.SSDD, C.SSDDCODE FROM P_ZJ_SJSB C WHERE C.DEL_FLAG = '0') BWHERE A....]]></description><category></category></item><item><title><![CDATA[MYSQL查询增加自增长序号]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884502</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884502</guid><author>dequ7489</author><pubDate>Fri, 04 May 2018 15:57:00 +0800</pubDate><description><![CDATA[SELECT @ROWNUM := @ROWNUM + 1 IDCODE, @ROWNUM, ID, NAME FROM SYS_AREA, (SELECT @ROWNUM := 0) NUM

转载于:https://www.cnblogs.com/Dream-Lasting/p/8991030.html]]></description><category></category></item><item><title><![CDATA[[ SQLServer MySQL Oracle DB2 Sybase Informix PostgreSQL access ] JDBC驱动字符串]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884503</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884503</guid><author>dequ7489</author><pubDate>Sun, 11 Oct 2015 21:06:00 +0800</pubDate><description><![CDATA[SQL server 0.7、2000driver="com.microsoft.jdbc.sqlserver.SQLServerDviver"url="jdbc:microsoft:sqlserver://localhost:1433;DatebaseName=数据库名称"url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseNa...]]></description><category></category></item><item><title><![CDATA[List Map迭代 ( 增强For只适合取数据 )]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884500</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884500</guid><author>dequ7489</author><pubDate>Sun, 11 Oct 2015 20:45:00 +0800</pubDate><description><![CDATA[@Test
public void test1(){
　　List list = new ArrayList();
　　list.add(DateType);
　　...
　　for(Object obj : list){
　　　　DateTypedateType = (DateType)obj;
　　}
}
@Test
public void test2(){
...]]></description><category></category></item><item><title><![CDATA[颜色代码 #000~#FFF & DML案例设计]]></title><link>https://blog.youkuaiyun.com/dequ7489/article/details/101884501</link><guid>https://blog.youkuaiyun.com/dequ7489/article/details/101884501</guid><author>dequ7489</author><pubDate>Thu, 25 Dec 2014 20:28:00 +0800</pubDate><description><![CDATA[package com.qingruan.dao;
import java.sql.ResultSet;import java.sql.SQLException;import java.util.ArrayList;import java.util.List;
import com.qingruan.pojo.Email;import com.qingruan.pojo.EmpI...]]></description><category></category></item></channel></rss>