package?com.jsict.demo;

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

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

import?com.jsict.entity.User;



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

	/**
	?*?@see?HttpServlet#doGet（HttpServletRequest?request?HttpServletResponse?response）
	?*/
	protected?void?doGet（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		//?TODO?Auto-generated?method?stub
		response.getWriter（）.append（“Served?at:?“）.append（request.getContextPath（））;
		
	}

	/**
	?*?@see?HttpServlet#doPost（HttpServletRequest?request?HttpServletResponse?response）
	?*/
	protected?void?doPost（HttpServletRequest?request?HttpServletResponse?response）?throws?ServletException?IOException?{
		//?TODO?Auto-generated?method?stub
		doGet（request?response）;
		request.setCharacterEncoding（“UTF-8“）;?
		String?name?=?request.getParameter（“userName“）;
		String?psw?=?request.getParameter（“pwd“）;
		boolean?is=false;
		try?{
			is?=?isExist（name?psw）;
		}?catch?（Exception?e）?{
			//?TODO:?handle?exception
		}

		if?（is）?{
			System.out.println（name+“成功“）;
			request.getSession（）.setAttribute（“username“?name）;
			request.getSession（）.setAttribute（“pass“?psw）;
			request.getSession（）.setAttribute（“email“user.getEmail（）?）;
			request.getSession（）.setAttribute（“tel“?user.getTel（））;
			request.getSession（）.setAttribute（“address“?user.getAddress（））;
			request.getSession（）.setAttribute（“age“?user.getAge（））;
			request.getSession（）.setAttribute（“sex“?user.getSex（））;

			
		}?else?{
			System.out.println（name+“失敗“）;
			request.getSession（）.setAttribute（“username“?“未登錄“）;
		}
		response.sendRedirect（“content.jsp“）;
		
	}

	
	
	private?boolean?isExist（String?nameString?pwd）?throws?Exception{
		Connection?connection?=?null;
		PreparedStatement?statement?=?null;
		ResultSet?rs?=?null;
		
		//1.加載JDBC驅動
		Class.forName（“com.mysql.jdbc.Driver“）;
		//2.與數據庫建立連接
		connection?=?DriverManager.getConnection（“jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8“?“root“?“root“）;
	????//3.創建Statement或PreparedStatement對象
		statement?=?connection.prepareStatement（“select?*?from?user?where?username=??and?password=?“）;
		statement.setString（1?name）;
		statement.setString（2?pwd）;
		
		rs?=?state

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????824??2017-11-11?14:44??.classpath
?????文件?????????906??2017-11-11?14:44??.project
?????目錄???????????0??2017-11-11?14:44??.settings\
?????文件?????????567??2017-11-11?14:44??.settings\.jsdtscope
?????文件?????????104??2017-11-11?14:44??.settings\org.eclipse.core.resources.prefs
?????文件?????????364??2017-11-11?14:44??.settings\org.eclipse.jdt.core.prefs
?????文件?????????117??2017-11-11?14:44??.settings\org.eclipse.jst.j2ee.ejb.annotations.xdoclet.prefs
?????文件?????????470??2017-11-11?14:44??.settings\org.eclipse.wst.common.component
?????文件?????????305??2017-11-11?14:44??.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2017-11-11?14:44??.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2017-11-11?14:44??.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2017-11-11?14:44??build\
?????目錄???????????0??2017-11-11?14:44??build\classes\
?????目錄???????????0??2017-11-11?14:44??build\classes\com\
?????目錄???????????0??2017-11-11?14:44??build\classes\com\jsict\
?????目錄???????????0??2017-11-11?14:44??build\classes\com\jsict\demo\
?????文件????????4721??2017-11-11?14:44??build\classes\com\jsict\demo\login.class
?????文件????????3249??2017-11-11?14:44??build\classes\com\jsict\demo\register.class
?????目錄???????????0??2017-11-11?14:44??build\classes\com\jsict\entity\
?????文件????????1816??2017-11-11?14:44??build\classes\com\jsict\entity\User.class
?????目錄???????????0??2017-11-11?14:44??src\
?????目錄???????????0??2017-11-11?14:44??src\com\
?????目錄???????????0??2017-11-11?14:44??src\com\jsict\
?????目錄???????????0??2017-11-11?14:44??src\com\jsict\demo\
?????文件????????3899??2017-11-11?14:44??src\com\jsict\demo\login.java
?????文件????????2819??2017-11-11?14:44??src\com\jsict\demo\register.java
?????目錄???????????0??2017-11-11?14:44??src\com\jsict\entity\
?????文件????????1170??2017-11-11?14:44??src\com\jsict\entity\User.java
?????目錄???????????0??2017-11-11?14:44??WebContent\
?????文件?????????799??2017-11-11?14:44??WebContent\content.jsp
?????文件????????1187??2017-11-11?14:44??WebContent\login.jsp
............此處省略8個文件信息