<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<jsp:setProperty name="conn" property="connStr" value="jdbc:odbc:user"/>
<%
	session.setMaxInactiveInterval(-1);
	//獲取用戶名
	String username=request.getParameter("username");
	//將獲得的用戶名進行內碼轉換，防止中文亂碼問題
	username=new String(username.getBytes("8859_1"));
	//獲取口令
	String password=request.getParameter("password");
	//對口令進行編碼轉換
	password=new String(password.getBytes("8859_1"));
	ResultSet  rs=null;
	String sql="select * from user where name='"+username+"' and password='"+password+"'";
	rs = conn.executeQuery(sql);
	if(rs.next())
	{
		session.setAttribute("loginId",rs.getString("id"));
		session.setAttribute("username",rs.getString("name"));
		rs.close();
		conn.close();
		response.sendRedirect("home.jsp");
	}
	else   	
	{
		rs.close();
		conn.close();
		response.sendRedirect("login.htm");
	}
%>