package?classroom.servlet;


import?java.io.IOException;
import?java.sql.SQLException;

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

import?mysql.mysql;

public?class?AddroomServlet?extends?HttpServlet
{
?????@Override
????protected?void?doPost（HttpServletRequest?req?HttpServletResponse?resp）
????		throws?ServletException?IOException
????{
????	//?TODO?Auto-generated?method?stub
????	String?week?=?req.getParameter（“week“）;
????	String?address?=?req.getParameter（“address“）;
????	String?time?=?req.getParameter（“time“）;
????	String?roomnumber?=?req.getParameter（“roomnumber“）;
????	String?spacenumber?=?req.getParameter（“spacenumber“）;
????	String?numbers?=?req.getParameter（“numbers“）;
????	
????	if（spacenumber.equals（““）||numbers.equals（““））
????	{
????		req.getRequestDispatcher（“reminding9.jsp“）.forward（req?resp）;			
		}
????	else
????	{
????		mysql?m?=?new?mysql（）;
			m.connectMySQL（）;
			String?sql?=?“insert?into?room?values（‘“+week+“‘‘“+address+“‘‘“+time+“‘‘“+roomnumber+“‘‘“+spacenumber+“‘‘“+numbers+“‘）“;
			System.out.println（sql）;
			try
			{
				?m.excute（sql）;			
					
				req.getRequestDispatcher（“reminding8.jsp“）.forward（req?resp）;
			}?
			catch?（SQLException?e）
			{
				//?TODO?Auto-generated?catch?block
				
				System.out.println（“數(shù)據(jù)庫異常“）;	
			}
			m.closeMySQL（）;
????	}
????}
}

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

?????文件????????529??2012-04-09?21:17??FinRoom\.classpath

?????文件????????294??2012-04-09?21:17??FinRoom\.mymetadata

?????文件???????1750??2012-04-19?16:01??FinRoom\.project

?????文件????????493??2012-04-09?21:17??FinRoom\.settings\.jsdtscope

?????文件????????395??2012-04-09?21:17??FinRoom\.settings\org.eclipse.jdt.core.prefs

?????文件????????459??2012-04-09?21:17??FinRoom\.settings\org.eclipse.wst.common.component

?????文件????????252??2012-04-09?21:17??FinRoom\.settings\org.eclipse.wst.common.project.facet.core.xml

?????文件?????????49??2012-04-09?21:17??FinRoom\.settings\org.eclipse.wst.jsdt.ui.superType.container

?????文件??????????6??2012-04-09?21:17??FinRoom\.settings\org.eclipse.wst.jsdt.ui.superType.name

?????文件???????1509??2012-04-23?12:34??FinRoom\src\classroom\servlet\AddroomServlet.java

?????文件???????1255??2012-04-21?17:01??FinRoom\src\classroom\servlet\AdminlogServlet.java

?????文件????????881??2012-04-21?16:30??FinRoom\src\classroom\servlet\CleanroomServlet.java

?????文件????????984??2012-04-21?18:51??FinRoom\src\classroom\servlet\DelroomServlet.java

?????文件???????1004??2012-04-21?17:47??FinRoom\src\classroom\servlet\DelstuServlet.java

?????文件???????1237??2012-04-23?23:45??FinRoom\src\classroom\servlet\LoginServlet.java

?????文件????????966??2012-04-21?18:21??FinRoom\src\classroom\servlet\MainServlet.java

?????文件???????1553??2012-04-23?12:34??FinRoom\src\classroom\servlet\RegistServlet.java

?????文件???????2636??2012-04-24?08:36??FinRoom\src\classroom\servlet\SelectingServlet.java

?????文件???????2432??2012-04-12?22:51??FinRoom\src\mysql\mysql.java

?????文件???????3984??2012-04-23?21:41??FinRoom\src\show\room.java

?????文件???????2034??2012-04-21?16:19??FinRoom\src\show\student.java

?????文件???????2852??2012-04-24?09:23??FinRoom\WebRoot\addroom.jsp

?????文件???????1440??2012-04-24?09:40??FinRoom\WebRoot\adminlogin.jsp

?????文件???????1297??2012-04-24?09:23??FinRoom\WebRoot\adminop.jsp

?????文件??????22283??2011-11-07?10:42??FinRoom\WebRoot\bkp.jpg

?????文件???????1591??2012-04-24?09:24??FinRoom\WebRoot\index.jsp

?????文件???????2100??2012-04-24?09:36??FinRoom\WebRoot\main.jsp

?????文件?????????36??2012-04-09?21:17??FinRoom\WebRoot\meta-INF\MANIFEST.MF

?????文件???????2256??2012-04-24?09:24??FinRoom\WebRoot\regist.jsp

?????文件???????1001??2012-04-24?09:24??FinRoom\WebRoot\reminding.jsp

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