src/com/action/fenxi_servlet.java

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

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

package com.action;

import java.io.IOException;
import java.sql.ResultSet;
import java.util.Date;
import java.util.HashMap;
import java.util.Map;

import javax.servlet.RequestDispatcher;
import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import com.dao.DB;
import com.util.DateUtils;

public class fenxi_servlet extends HttpServlet
{
	public void service(HttpServletRequest req,HttpServletResponse res)throws ServletException, IOException 
	{
		DB mydb=new DB();
		String nowYear = DateUtils.formatDate2Str(new Date(), "yyyy");
		try{
			
			//增加的资产
			String sql = "select count(1)shuliang,ifnull(sum(jiazhi),0)jiazhi from t_zichan where type=0 and shijian like '"+nowYear+"%'";
			mydb.doPstm(sql, null);
			ResultSet rs=mydb.getRs();
			rs.next();
			double zjzcjz = rs.getDouble("jiazhi");
			Map zczj = new HashMap();
			zczj.put("sl", rs.getString("shuliang"));
			zczj.put("jz", zjzcjz);
			rs.close();
			
			//减少的资产
			sql = "select count(1)shuliang,ifnull(sum(jiazhi),0)jiazhi from t_zichan where type=1 and shijian like '"+nowYear+"%'";
			mydb.doPstm(sql, null);
			rs=mydb.getRs();
			rs.next();
			double jszcjz = rs.getDouble("jiazhi");
			Map zcjs = new HashMap();
			zcjs.put("sl", rs.getString("shuliang"));
			zcjs.put("jz", jszcjz);
			rs.close();
			
			//总资产
			Map zongzichan = new HashMap();	//总资产
			double zzc = zjzcjz-jszcjz;
			zongzichan.put("zichan", zzc);
			
			//利润
			sql = "select 1, ifnull(sum(touru),0)touru,ifnull(sum(shouyi),0)shouyi,ifnull(sum(lirun),0)lirun " +
				  "from t_jingying where riqi like '"+nowYear+"%'";
			mydb.doPstm(sql, null);
			rs=mydb.getRs();
			rs.next();
			Map jingying = new HashMap();