package?servlet;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.*;

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

import?sun.management.jmxremote.ConnectorBootstrap;

public?class?AddServlet?extends?HttpServlet?{

	/**
	?*?Constructor?of?the?object.
	?*/
	public?AddServlet（）?{
		super（）;
	}

	/**
	?*?Destruction?of?the?servlet.?

	?*/
	public?void?destroy（）?{
		super.destroy（）;?//?Just?puts?“destroy“?string?in?log
		//?Put?your?code?here
	}

	/**
	?*?The?doGet?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?get.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		doPost（requestresponse）;
	}

	/**
	?*?The?doPost?method?of?the?servlet.?

	?*
	?*?This?method?is?called?when?a?form?has?its?tag?value?method?equals?to?post.
	?*?
	?*?@param?request?the?request?send?by?the?client?to?the?server
	?*?@param?response?the?response?send?by?the?server?to?the?client
	?*?@throws?ServletException?if?an?error?occurred
	?*?@throws?IOException?if?an?error?occurred
	?*/
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		String?id?=?new?String（request.getParameter（“id“）.getBytes（“ISO-8859-1“）“UTF-8“）;
		String?teamname?=?new?String（request.getParameter（“teamname“）.getBytes（“ISO-8859-1“）“UTF-8“）;
		String?belongsunion?=?new?String（request.getParameter（“belongsunion“）.getBytes（“ISO-8859-1“）“UTF-8“）;
		String?belongscity?=?new?String（request.getParameter（“belongscity“）.getBytes（“ISO-8859-1“）“UTF-8“）;
		String?championsum?=?new?String（request.getParameter（“championsum“）.getBytes（“ISO-8859-1“）“UTF-8“）;
		
		Connection?dbconn?=?null;
		Statement?stmt?=?null;
		ResultSet?rs?=?null;
		
		if（teamname.equals（““）?||?id.equals（““））{
			JOptionPane.showMessageDialog（null?“編號和隊(duì)名不能為空！！！““信息提示“JOptionPane.YES_NO_OPTION）;
			response.sendRedirect（“add.jsp“）;
		}
		else{
			try{				
				String?driver?=?“com.mysql.jdbc.Driver“;
				String?url?=?“jdbc:mysql://localhost:3306/nba“;
				String?user?=?“sa“;
				String?Password?=?“123“;
				Class.forName（driver）;
				dbconn?=?DriverManager.getConnection（url?user?Password）;
				stmt?=?dbconn.createStatement（）;
				String?sql1?=?“select?*?from?nbateam?where?TeamName=‘“+teamname+“‘“;
				String?sql2?=?“insert?into?nbateam?values（‘“+id+“‘‘“+teamname+“‘‘“+belongsunion+“‘‘“+belongscity+“‘‘“+championsum+“‘）“;
				rs?=?stmt.executeQuery（sql1）

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件??????????92??2014-08-31?21:14??user.sql
?????文件????????2347??2014-08-31?21:14??nbateam.sql
?????目錄???????????0??2014-08-31?21:04??MY_NBA\
?????文件?????????529??2014-08-31?21:04??MY_NBA\.classpath
?????目錄???????????0??2014-08-31?21:05??MY_NBA\.myeclipse\
?????文件?????????291??2014-08-31?21:04??MY_NBA\.mymetadata
?????文件????????1749??2014-08-31?21:04??MY_NBA\.project
?????目錄???????????0??2014-08-31?21:04??MY_NBA\.settings\
?????文件?????????500??2014-08-31?21:04??MY_NBA\.settings\.jsdtscope
?????文件?????????364??2014-08-31?21:04??MY_NBA\.settings\org.eclipse.jdt.core.prefs
?????文件?????????456??2014-08-31?21:04??MY_NBA\.settings\org.eclipse.wst.common.component
?????文件?????????252??2014-08-31?21:04??MY_NBA\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2014-08-31?21:04??MY_NBA\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2014-08-31?21:04??MY_NBA\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2014-08-31?21:04??MY_NBA\WebRoot\
?????目錄???????????0??2014-08-31?21:04??MY_NBA\WebRoot\meta-INF\
?????文件??????????36??2014-08-31?21:04??MY_NBA\WebRoot\meta-INF\MANIFEST.MF
?????目錄???????????0??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\
?????目錄???????????0??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\
?????目錄???????????0??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\servlet\
?????文件????????3985??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\servlet\AddServlet.class
?????文件????????4333??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\servlet\CheckServlet.class
?????文件????????3930??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\servlet\ConserveServlet.class
?????文件????????3361??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\servlet\DeleteServlet.class
?????文件????????4035??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\servlet\RegisterServlet.class
?????文件????????3965??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\classes\servlet\UpdateServlet.class
?????目錄???????????0??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\lib\
?????文件??????789885??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\lib\mysql-connector-java-5.1.18-bin.jar
?????文件????????2984??2014-08-31?21:04??MY_NBA\WebRoot\WEB-INF\web.xml
?????文件????????1611??2014-08-31?21:04??MY_NBA\WebRoot\add.jsp
?????文件????????2303??2014-08-31?21:04??MY_NBA\WebRoot\authcodeimage.jsp
............此處省略32個(gè)文件信息