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;
}

}