package?servlet;

import?java.io.IOException;
import?java.sql.*;
import?javax.servlet.ServletException;
import?javax.servlet.annotation.WebServlet;
import?javax.servlet.http.HttpServlet;
import?javax.servlet.http.HttpServletRequest;
import?javax.servlet.http.HttpServletResponse;

@WebServlet（“/LoginServlet“）
public?class?MyServlet?extends?HttpServlet?{
?
??Connection?conn;
??String?url?=?“jdbc:mysql://localhost:3306/TestDB“;
??@Override
??public?void?init（）?throws?ServletException?{
????????super.init（）;
??try{
????????Class.forName（“com.mysql.jdbc.Driver“）;
??}catch（ClassNotFoundException?e）{
?????System.out.println（e）;
??}
?}

?@Override
?public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
???throws?ServletException?IOException?{
?????
????????response.setContentType（“text/html“）;
????????request.setCharacterEncoding（“UTF-8“）;
????????response.setCharacterEncoding（“UTF-8“）;
????????String?username?=?request.getParameter（“username“）;
????????String?password?=?request.getParameter（“password“）;
????????String?message?=?null;?
????????request.getSession（）.setAttribute（“message“message）;
???try?{
????????conn?=?DriverManager.getConnection（url?“root“?“root“）;
????????Statement?stmt?=?conn.createStatement（）;?//?獲取Statement
????????String?sql?=?“SELECT?*?FROM?user?WHERE?name=‘“?+?username
	?????+?“‘?AND?pwd=‘“?+?password?+?“‘“;?//?查詢用戶信息的SQL語句
	???ResultSet?rs?=?stmt.executeQuery（sql）;?//?執行查詢
	???if?（rs.next（））?{?//?有數據庫中存在該用戶
?????????????request.getSession（）.setAttribute（“username“?username）;
?????????????rs.close（）;
?????????????stmt.close（）;
?????????????conn.close（）;
?????????????response.sendRedirect（“success.jsp“）;
???????????}
???????????else{
???????????????message?=?“用戶名或密碼有誤“;
???????????????request.getSession（）.setAttribute（“message“message）;
???????????????response.sendRedirect（“login.jsp“）;
????????????}
???}?catch?（SQLException?e）?{
??????e.printStackTrace（）;
?????}
???}
?}

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

?????文件???????3507??2014-05-09?10:54??LoginJDBCTest\build.xml

?????文件???????2598??2014-05-09?10:53??LoginJDBCTest\nbproject\ant-deploy.xml

?????文件??????81541??2014-05-09?10:54??LoginJDBCTest\nbproject\build-impl.xml

?????文件????????473??2014-05-09?10:54??LoginJDBCTest\nbproject\genfiles.properties

?????文件????????456??2014-05-09?10:53??LoginJDBCTest\nbproject\private\private.properties

?????文件????????245??2014-05-09?10:54??LoginJDBCTest\nbproject\private\private.xml

?????文件???????3434??2014-05-09?10:54??LoginJDBCTest\nbproject\project.properties

?????文件????????919??2014-05-09?10:54??LoginJDBCTest\nbproject\project.xml

?????文件?????????25??2014-05-09?10:53??LoginJDBCTest\src\conf\MANIFEST.MF

?????文件???????2077??2014-05-09?10:53??LoginJDBCTest\src\java\servlet\MyServlet.java

?????文件????????311??2014-05-09?10:53??LoginJDBCTest\web\index.jsp

?????文件???????1300??2014-05-09?10:53??LoginJDBCTest\web\login.jsp

?????文件?????????94??2014-05-09?10:54??LoginJDBCTest\web\meta-INF\context.xml

?????文件????????794??2014-05-09?10:53??LoginJDBCTest\web\success.jsp

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\src\java\servlet

?????目錄??????????0??2014-05-09?10:54??LoginJDBCTest\nbproject\private

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\src\conf

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\src\java

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\web\meta-INF

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\web\WEB-INF

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\nbproject

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\src

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\test

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest\web

?????目錄??????????0??2014-05-09?10:53??LoginJDBCTest

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

????????????????97774????????????????????25