`
liwy2008
  • 浏览: 28331 次
  • 性别: Icon_minigender_2
  • 来自: 海口
社区版块
存档分类
最新评论
文章列表
1、创建存储过程 create or replace procedure test(var_name_1 in type,var_name_2 out type) as --声明变量(变量名 变量类型) begin --存储过程的执行体 end test; 打印出输入的时间信息 E.g: create or replace procedure test(workDate in Date) is begin dbms_output.putline('The input date is:'||to_date(workDate,&apo ...
查询当前节点的所有子字节: @SuppressWarnings("unchecked") public List<String> findAllChildColumnIdById(long id) throws Exception { return em .createNativeQuery( "select to_char(i.id) FROM columns i start with i.id=:id connect by PRIOR i.id=i.f_parentId order by i.id asc") ...

查询语法大全

1.select* from emp; 2. select empno, ename, job from emp; 3. select empno 编号, ename 姓名, job工作from emp; 4. select job from emp; 5. select distinct job from emp; 6. select distinct empno, job from emp; 说明:因为雇员编号不重复, 所以此时证明所有的列没有重复,所以不能消除掉重复的列. 7.查询出雇员的编号, 姓名, 工作, 但是显示的格式:编号是: 7369 的雇员, 姓名是: smith ...

搜索分页

    博客分类:
  • java
package gov.hn.hrss.web.page; public class Page { private int pagesize = 10, pagecount, liststep = 20, currentpage = 1, recordcount, listbegin, listend, recordbegin, recordend = 0; public Page(int current, int recordcount) { super(); this.currentpage = current; this.recordcount = recordc ...
public static void generatorHtml() { String html = ""; String filePath = ServletActionContext.getServletContext().getRealPath( "/index.html"); File file = new File(filePath); if (file.exists()) { file.delete(); } try { HttpServletRequest request = ServletActi ...
$("input[type=checkbox]").click( function () {   if($(this).prev().attr("disabled")){       $(this).prev().attr("disabled", false);        }else{         $(this).prev().attr("disabled", true);    }   if($("input[type=text]:enabled").leng ...
public static List<Long> generateIds(int[] ids, int count) {   Random r = new Random();   int irdm = 0;   List<Long> rs = new ArrayList<Long>();   if (ids.length < count) {    count = ids.length;   }   for (int i = 0; i < count; i++) {    irdm = r.nextInt(ids.length - i);    r ...

计算文件的大小

    博客分类:
  • java
public static String CountFileSize(long size){ if(size<1024l){ return size+"B"; }else if(size<(1024l*1024l)){ return Math.round((size*100>>10))/100.00+"KB"; }else if(size<(1024l*1024l*1024l)){ return (Math.round((size*100>& ...
比如:在某个时间点(该时间是不固定的)8小时后执行一个任务,并且只执行一次,请问在spring quartz 中 如可实现呢。
private boolean isAjaxRequest(HttpServletRequest request) {           String header = request.getHeader("X-Requested-With");           if (header != null && "XMLHttpRequest".equals(header))               return true;           else              return false;       }
Global site tag (gtag.js) - Google Analytics