user_deal.jsp

网站名称：网上商店 编写语言：JSP 后台数据库：oracle 运行环境平台：安装windows XP sp2 的PC机； 安装了oracle数据库； 安装了Tomcat 5.5 用户

<%@ page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="db" class="wssd.connectDB" />
<%
	String name = request.getParameter("user");
	String psw = request.getParameter("psw");
	ResultSet rs = null;
	try
	{
		String sql = "select * from wssd_adminuser where username = '"+name+"' and password = '"+psw+"'";
		rs = db.executeQuery(sql);
		if(rs.next())
		{
			session.setAttribute("adminname",name);
			session.setAttribute("priority",rs.getString("priority"));
		}
		else
		{
			session.removeAttribute("adminname");
			session.removeAttribute("priority");
		}
		%>
		<script language="javascript">
			top.location.href="index.html";
		</script>
		<%		
	}
	catch(Exception e)
	{
		session.setAttribute("error","1");
		session.removeAttribute("adminname");
		session.removeAttribute("priority");
	}
	finally
	{
		try
		{
			db.closeDB();
			rs.close();
		}
		catch(Exception ee)
		{
			session.setAttribute("error","1");
			session.removeAttribute("username");
			session.removeAttribute("priority");
		}
	}
%>