package?com.jsp.servlet;

import?java.io.IOException;
import?java.io.PrintWriter;

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

import?java.sql.*;
public?class?Login?extends?javax.servlet.http.HttpServlet?implements?javax.servlet.Servlet{
	String?StrCon=““;
	Connection?con=null;
	Statement?stmt=null;
	ResultSet?rs=null;
	
	public?Login（）?{
		super（）;
	}

	public?void?destroy（）?{
		super.destroy（）;?
	}

	public?void?doGet（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{

		response.setContentType（“text/html“）;
		PrintWriter?out?=?response.getWriter（）;
		out
				.println（““）;
		out.println（““）;
		out.println（“??tle>A?Servlettle>“）;
		out.println（“??“）;
		out.print（“????This?is?“）;
		out.print（this.getClass（））;
		out.println（“?using?the?GET?method“）;
		out.println（“??“）;
		out.println（““）;
		out.flush（）;
		out.close（）;
	}
	public?void?doPost（HttpServletRequest?request?HttpServletResponse?response）
			throws?ServletException?IOException?{
		request.setCharacterEncoding（“GB2312“）;
		response.setContentType（“text/html;charset=GB2312“）;
		PrintWriter?out?=?response.getWriter（）;
		HttpSession?session?=request.getSession（）;
		String?username=（String）request.getParameter（“username“）;
		String?password=（String）request.getParameter（“password“）;
		String?sql=“select?count（*）?from?user2?where?username=‘“+username+“‘a(chǎn)nd?userpwd=‘“+password+“‘“;
		try{
			int?message=queryUser（sql）;
			if（message==1）{
				System.out.println（message）;
				session.setAttribute（“username“?username）;
				request.getRequestDispatcher（“/index.jsp“）.forward（request?response）;}
			else{
				session.setAttribute（“username“?username）;
				request.getRequestDispatcher（“/error.jsp“）.forward（request?response）;}
			
			}catch（Exception?e）{
				e.printStackTrace（）;
		}
		
	}

	public?void?init（）?throws?ServletException?{
		try{
			//加載JDBC
			Class.forName（“com.mysql.jdbc.Driver“）;
		}catch（ClassNotFoundException?e）{
			e.printStackTrace（）;
		}
	}
public?int?queryUser（String?sql）?throws?Exception{
	int?message=0;
	try{
		con=DriverManager.getConnection（“jdbc:mysql://localhost:3306/test““root““123“）;
		stmt=con.createStatement（）;
		rs=stmt.executeQuery（sql）;
		if（rs.next（））{
			message=rs.getInt（1）;
			
		}
	}catch（Exception?e）{
		e.printStackTrace（）;
	}
	return?message;
}

}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-07-01?21:35??jspdemo2\
?????文件?????????456??2012-03-18?09:25??jspdemo2\.classpath
?????目錄???????????0??2004-01-01?06:27??jspdemo2\.myeclipse\
?????文件?????????297??2013-06-19?14:34??jspdemo2\.mymetadata
?????文件????????1414??2004-01-01?03:13??jspdemo2\.project
?????目錄???????????0??2013-07-01?21:05??jspdemo2\.settings\
?????文件?????????500??2004-01-01?03:13??jspdemo2\.settings\.jsdtscope
?????文件??????????49??2004-01-01?03:13??jspdemo2\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2004-01-01?03:13??jspdemo2\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????文件??????340480??2013-07-01?21:30??jspdemo2\JSP數(shù)據(jù)庫.doc
?????文件?????????202??2012-03-18?09:28??jspdemo2\read?me.txt
?????目錄???????????0??2013-07-01?21:05??jspdemo2\src\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\src\com\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\src\com\jsp\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\src\com\jsp\servlet\
?????文件????????2701??2013-06-19?16:11??jspdemo2\src\com\jsp\servlet\Login.java
?????目錄???????????0??2013-07-01?21:05??jspdemo2\src\com\wind\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\src\com\wind\util\
?????文件????????1351??2013-06-19?17:48??jspdemo2\src\com\wind\util\DbUtil.java
?????目錄???????????0??2013-07-01?21:05??jspdemo2\WebRoot\
?????文件????????1385??2013-06-19?16:41??jspdemo2\WebRoot\addStu.jsp
?????文件????????2709??2013-06-19?17:23??jspdemo2\WebRoot\index.jsp
?????文件????????1183??2013-06-19?15:52??jspdemo2\WebRoot\login.jsp
?????目錄???????????0??2013-07-01?21:05??jspdemo2\WebRoot\meta-INF\
?????文件??????????39??2012-03-18?09:22??jspdemo2\WebRoot\meta-INF\MANIFEST.MF
?????文件?????????910??2013-06-19?17:55??jspdemo2\WebRoot\updateStu.jsp
?????目錄???????????0??2013-07-01?21:05??jspdemo2\WebRoot\WEB-INF\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\WebRoot\WEB-INF\classes\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\WebRoot\WEB-INF\classes\com\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\WebRoot\WEB-INF\classes\com\jsp\
?????目錄???????????0??2013-07-01?21:05??jspdemo2\WebRoot\WEB-INF\classes\com\jsp\servlet\
............此處省略7個文件信息