package?manager;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.CallableStatement;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;

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

/**
?*?Servlet?implementation?class?Addclass
?*/
@WebServlet（“/Addclass“）
public?class?Addclass?extends?HttpServlet?{
	private?static?final?long?serialVersionUID?=?1L;
???????
????/**
?????*?@see?HttpServlet#HttpServlet（）
?????*/
????public?Addclass（）?{
????????super（）;
????????//?TODO?Auto-generated?constructor?stub
????}

	/**
	?*?@see?HttpServlet#doPost（HttpServletRequest?request?HttpServletResponse?response）
	?*/
	protected?void?doPost（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		//?TODO?Auto-generated?method?stub
PrintWriter?out=response.getWriter（）;
		
		request.setCharacterEncoding（“utf-8“）;
	???//?response.setContentType（“text/javascript“）;
	
		String?classid?=?request.getParameter（“classid“）;
	
	
		String?mid?=?request.getParameter（“mid“）;
	
	

	
?
			Connection?con;
			CallableStatement?cs;
			ResultSet?rs;
			
			//String?bname=request.getParameter（“bname“）;???

			try?{
				Class.forName（“com.mysql.jdbc.Driver“）;
				/*?下載JDBC數據庫驅動程序，??把驅動包放到項目的?WEB-INF/lib?下面???????????*/
			}?catch?（Exception?e）?{
				out.println（“缺少數據庫驅動程序?“）;
			}
			try?{
				String?uri=“jdbc:mysql://localhost/edu?“+
	????????????????????“user=root&password=123456&characterEncoding=gbk“;

				con?=?DriverManager.getConnection（uri）;
				
				cs?=?con.prepareCall（“{call?addclass（??）}“）;//調用存儲過程searchbook進行模糊查詢
				cs.setString（1classid）;//向存儲過程中的參數進行傳值
				cs.setString（2mid）;
				cs.executeUpdate（）;
				//rs=cs.executeQuery（）;
				response.sendRedirect（“addclass.jsp“）;
				
				
				//boolean?m=rs.next（）;
				/*if（m）
				{
					
					response.sendRedirect（“addclass.jsp“）;
					
				}
				
					//response.sendRedirect（“addclass.jsp“）;
				else?{
					out.print（“ript>alert（‘輸入錯誤，請重新輸入‘）ript>“）;
				}
			*/
			}catch?（SQLException?e）?{
				out.print（e）;
			}
		
		}
	

	}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2019-01-09?20:57??教務管理系統\
?????目錄???????????0??2019-01-01?20:09??教務管理系統\Education\
?????文件?????????815??2018-12-29?11:25??教務管理系統\Education\.classpath
?????文件?????????909??2018-12-25?14:23??教務管理系統\Education\.project
?????目錄???????????0??2019-01-01?20:09??教務管理系統\Education\.settings\
?????文件?????????567??2018-12-25?14:23??教務管理系統\Education\.settings\.jsdtscope
?????文件?????????298??2018-12-27?10:49??教務管理系統\Education\.settings\org.eclipse.core.resources.prefs
?????文件??????????52??2018-12-26?10:21??教務管理系統\Education\.settings\org.eclipse.core.runtime.prefs
?????文件?????????358??2018-12-25?14:23??教務管理系統\Education\.settings\org.eclipse.jdt.core.prefs
?????文件?????????479??2018-12-25?14:23??教務管理系統\Education\.settings\org.eclipse.wst.common.component
?????文件?????????343??2018-12-25?14:23??教務管理系統\Education\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2018-12-25?14:23??教務管理系統\Education\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2018-12-25?14:23??教務管理系統\Education\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2019-01-01?20:09??教務管理系統\Education\WebContent\
?????目錄???????????0??2019-01-01?20:09??教務管理系統\Education\WebContent\meta-INF\
?????文件??????????39??2018-12-25?14:23??教務管理系統\Education\WebContent\meta-INF\MANIFEST.MF
?????目錄???????????0??2019-01-01?20:09??教務管理系統\Education\WebContent\WEB-INF\
?????目錄???????????0??2019-01-01?20:09??教務管理系統\Education\WebContent\WEB-INF\lib\
?????文件??????846263??2018-11-28?15:38??教務管理系統\Education\WebContent\WEB-INF\lib\mysql-connector-java-5.1.24-bin.jar
?????文件????????1983??2018-12-27?18:06??教務管理系統\Education\WebContent\addclass.jsp
?????文件????????2232??2018-12-27?18:06??教務管理系統\Education\WebContent\addcou.jsp
?????文件????????1926??2018-12-27?18:06??教務管理系統\Education\WebContent\addmajor.jsp
?????文件????????2757??2018-12-27?18:06??教務管理系統\Education\WebContent\addstu.jsp
?????文件????????2103??2018-12-27?18:06??教務管理系統\Education\WebContent\addtea.jsp
?????文件????????1990??2018-12-27?23:08??教務管理系統\Education\WebContent\assign.jsp
?????文件????????2303??2018-12-27?23:32??教務管理系統\Education\WebContent\choice.jsp
?????文件????????2714??2018-12-27?10:40??教務管理系統\Education\WebContent\evaluate.jsp
?????文件?????????872??2018-12-28?18:44??教務管理系統\Education\WebContent\index.jsp
?????文件?????????688??2018-12-27?10:51??教務管理系統\Education\WebContent\index2.jsp
?????文件?????????717??2018-12-26?15:26??教務管理系統\Education\WebContent\index3.jsp
?????文件????????2624??2018-12-27?12:58??教務管理系統\Education\WebContent\inputgra.jsp
............此處省略31個文件信息