jikeyiban08-优快云博客

原创【无标题】

同样SQL不同参数，查询时间相差几十倍

2022-07-09 13:08:44 101

原创统计每年不同的情况（正在下拨，已经下拨）

SELECT ptime,SUM(paying)AS paying ,SUM(payed)AS payed FROM (SELECT YEAR(paymenttime)AS ptime,CASE WHEN payment_confirm=0 THEN paymentamount ELSE 0 END AS paying , CASE WHEN payment_confirm=1 THEN pa

2014-09-22 17:04:53 275

翻译 Struts jsp 遍历action中的数组

action： package com; import java.rmi.RemoteException; import javax.servlet.http.HttpServletRequest; import org.apache.struts2.ServletActionContext; import service.MyServiceStub; import service.M

2014-02-27 15:03:16 462

原创获取时间里的年

SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); String dateString = formatter.format(costAbroad.getAbrTime()); dateString.substring(0, 4);

2014-01-16 14:18:03 307

原创 ztree json

package com.webjet.web.action; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;

2013-11-23 12:39:13 449