package?com.system.controller;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.SQLException;
import?java.util.List;

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?javax.servlet.http.HttpSession;

import?com.alibaba.fastjson.JSONArray;
import?com.system.dao.baseDao;
import?com.system.dao.baseDaoImpl;
import?com.system.entity.baseArea;
import?com.system.entity.Cllent;
import?com.system.service.objectService;

/**
?*?首頁所需servlet
?*/
@WebServlet（“/LiandongServlet“）
public?class?LiandongServlet?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;

	protected?void?service（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		request.setCharacterEncoding（“utf-8“）;
		response.setContentType（“text/html;charset=utf-8“）;

		baseDao?dao?=?new?baseDaoImpl（）;//?數據庫工具類
		objectService?ob?=?new?objectService（）;//?處理方法
		baseArea?bas?=?ob.setobject（request?baseArea.class）;
		PrintWriter?out?=?response.getWriter（）;//?ajax返回方法
		String?method?=?request.getParameter（“method“）;
		System.out.println（method）;

		//?登錄
		if?（“provinceQuery“.equals（method））?{//?查詢省
			try?{
				String?sql?=?“SELECT??area.base_areaidarea.name?FROM?base_area?area?where?1=1?and?area.parentid=‘0‘“;
				JSONArray?listDept?=?dao.findJSONArray（sql）;
				System.out.println（listDept）;
				out.write（listDept.toJSONString（））;
				out.flush（）;
				out.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}

		}?else?if（“provinceCity“.equals（method））?{//查詢市
			try?{
				String?sql?=?“SELECT?area.base_areaidarea.name?FROM?base_area?area?where?1=1?and?area.parentid=?“;
				JSONArray?listDept?=?dao.findJSONArray（sqlbas.getParentid（））;
				System.out.println（listDept）;
				out.write（listDept.toJSONString（））;
				out.flush（）;
				out.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}else?if（“provinceCounty“.equals（method））?{//查詢縣/區
			try?{
				String?sql?=?“SELECT?area.base_areaidarea.name?FROM?base_area?area?where?1=1?and?area.parentid=?“;
				JSONArray?listDept?=?dao.findJSONArray（sqlbas.getParentid（））;
				System.out.println（listDept）;
				out.write（listDept.toJSONString（））;
				out.flush（）;
				out.close（）;
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}

	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-03-21?12:46??三級聯動\
?????文件??????240453??2020-02-27?17:17??三級聯動\base_area.sql
?????文件???????93106??2019-08-17?14:48??三級聯動\jquery.js
?????文件???????95825??2019-08-18?11:17??三級聯動\jquery.min.js
?????文件????????3303??2020-02-27?14:27??三級聯動\liandong.jsp
?????文件????????2612??2020-02-27?13:54??三級聯動\LiandongServlet.java