`
文章列表
来源:http://chenzhou123520.iteye.com/blog/1313565 我们都知道,在Eclipse或MyEclipse中安装插件有两种方式,一种是在线安装,第二种是先下载插件然后在本地安装。 在这里我们先介绍第一种在线安装。   Eclipse上在线安装findbugs(具体步骤如下,就不再赘述)     In Eclipse, click on Help -> Software Update -> Find and Install... Choose the Search for new features to install optio ...
http://blog.csdn.net/ch4230052/article/details/7712920
String str = String.format("%tF %<tT", 1229159619623L);
if($.isFunction($(“#id”).方法名称)){ return true; }
declare v_rowcount integer; begin v_rowcount:=0; select count(*) into v_rowcount from ALL_SEQUENCES where sequence_name='SEQ_XX'; if v_rowcount=0 then execute immediate 'create sequence SEQ_XX minvalue 1 maxvalue 9999999999 start with 1 increment by 1 cache 20 order' ...
select round(a/b,2) from dual; or select to_char(a/b,'fm9999999.99') from dual;
declare n number; begin insert into bak_t0_stkcode select * from t0_stkcode; n:=sql%rowcount; commit; dbms_output.put_line(n); end;        参考:http://blog.sina.com.cn/s/blog_713978a50100xi6z.html
merge into stkcode a using (select * from stkcode t where t.change_type='1')b on (a.id=b.id and a.stock_code=b.stock_code) update set a.change_type=b.change_type||',2' where a.change_type='1'; commit;  
substr 汉字按一个字符算,substrb按两个字符算
select ''''||stock_name||'''' from stkcode; or select chr(39)||stock_name||chr(39) from stkcode;
package cn.javass.spring.chapter12; import java.util.ArrayList; import java.util.List; import java.util.concurrent.Callable; import java.util.concurrent.ExecutionException; import java.util.concurrent.ExecutorService; import java.util.concurrent.Executors; import java.util.concurrent.Future ...
for update 可以锁定某张数据表的某条记录,而synchronized锁定的只是代码块
create or replace procedure ptest is begin declare cursor cur_s is select stock_code ,stock_name from stkcode; v_no varchar2(6); v_name varchar2(8); begin open cur_s; loop fetch cur_s into v_no,v_name; exit when cur_s % notfound; dbms_output.putl ...
xml里面的配置 <aop:aspectj-autoproxy/> <context:component-scan base-package="com.xx"/> java代码 @Aspect @Component public class LogAdvice{ @After("@annotation(testLog)") public void testLog(JoinPoint joinPoint,TestLog testLog)throws Exception{ Syst ...
select decode(nvl(yy,0),'0','',fn_get_name('xx')) from dual;
Global site tag (gtag.js) - Google Analytics