C5bk9rm9TFUo
BEGIN --EXTRACT用于从一个日期时间值中提取日期部份 IFEXTRACT(MONTHFROMSYSDATE)=11THEN DBMS_OUTPUT.put_line('是11月份!'); ELSE DBMS_OUTPUT.put_line('不是11月份！'); ENDIF; END;
<styletype="text/css"> table{ margin:auto;//设置Table居中 } td{ height:30px; } input{ padding:3px03px0; } .easyui-combobox{ height:24px; } .combo-arrow{ height:24px; } .combo-text{ height:24px; } .span-width{ width:100px; padding-left:20px; } .input-td-width{ width:240px; } </style...
js中 $('tag').combobox({ url:'/DataAction.do?method=geTag', valueField:'CODEVALUE', textField:'CODENAME', panelHeight:'250',//设置panelHeight为固定值时会出现滚动条，也可设置成panelHeight:'auto'无滚动条。 Jsp中 <inputid="tag"name="tag"class="easyui-combobox"panelHeight="250"data-options="editable:false"style="...
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); try{ //xxxxx }catch(Exceptione){ TransactionAspectSupport.currentTransactionStatus().setRollbackOnly(); thrownewRuntimeException(e.getMessage()); }
style="height:550px;border:1px;"细线 style="height:110px;border:none;"无边框
httpMon.js $(function(){ getServiceState(); run(); }); varinterval; functionrun(){ interval=setInterval(ajaxGetSerState,"3000");//3秒钟刷一下 } functionajaxGetSerState(){ $.ajax({ type:'POST', url:$.test.contextPath+'/MonAction.do?method=getState', dataType:'json', success:function(data){...
index.jsp <%@pagecontentType="text/html;charset=UTF-8"%> <html> <head> <title>Test</title> <scripttype="text/javascript"> window.location.href="<%=request.getContextPath()%>/LoginAction.do?method=login"; </script> </head> </html>  ...
publicstaticStringgetDateSerialToMinute(){ StringreceiptId=""; Calendarcal=Calendar.getInstance(); //cal.add(Calendar.MINUTE,-2);--减去两分钟 receiptId+=cal.get(Calendar.YEAR); intmonth=(cal.get(Calendar.MONTH)+1); if(month<10){ receiptId+="0"+month; }else{ receiptId+=month; } intday=cal.get(Calenda...
varss="http://www.baidu.com?n="+Math.random(); $("hardIframe").attr("src",ss); $('hardIframe').attr('src',$('hardIframe').attr('src')); functionrefWin(){ $.ajax({ type:'POST', url:$.test.contextPath +"/demoAction.do?method=getMonUrl", dataType:'json', success:function(data){ ...
easyUi下拉列表固定值 <inputid="timeType"name="timeType"class="easyui-combobox"data-options="valueField:'CODEVALUE',textField:'CODENAME',data:[{CODENAME:'日',CODEVALUE:'0',selected:true},{CODENAME:'月',CODEVALUE:'1'},{CODENAME:'时',CODEVALUE:'2'},{CODENAME:'分',CODEVALUE:'3'}]"style="width:257px;"/> &n...
--读取jsonjson-lib-2.2.3 {"COUNT":"888","NAME":"JTS"} JSONObjectjsonObject=JSONObject.fromObject(m.getValue()); Stringname=jsonObject.getString("COUNT"); System.out.println(name); --生成json JSONObjectjsonObject=newJSONObject(); jsonObject.put("COUNT","888"); jsonObject.put("NAME","JTS"); String...
SELECTT.OPE_NAME,T.OPE_IDENTIFY,TRUNC(T.CREATION_DATE,'hh24'),TRUNC(T.CREATION_DATE,'hh24')+1/24,COUNT(1)/to_char(T.CREATION_DATE,'yyyymmddhh24:mi:ss')/ FROMT_OPE_ACCOUNTT GROUPBYT.OPE_NAME,T.OPE_IDENTIFY,TRUNC(T.CREATION_DATE,'hh24') SELECTT.OPE_NAME,T.OPE_IDENTIFY,TRUNC(T.CREATION_DATE,'mi'),T...
SELECTSYSDATE-1FROMDUAL;--减一天 SELECTTO_DATE('2014-06-1012:05:22','YYYY-MM-DDHH24:MI:SS')-NUMTODSINTERVAL(1,'HOUR')FROMDUAL;--减一小时 SELECTTO_DATE('2014-06-1012:05:22','YYYY-MM-DDHH24:MI:SS')+NUMTODSINTERVAL(1,'HOUR')FROMDUAL;--加一小时 SELECTSYSDATE,SYSDATE+NUMTODSINTERVAL(50,'MINUTE')FROMDUAL;--加五十分钟 ...
http://sourceforge.net/projects/jadclipse/files/ 1.安装 2. 3.1.将jad.exe解压到指定目录。如:c:\java\jad 4.2.将jadeclipse插件net.sf.jadclipse_3.3.0.jar拷贝到myeclipse安装目录\Genuitec\Common\plugins\目录下。 5.3.在myeclipse安装目录下dropins/创建eclipse文件夹，然后在eclipse文件夹中分别创建features、plugins文件夹，将net.sf.jadclipse_3.3.0.jar分别拷贝到f...
DECLARE STRVARCHAR2(50); P_NONUMBER(10); BEGIN MERGEINTOTEST2T2 USING(SELECTT3.NAME,T3.DEPT,T3.BIRTHDAY FROMTEST3T3 WHERET3.BIRTHDAY=DATE'2014-05-01')V ON(V.NAME=T2.C2) WHENMATCHEDTHEN UPDATESETT2.C3=V.BIRTHDAY,T2.C1=86868 WHENNOTMATCHEDTHEN INSERT(T2.C1,T2.C2,T2.C3)VALUES(11111,V.NAME,V.BIRTHDA...
ORA-01422exactfetchreturnsmorethanrequestednumberofrows异常 SELECTT.A1INTOP_STRFROMTESTT;--当T.A1查询多条记录时INTO到P_STR会报ORA-01422异常
DECLARE INDENUMBER:=0; BEGIN FORRIN(SELECT/+INDEX(TIDX_INV_03)/ T.ROWIDROID FROMTT_INV_DATET,TT_INT_CONFIGT1 WHERET.PT_CODE=T1.INV_PT_CODE ANDT1.CON_CODE='1122' ANDT.INV_TM>DATE'2014-06-01' ANDT.INV_TM<DATE'2014-07-31' ANDT.REA_CODE='124' ANDT.IS_UPLOADED=1)LOOP INDE:=INDE+1; UPDATETT_INV_DA...
--selectxxxFROM表名@数据库链接名 SELECTB.FROMTT_DB_RECORD@LINK_TEST_DBB--LINK_TEST_DB为DB_LINK名，TT_DB_RECORD另一个数据库的表名
publicclassTestDaoImplextendsHibernateDaoSupportimplementsTestDao{ publicStringhibernateCallPro(){ return(String)this.getJdbcTemplate().execute(newCallableStatementCreator(){ publicCallableStatementcreateCallableStatement(Connectionconn) throwsSQLException{ CallableStatementstmt=con...
packagecom.test; publicclassThreadTest2{ privatestaticbyte[]lock=newbyte[0]; privatestaticinti=0; publicstaticvoidmain(String[]args){ newThread(){ publicvoidrun(){ while(true){ synchronized(lock){ if(i%20){ System.out.println(Thread.currentThread().getName()+"-"+i);...