package?Action;

import?linkDatabase.Conn;
import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.ResultSet;
import?javax.servlet.ServletException;
import?javax.servlet.http.*;

public?class?dormAction?extends?HttpServlet
{

????public?dormAction（）
????{
????}

????public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
????????throws?ServletException?IOException
????{
????????response.setContentType（“text/html;charset=UTF-8“）;
????????PrintWriter?out?=?response.getWriter（）;
????????String?basepath?=?““;
????????String?hiddensql?=?““;
????????String?dorm?=?““;
????????String?boss?=?““;
????????String?teleph?=?““;
????????String?num?=?““;
????????basepath?=?request.getParameter（“basePath“）;
????????hiddensql?=?request.getParameter（“hiddensql“）;
????????dorm?=?request.getParameter（“dorm“）;
????????boss?=request.getParameter（“boss“）;
????????teleph?=?request.getParameter（“teleph“）;
????????num?=?request.getParameter（“num“）;
????????if（hiddensql.equals（“select“））
????????{
????????????String?sqls?=?“select?*?from?dorm“;
????????????if（dorm?!=?““）
????????????{
????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?where?dorm=‘“）.append（dorm）.append（“‘“）.toString（）;
????????????????if（boss?!=?““）
????????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?and?dboss=‘“）.append（boss）.append（“‘“）.toString（）;
????????????????if（teleph?!=?““）
????????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?and?dtelephone=‘“）.append（teleph）.append（“‘“）.toString（）;
????????????????if（num?!=?““）
????????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?and?dpeoplenum=‘“）.append（num）.append（“‘“）.toString（）;
????????????}?else
????????????if（boss?!=?““）
????????????{
????????????	String?boss2?=new?String（boss.getBytes（“ISO-8859-1“）“UTF-8“）;
????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?where?dboss=‘“）.append（boss2）.append（“‘“）.toString（）;
????????????????if（teleph?!=?““）
????????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?and?dtelephone=‘“）.append（teleph）.append（“‘“）.toString（）;
????????????????if（num?!=?““）
????????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?and?dpeoplenum=‘“）.append（num）.append（“‘“）.toString（）;
????????????}?else
????????????if（teleph?!=?““）
????????????{
????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?where?dtelephone=‘“）.append（teleph）.append（“‘“）.toString（）;
????????????????if（num?!=?““）
????????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?and?dpeoplenum=‘“）.append（num）.append（“‘“）.toString（）;
????????????}?else
????????????if（num?!=?““）
????????????????sqls?=?（new?StringBuilder（String.valueOf（sqls）））.append（“?where?dpeoplenum=‘“）.append（num）.append（“‘“）.toString（）;
????????????try
????????????{
????????????????Conn?conn?=?new?Conn（）;
????

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

?????文件????????433??2010-03-05?22:43??宿舍管理系統\DormManage\.classpath

?????文件????????303??2010-03-04?08:42??宿舍管理系統\DormManage\.mymetadata

?????文件???????1416??2010-03-04?08:57??宿舍管理系統\DormManage\.project

?????文件????????500??2010-03-04?08:42??宿舍管理系統\DormManage\.settings\.jsdtscope

?????文件????????334??2010-03-04?08:42??宿舍管理系統\DormManage\.settings\org.eclipse.jdt.core.prefs

?????文件?????????49??2010-03-04?08:42??宿舍管理系統\DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2010-03-04?08:42??宿舍管理系統\DormManage\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????6013??2010-03-05?13:59??宿舍管理系統\DormManage\src\Action\dormAction.java

?????文件???????1802??2010-03-05?08:32??宿舍管理系統\DormManage\src\Action\dormUpdateAction.java

?????文件???????6071??2010-03-05?14:16??宿舍管理系統\DormManage\src\Action\hygieneAction.java

?????文件???????1838??2010-03-05?08:31??宿舍管理系統\DormManage\src\Action\hygieneUpdateAction.java

?????文件???????2059??2010-03-04?09:53??宿舍管理系統\DormManage\src\Action\indexAction.java

?????文件???????7472??2010-03-05?14:05??宿舍管理系統\DormManage\src\Action\studentAction.java

?????文件???????1739??2010-03-05?08:31??宿舍管理系統\DormManage\src\Action\studentUpdateAction.java

?????文件???????6168??2010-03-05?15:13??宿舍管理系統\DormManage\src\Action\troubleAction.java

?????文件???????1907??2010-03-05?08:30??宿舍管理系統\DormManage\src\Action\troubleUpdateAction.java

?????文件???????3949??2010-03-05?08:21??宿舍管理系統\DormManage\src\Action\userAction.java

?????文件???????1818??2010-03-05?08:26??宿舍管理系統\DormManage\src\Action\userUpdateAction.java

?????文件???????2322??2010-03-05?22:36??宿舍管理系統\DormManage\src\filters\ExampleFilter.class

?????文件???????4142??2010-03-05?22:36??宿舍管理系統\DormManage\src\filters\ExampleFilter.java

?????文件???????5859??2010-03-05?22:36??宿舍管理系統\DormManage\src\filters\RequestDumperFilter.class

?????文件???????6755??2010-03-05?22:36??宿舍管理系統\DormManage\src\filters\RequestDumperFilter.java

?????文件???????1943??2010-03-05?22:36??宿舍管理系統\DormManage\src\filters\SetCharacterEncodingFilter.class

?????文件???????5739??2010-03-05?22:36??宿舍管理系統\DormManage\src\filters\SetCharacterEncodingFilter.java

?????文件???????1973??2010-03-05?13:00??宿舍管理系統\DormManage\src\linkDatabase\Conn.java

?????文件???????1730??2010-03-04?09:41??宿舍管理系統\DormManage\WebRoot\index.jsp

?????文件???????2548??2010-03-05?13:31??宿舍管理系統\DormManage\WebRoot\main\dorm.jsp

?????文件???????2767??2010-03-05?09:22??宿舍管理系統\DormManage\WebRoot\main\dormUpdate.jsp

?????文件???????2415??2010-03-04?08:49??宿舍管理系統\DormManage\WebRoot\main\hygiene.jsp

?????文件???????2832??2010-03-05?14:15??宿舍管理系統\DormManage\WebRoot\main\hygieneUpdate.jsp

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