复兴斧头帮
西斧头帮老大-_- · 共 179 篇文章
eclipse找不到findbugs
来源: 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 option, and click Next …
2016-04-25 10:20 · 评论(0)
calendar.getTimeInMillis()取得的毫秒时间转化为yyyy-MM-dd样式的时间
String str = String.format("%tF %<tT", 1229159619623L);
2016-04-22 15:06 · java基础知识 · 评论(0)
sequence可重复执行脚本
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'; end if; end;
2016-04-01 10:33 · 评论(0)
oracle两数相除,保留两位小数
select round(a/b,2) from dual; or select to_char(a/b,'fm9999999.99') from dual;
2016-03-30 14:50 · 评论(0)
sql%rowcount
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
2016-03-29 17:28 · 评论(0)
sql语句小例子
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;
2016-03-29 17:13 · 评论(0)
oracle 字段前后添加引号
select ''''||stock_name||'''' from stkcode; or select chr(39)||stock_name||chr(39) from stkcode;
2016-03-29 15:49 · 评论(0)
callable和future的小例子
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; import…
2016-03-28 16:41 · 评论(0)
存储过程的小例子
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.putline(v_no); end loop; close cur_s; end; end ptest;
2016-03-28 15:11 · 评论(0)
自定义注解的例子
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{ System.out.println(testLog.remark()); } } @Target({ElementType…
2016-03-28 09:46 · 评论(0)