package?zong;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.sql.Statement;
import?java.util.ArrayList;
import?java.util.HashMap;
import?java.util.List;
import?java.util.Map;

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.google.gson.Gson;
@WebServlet（“/HighCharts“）
public?class?HighCharts?extends?HttpServlet?{

	/**
	?*?
	?*/
	private?static?final?long?serialVersionUID?=?-5008685379832941710L;

	/**
	?*?Constructor?of?the?object.
	?*/
	public?HighCharts（）?{
		super（）;
	}

	/**
	?*?Destruction?of?the?servlet.?

	?*/
	public?void?destroy（）?{
		super.destroy（）;?//?Just?puts?“destroy“?string?in?log
		//?Put?your?code?here
	}

	/**
	?*?The?doGet?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?get.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		
????????
???????
		
		
		Connection?conn?=?null;
		String?sql;
		String?url?=?“jdbc:mysql://localhost:3306/userdb“;
		String?username?=?“root“;??//數據庫用戶名
????????String?password?=?“123456“;??//數據庫用戶密碼
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
			conn?=?DriverManager.getConnection（url?username?password）;
			Statement?stmt?=?conn.createStatement（）;
			sql?=?“select?*?from?tem“;
			ResultSet?rs?=?stmt.executeQuery（sql）;
			Listject>>?list?=?new?ArrayListject>>（）;
			while?（rs.next（））?{
				System.out.println（rs.getString（1）?+?“?“?+?rs.getString（2）?+?“?“?+?rs.getString（3）+?“?“?+?rs.getString（4））;
				Mapject>?map?=?new?HashMapject>（）;
				map.put（“date“?rs.getString（1））;
				map.put（“temp“?Double.parseDouble（rs.getString（3）））;
				list.add（map）;
			}
			Gson?gson?=?new?Gson（）;
			String?g?=?gson.toJson（list）;
			
			PrintWriter?out?=?response.getWriter（）;??
			out.println（g）;
			out.flush（）;
			out.close（）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}

	/**
	?*?The?doPost?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?post.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-09?19:19??highcharts\
?????文件????????1232??2019-01-10?10:31??highcharts\.classpath
?????文件????????1335??2016-04-19?20:20??highcharts\.project
?????目錄???????????0??2019-01-09?19:19??highcharts\.settings\
?????文件?????????522??2016-04-19?18:23??highcharts\.settings\.jsdtscope
?????文件??????????66??2019-01-10?15:16??highcharts\.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2016-04-19?18:23??highcharts\.settings\org.eclipse.jdt.core.prefs
?????文件?????????489??2016-04-19?18:23??highcharts\.settings\org.eclipse.wst.common.component
?????文件?????????414??2016-04-19?18:23??highcharts\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2016-04-19?18:23??highcharts\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2016-04-19?18:23??highcharts\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-01-09?19:19??highcharts\src\
?????目錄???????????0??2019-01-09?19:19??highcharts\src\zong\
?????文件????????3377??2019-01-10?14:04??highcharts\src\zong\HighCharts.java
?????目錄???????????0??2019-01-10?15:16??highcharts\WebRoot\
?????文件????????2317??2019-01-10?14:48??highcharts\WebRoot\index.jsp
?????目錄???????????0??2019-01-10?14:47??highcharts\WebRoot\js\
?????文件??????219110??2019-01-09?20:33??highcharts\WebRoot\js\highcharts.js
?????文件???????93637??2019-01-10?14:41??highcharts\WebRoot\js\jquery-1.8.3.min.js
?????目錄???????????0??2019-01-09?19:19??highcharts\WebRoot\meta-INF\
?????文件??????????39??2016-04-19?18:23??highcharts\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2019-01-09?19:19??highcharts\WebRoot\WEB-INF\
?????目錄???????????0??2019-01-10?16:11??highcharts\WebRoot\WEB-INF\classes\
?????目錄???????????0??2019-01-10?16:11??highcharts\WebRoot\WEB-INF\classes\zong\
?????文件????????3888??2019-01-10?16:11??highcharts\WebRoot\WEB-INF\classes\zong\HighCharts.class
?????目錄???????????0??2019-01-09?19:19??highcharts\WebRoot\WEB-INF\lib\
?????文件?????????716??2016-04-19?19:53??highcharts\WebRoot\WEB-INF\web.xml