package?zhaoli;

import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.SQLException;
import?java.sql.Statement;

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


public?class?RegisterServlet?extends?HttpServlet?{

	/**
	?*?Constructor?of?the?object.
	?*/
	public?RegisterServlet（）?{
		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?{

		Connection?cn?=?null;
		Statement?st?=?null;

		String?url?=?“jdbc:sqlserver://localhost;database=Users;User=sa;password=mis_123“;
		
		try?{
			cn?=?DriverManager.getConnection（url）;
			st?=?cn.createStatement（）;
			String?userName?=?new?String（request.getParameter（“username“）.getBytes（“iso-8859-1“）“utf-8“）;
			String?password?=?new?String（request.getParameter（“password“）.getBytes（“iso-8859-1“）“utf-8“）;
			String?realname?=?new?String（request.getParameter（“realname“）.getBytes（“iso-8859-1“）“utf-8“）;
			String?gender?=?new?String（request.getParameter（“gender“）.getBytes（“iso-8859-1“）“utf-8“）;
			String?email?=?new?String（request.getParameter（“email“）.getBytes（“iso-8859-1“）“utf-8“）;
			String?sql?=?“insert?into?Users?values（‘“?
						+?userName?+?“‘‘“?+?password?+?“‘‘“?+?realname?+“‘‘“?+?gender?+“‘‘“?
						+?email?+“‘）“;
			st.executeUpdate（sql）;
			
			System.out.println（“OK“）;
			
		}?catch?（SQLException?e）?{
			System.out.println（e.getMessage（））;
		}
		finally{
			if?（st!=null）	try?{st.close（）;}?catch?（SQLException?e）?{}
			if?（cn!=null）	try?{cn.close（）;}?catch?（SQLException?e）?{}
		}
		
		
		response.setContentType（“text/html“）;
		PrintWriter?out?=?response.getWriter（）;
		out.println（“