package?com.gpbs.action;
import?java.io.IOException;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.util.List;

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

import?com.gpbs.bean.SQLBean;
import?com.gpbs.util.ConnDB;




import?net.sf.json.JSONArray;

public?class?ajaxservlet?extends?HttpServlet?{

	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		ConnDB?conn?=?null;
		try?{
			conn?=?new?ConnDB（）;
		}?catch?（Exception?e1）?{
			//?TODO?Auto-generated?catch?block
			e1.printStackTrace（）;
		}
		response.setContentType（“text/html“）;
		response.setCharacterEncoding（“UTF-8“）;
		List?list?=?new?ArrayList（）;
		int?index?=?Integer.parseInt（request.getParameter（“index“））;
		//無字典
		if?（index?==?0）
			list.add（“無須選擇字典組“）;
		//數字字典
		else?if（index==1）
		{
			ResultSet?rs?=?null;
			try?{
				rs?=?conn.doQuery（SQLBean.sel_numRepDic）;
			}?catch?（SQLException?e1）?{
				//?TODO?Auto-generated?catch?block
				e1.printStackTrace（）;
			}
			try?{
				while?（rs.next（））?{
					String?value?=?rs.getString（“dicsetid“）?+?“:“+?rs.getString（“dicdescribe“）;
					list.add（value）;
				}
			}?catch?（SQLException?e）?{
				e.printStackTrace（）;
			}
		}
		//預留字符字典
		JSONArray?json?=?JSONArray.fromobject（list）;
		response.getWriter（）.print（json）;
	}

	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		this.doGet（request?response）;
	}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件???????1204??2017-11-08?18:45??xzgp\.classpath

?????文件????????285??2018-01-08?08:01??xzgp\.mymetadata

?????文件???????1955??2017-11-08?18:45??xzgp\.project

?????文件????????500??2017-11-08?15:27??xzgp\.settings\.jsdtscope

?????文件????????295??2017-11-08?18:45??xzgp\.settings\com.genuitec.eclipse.migration.prefs

?????文件????????364??2017-11-08?15:27??xzgp\.settings\org.eclipse.jdt.core.prefs

?????文件????????538??2017-11-08?18:45??xzgp\.settings\org.eclipse.wst.common.component

?????文件????????172??2017-11-08?18:45??xzgp\.settings\org.eclipse.wst.common.project.facet.core.prefs.xml

?????文件????????409??2017-11-08?18:45??xzgp\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2017-11-08?15:27??xzgp\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2017-11-08?15:27??xzgp\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件?????????37??2017-11-08?18:46??xzgp\.tern-project

?????文件???????1769??2018-01-07?20:06??xzgp\src\com\gpbs\action\ajaxservlet.java

?????文件???????1580??2017-11-08?21:53??xzgp\src\com\gpbs\action\ExcHandleAction.java

?????文件???????2256??2018-01-08?16:19??xzgp\src\com\gpbs\action\LogFilterAction.java

?????文件???????2035??2017-12-24?22:01??xzgp\src\com\gpbs\action\SysLoginAction.java

?????文件???????4776??2018-01-14?08:45??xzgp\src\com\gpbs\action\SysMainAction.java

?????文件??????24867??2018-01-14?22:47??xzgp\src\com\gpbs\action\SysReportAction.java

?????文件???????4203??2018-01-02?19:47??xzgp\src\com\gpbs\bean\SQLBean.java

?????文件???????1284??2017-11-08?15:43??xzgp\src\com\gpbs\bean\Tree.java

?????文件???????1163??2018-03-20?23:24??xzgp\src\com\gpbs\test\gptt.java

?????文件???????1259??2017-11-08?16:42??xzgp\src\com\gpbs\util\CommonUtil.java

?????文件???????6864??2018-02-25?13:19??xzgp\src\com\gpbs\util\ConnDB.java

?????文件??????10976??2017-12-30?07:31??xzgp\src\com\gpbs\util\DBUtil.java

?????文件???????1911??2017-12-30?08:05??xzgp\src\com\gpbs\util\EasyUIUtil.java

?????文件???????4326??2017-12-17?11:51??xzgp\src\com\gpbs\util\ExceptionHandlerUtil.java

?????文件???????4527??2018-01-07?09:36??xzgp\src\com\gpbs\util\HTMLUtil.java

?????文件??????45197??2018-01-16?21:09??xzgp\src\com\gpbs\util\ReportUtil.java

?????文件????????191??2018-01-10?22:20??xzgp\src\jdbc.properties

?????文件?????????40??2017-11-08?18:45??xzgp\src\meta-INF\MANIFEST.MF

............此處省略544個文件信息