package?com.busSystem.core;

import?java.io.IOException;
import?java.sql.Connection;
import?java.sql.Statement;
import?java.sql.ResultSet;

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

public?class?ConfirmServlet?extends?HttpServlet?{

	/**
	?*?Constructor?of?the?object.
	?*/
	public?ConfirmServlet（）?{
		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?{
		login（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?{
		login（requestresponse）;
	}

	/**
	?*?Initialization?of?the?servlet.?

	?*
	?*?@throws?ServletException?if?an?error?occure
	?*/
	public?void?init（）?throws?ServletException?{
		//?Put?your?code?here
	}
	
	private?void?login（HttpServletRequest?requestHttpServletResponse?response）?{
		Connection?conn?=?null;
		Statement?stmt?=?null;
		ResultSet?rs?=?null;
		HttpSession?session?=?request.getSession（true）;//如果用戶session為空，重新分配一個新的session給用戶
		DBConnection2?db?=?DBConnection2.getInstance（）;
		String?adminname?=?request.getParameter（“adminname“）?==?null???““?:?request.getParameter（“adminname“）;
		adminname?=?exChange（adminname）;//字符串亂碼處理
		String?password?=?request.getParameter（“password“）?==?null???““?:?request.getParameter（“password“）;
		password?=?exChange（password）;//字符串亂碼處理
		String?sql?=?““;
		String?rand?=?（String）?session.getAttribute（“rand“）;
		String?input?=?request.getParameter（“vaild“）;
		int?n?=?0;
		try?{
			conn?=?db.getConnection（）;
			stmt?=?conn.createStatement（）;
			sql?=?“select?*?from?administrator?where?adminiID?=?‘“+adminname+“‘?and?adminipassword?=?‘“+password+“‘“;
			rs?=?stmt.executeQuery（sql）;
			if?（rs.next（）?&&?rs?!=?null）?{
				n++;
			}
			if?（n?>?0?&&?input.equals（rand））?{
				session.setAttribute（“adminname“?adminna

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

?????文件??????72897??2007-05-15?13:04??bus.rar

?????文件?????469513??2007-06-09?22:05??busSystem.rar

-----------?---------??----------?-----??----

???????????????542410????????????????????2