verify.jsp

来自「课程设计中的在线书店源码」· JSP 代码 · 共 27 行

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<%
	String user=request.getParameter("user");
	String pw=request.getParameter("pw");
	String sql="select * from admin where name='"+user+"' and password='"+pw+"'";
	ResultSet rs=conn.executeQuery(sql);
	if(rs.next())
	{
		rs.close();
		conn.close();
		session.setAttribute("admin","ok");
%>
	<jsp:forward page="manage.jsp"/>
<%
	}
	else
	{
		rs.close();
		conn.close();
%>
	<jsp:forward page="login.jsp">
		<jsp:param name="warning" value="对不起，您的用户名或密码不正确"/>
	</jsp:forward>
<%
	}
%>