src/com/action/huizongAction.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package com.action;

import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Map;

import org.apache.struts2.ServletActionContext;

import com.dao.TShouruDAO;
import com.dao.TXiaofeiDAO;
import com.opensymphony.xwork2.ActionSupport;

public class huizongAction extends ActionSupport
{
	private String message;
	private String path;
	private String day=new SimpleDateFormat("yyyy-MM-dd").format(new Date());
	private String month=new SimpleDateFormat("yyyy-MM").format(new Date());
	private String year=new SimpleDateFormat("yyyy").format(new Date());
	
	private TXiaofeiDAO xiaofeiDAO;
	private TShouruDAO shouruDAO;
	
	
	public String huizongDangri()
	{
		Map request=(Map)ServletActionContext.getContext().get("request");
		
		String yifuxiaofeiSum="0.0";
		String sql="select sum(xiaofeiWupinjiage) from TXiaofei where xiaofeiType='yifuxiaofei' and convert(varchar(10),xiaofei_shijian,120)='"+day+"'";
		List list=xiaofeiDAO.getHibernateTemplate().find(sql);
		if(list.get(0)!=null)
		{
			yifuxiaofeiSum=list.get(0).toString();
		}
		request.put("yifuxiaofeiSum", yifuxiaofeiSum);
		
		String shipinxiaofeiSum="0.0";
		sql="select sum(xiaofeiWupinjiage) from TXiaofei where xiaofeiType='shipinxiaofei' and convert(varchar(10),xiaofei_shijian,120)='"+day+"'";
		list=xiaofeiDAO.getHibernateTemplate().find(sql);
		if(list.get(0)!=null)
		{
			shipinxiaofeiSum=list.get(0).toString();
		}
		request.put("shipinxiaofeiSum", shipinxiaofeiSum);
		
		
		
		String jiajuxiaofeiSum="0.0";
		sql="select sum(xiaofeiWupinjiage) from TXiaofei where xiaofeiType='jiajuxiaofei' and convert(varchar(10),xiaofei_shijian,120)='"+day+"'";
		list=xiaofeiDAO.getHibernateTemplate().find(sql);
		if(list.get(0)!=null)
		{
			jiajuxiaofeiSum=list.get(0).toString();
		}
		request.put("jiajuxiaofeiSum", jiajuxiaofeiSum);