package?baobiaoServlet;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;

import?javax.servlet.ServletException;
import?javax.servlet.annotation.WebServlet;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

import?com.mchange.v2.c3p0.ComboPooledDataSource;

import?net.sf.json.JSONArray;
import?net.sf.json.JSONobject;

@WebServlet（“/BaobiaoServlet“）
public?class?BaobiaoServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;
???????
??
	protected?void?doGet（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		request.setCharacterEncoding（“utf-8“）;
		String?uname=（String）?request.getSession（）.getAttribute（“uname“）;
		?String?startDate?=?request.getParameter（“startDate“）;
		?System.out.println（“1111111111111“+startDate）;
		String?endDate=request.getParameter（“endDate“）;
		System.out.println（“11111111111111111“+endDate）;
		try{
		//創建連接池核心工具類
????????ComboPooledDataSource?dataSource=new?ComboPooledDataSource（）;
????????//從連接池對象中獲取數據庫連接
????????Connection?conn=dataSource.getConnection（）;
		
		String?sql=“select?SUM（totalprice）?as?ncuskind?from?[financialSystem].[dbo].[CusInfo]??where?custime?between?‘“+startDate+“‘?and?‘“+endDate+“‘?and?uname=‘“+uname+“‘?group?by?cuskind??“;
		PreparedStatement?ps=conn.prepareStatement（sql）;
		System.out.println（sql）;
		ResultSet?rs=ps.executeQuery（）;
		JSONArray?jsonarray?=?new?JSONArray（）;
		JSONobject?jsonobj?=?new?JSONobject（）;?
		while（rs.next（））{
			jsonobj.put（“n“?rs.getString（“n“））;
			jsonobj.put（“cuskind“?rs.getString（“cuskind“））;
			
			jsonarray.add（jsonobj）;?
		}
		//?輸出數據
		??response.setHeader（“Access-Control-Allow-Origin“?“*“）;
	???		response.setContentType（“text/html;charset=utf-8“）;
		?PrintWriter?out?=?response.getWriter（）;
		???????????out?=?response.getWriter（）;
		???????????out.println（jsonarray）;
		???????????System.out.println（jsonarray）;
		???????????
		???		out.flush（）;
		???		out.close（）;
		}catch（Exception?e）{
			e.printStackTrace（）;
		}
	}

	/**
	?*?@see?HttpServlet#doPost（HttpServletRequest?request?HttpServletResponse?response）
	?*/
	protected?void?doPost（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		//?TODO?Auto-generated?method?stub
		doGet（request?response）;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2018-06-16?20:27??financialSystem\
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\
?????文件????????1497??2018-04-07?17:01??financialSystem\financialSystem\.classpath
?????文件????????1048??2018-03-08?18:47??financialSystem\financialSystem\.project
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\.settings\
?????文件?????????567??2018-03-08?18:47??financialSystem\financialSystem\.settings\.jsdtscope
?????文件?????????364??2018-03-08?18:47??financialSystem\financialSystem\.settings\org.eclipse.jdt.core.prefs
?????文件?????????497??2018-03-08?18:47??financialSystem\financialSystem\.settings\org.eclipse.wst.common.component
?????文件?????????305??2018-03-08?18:47??financialSystem\financialSystem\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-03-08?18:47??financialSystem\financialSystem\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-03-08?18:47??financialSystem\financialSystem\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\build\
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\build\classes\
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\build\classes\baobiaoServlet\
?????文件????????3768??2018-06-15?21:25??financialSystem\financialSystem\build\classes\baobiaoServlet\BaobiaoServlet.class
?????文件????????1292??2018-06-15?21:25??financialSystem\financialSystem\build\classes\baobiaoServlet\Countdays.class
?????文件????????4674??2018-06-15?21:25??financialSystem\financialSystem\build\classes\baobiaoServlet\ZhexianServlet.class
?????文件?????????624??2018-03-31?22:44??financialSystem\financialSystem\build\classes\c3p0-config.xml
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\build\classes\com\
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\build\classes\com\train\
?????目錄???????????0??2018-06-16?20:27??financialSystem\financialSystem\build\classes\com\train\bean\
?????文件????????1135??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Changemima.class
?????文件?????????273??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Chaxun.class
?????文件????????1438??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Forget.class
?????文件????????1446??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Income.class
?????文件????????1980??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Invest.class
?????文件????????2868??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Jizhang.class
?????文件?????????717??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Login.class
?????文件????????1114??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Register.class
?????文件????????2884??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\Search.class
?????文件?????????526??2018-06-15?21:25??financialSystem\financialSystem\build\classes\com\train\bean\YZname.class
............此處省略937個文件信息