11 2015 档案
摘要:Calendar calendar = Calendar.getInstance();calendar.setTime(date);calendar.add(Calendar.MONTH, 1);//增加一个月System.out.println("增加月份后的日期:"+calendar.getTi...
阅读全文
摘要:delete from information where id in (select id from (select max(id) as id,count(*) as ccc from information GROUP BY encoding HAVING ccc>1 ) as tab)
阅读全文
摘要:1.IFNULL(xxx,'') 如果为空,返回''2.SUBSTR(xxx FROM 1 FOR 18) 取字符串1到18位3.DATE_FORMAT(xxx,'%Y-%m-%d %T') 对日期进行格式化4.CONCAT(xxx,' 00:00:00') 如果是NULL...
阅读全文
摘要:首先效果如下:代码如下://这个是一个循环,循环所有name为xx的td标签(也就是给tdname为XXX的添加事件)$("td[name='strGoodsSKU']").each(function(index,item){ var oldTest = $(this)...
阅读全文
摘要:限制文本框只能输入正数,负数,小数onkeyup="value=value.replace(/[^\-?\d.]/g,'')" 限制文本框只能输入正数,小数onkeyup="value=value.replace(/[^\d.]/g,'')"
阅读全文
摘要://只需要在代码前加这个就可以了
阅读全文
摘要:TO_DAYS(NOW()) - TO_DAYS(createTime) as dayFactor,
阅读全文
摘要:mysql> select current_timestamp();+---------------------+| current_timestamp() |+---------------------+| 2010-01-18 21:24:37 |+---------------------+1...
阅读全文