ioxyj-CSDN博客

原创 oracle之function

CREATE OR REPLACE FUNCTION SELECT_CURSTARTANDEND(SELECTDATE IN DATE) RETURN RESULT_T_CURSTARTANDEND PIPELINED ISBEGIN PIPE ROW(RESULT_CURSTARTANDEND( trunc(SELECTDATE,'mm') , t

2016-06-15 09:54:08 204

原创 oracle之type

CREATE OR REPLACE TYPE "RESULT_CURSTARTANDEND"

2016-06-15 09:53:01 219

原创 oracle函数及type

CREATE OR REPLACE TYPE "RESULT_CURSTARTANDEND"

2016-05-27 15:10:09 627

原创 ajax jsonp java后台

jsp $.ajax({ contentType:"application/x-www-form-urlencoded", type: "POST", dataType:'jsonp', jsonp:"jsonpCallback", data: {"picture":picture}, url: uploadUrl+"ma

2016-04-18 11:27:59 423

原创机构统计

WITH TIME_VIEW AS (SELECT STARTDATE, ENDDATE, STARTTIME, ENDTIME FROM TABLE(SELECT_STARTEND('$time$'))), ORGAN_TREE AS (SELECT O.ID, O.ORGAN, O.FATHEROR

2016-01-29 13:37:46 171

原创个人统计

SELECT NVL(T2.TEMP_COUNT, 0) tldp, FROM RYMC_VIEW T1 LEFT JOIN (SELECT COUNT(TT.ID) TEMP_COUNT, TT.ID FROM ZHUSU_VIEW TT GROUP BY ID) T2 ON T1.ID = T2.ID

2016-01-29 13:23:07 205

原创一人一条最新

with ZHUSU as(SELECT * FROM t_ga_zhusu)SELECT DISTINCT FIRST_VALUE(ID) OVER(PARTITION BY T1.CERTNO ORDER BY T1.CHECINTIME DESC NULLS LAST, T1.ID DESC) ID, (select count(1

2016-01-29 13:10:44 213

原创多线程

/** * public ThreadPoolExecutor(int corePoolSize, int maximumPoolSize, long keepAliveTime, TimeUnit unit,

2015-12-15 10:35:29 227

原创 ibatis缓存

Ibatis缓存简单使用一缓存简单介绍二缓存简单使用使用例子：cacheModelsEnabled="true" 单表组织机构： cacheModel type="LRU" id="organCache">flushInterval minutes="30" />flushOn

2015-12-14 17:22:39 228

原创 oracle新增（ibatis）

insert into upload_files_type(id,name,pid,type,orderVal)values(SQ_UPLOAD_FILES_TYPE.nextval,#name#,#pId#,#type#,#orderVal#)selectSQ_UPLOAD_FILES_TYPE.currval as id from

2015-12-14 15:39:46 148

原创 oracle删除恢复

SELECT * FROM t_sqjz_quesanswer AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '1' DAY)

2015-12-14 14:15:04 138

原创 oracle锁

SELECT A.OWNER, --OBJECT所属用户 A.OBJECT_NAME, --OBJECT名称（表名） B.XIDUSN, B.XIDSLOT, B.XIDSQN, B.SESSION_ID, --锁表用户的session B.

2015-12-14 14:11:27 185

原创分页

SELECT ID, RN FROM (SELECT ROWNUM RN, ID FROM (SELECT RY.ID ID FROM T_SQJZ_RYMC RY WHERE 1 = 1 ORDER BY startTime desc nu

2015-04-13 08:59:56 141

转载 httpclient

本文引用的资源列表： httpclient入门： http://www.ibm.com/developerworks/cn/opensource/os-httpclient/ httpclient证书导入：http://www.blogjava.net/happytian/archive/2006/12/22/89447.html httpclient高级认识：ht

2015-04-10 09:21:38 258

ioxyj的专栏