package?com.fit.ajax;
import?java.io.IOException;
import?java.io.PrintWriter;
import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.ResultSet;
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?AjaxServlet?extends?HttpServlet?{

	/**
	?*?Constructor?of?the?object.
	?*/
	public?AjaxServlet（）?{
		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?{
??????????System.out.println（“sdfsdfsdfsdf“）;
		???request.setCharacterEncoding（“gb2312“）;
???????????response.setHeader（“Content-Type““text/html;?charset=gb2312“）;
???????????try
???????????{
????????	??????Class.forName（“com.microsoft.jdbc.sqlserver.SQLServerDriver“）;
				??String?URL?=?“jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=mall;user=sa;password=sa“;
				??Connection?conn?=?DriverManager.getConnection（URL）;
				??Statement?stmt?=?conn.createStatement（）;
??????????????String?username=request.getParameter（“username“）;
??????????????System.out.print（username）;
??????????????String?sql=“select?*?from?custom?where?c_name=‘“+username+“‘“;
//??????????????ConDB?con=new?ConDB（）;
//??????		??String?message?=““;
//??????		??ResultSet?rs=con.SelectDB（sql）;
??????????????String?message=““;
??????????????ResultSet?rs=stmt.executeQuery（sql）;
??????????????if（rs.next（））
??????????????{
????????????	??message=“用戶名已存在！“;
??????????????}
??????????????else
??????????????{
????????????	??message=“用戶名可用！“;
??????????????}
??????????????PrintWriter?out=response.getWriter（）;
??????		??out.print（message）;
???????????}
???????????catch（Exception?e）
???????????{
????????	???e.printStackTrace（）;
???????????}
	}

	/**
	?*?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?{
		???doGet（requestresponse）;
	}

	/**
	?*?Initialization?of?t

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

?????文件????????552??2010-03-21?19:50??Mall\.classpath

?????文件????????285??2010-03-21?19:50??Mall\.mymetadata

?????文件???????1222??2010-03-21?19:50??Mall\.project

?????文件?????????66??2010-03-21?19:50??Mall\.settings\CVS\Entries

?????文件?????????16??2010-03-21?19:50??Mall\.settings\CVS\Repository

?????文件?????????49??2010-03-21?19:50??Mall\.settings\CVS\Root

?????文件????????157??2010-03-21?19:50??Mall\.settings\org.eclipse.core.resources.prefs

?????文件????????190??2010-03-21?19:50??Mall\CVS\Entries

?????文件??????????6??2010-03-21?19:50??Mall\CVS\Repository

?????文件?????????49??2010-03-21?19:50??Mall\CVS\Root

?????文件????????139??2010-03-21?19:50??Mall\Database\CVS\Entries

?????文件?????????15??2010-03-21?19:50??Mall\Database\CVS\Repository

?????文件?????????49??2010-03-21?19:50??Mall\Database\CVS\Root

?????文件?????786432??2010-03-21?19:50??Mall\Database\mall.mdf

?????文件???????6016??2010-03-21?19:50??Mall\Database\mall.sql

?????文件?????516096??2010-03-21?19:50??Mall\Database\mall_log.LDF

?????文件?????????11??2010-03-21?19:50??Mall\src\com\CVS\Entries

?????文件?????????14??2010-03-21?19:50??Mall\src\com\CVS\Repository

?????文件?????????49??2010-03-21?19:50??Mall\src\com\CVS\Root

?????文件???????3172??2010-03-21?19:50??Mall\src\com\fit\ajax\AjaxServlet.java

?????文件???????3104??2010-03-21?19:50??Mall\src\com\fit\ajax\ajaxServletOne.java

?????文件????????147??2010-03-21?19:50??Mall\src\com\fit\ajax\CVS\Entries

?????文件?????????23??2010-03-21?19:50??Mall\src\com\fit\ajax\CVS\Repository

?????文件?????????49??2010-03-21?19:50??Mall\src\com\fit\ajax\CVS\Root

?????文件??????????0??2010-03-21?19:50??Mall\src\com\fit\ajax\readme.txt

?????文件?????????83??2010-03-21?19:50??Mall\src\com\fit\CVS\Entries

?????文件?????????18??2010-03-21?19:50??Mall\src\com\fit\CVS\Repository

?????文件?????????49??2010-03-21?19:50??Mall\src\com\fit\CVS\Root

?????文件???????1651??2010-03-21?19:50??Mall\src\com\fit\dao\BankAddDAO.java

?????文件???????2319??2010-03-21?19:50??Mall\src\com\fit\dao\BankBasicDAO.java

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