chkadmin.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ include file="conn.jsp"%>
<%
	String sql;
String username=request.getParameter("Username");
String password1=request.getParameter("Password");

sql="select * from scott.admin where username='"+username+"'"; 
ResultSet rs_lar=stmt.executeQuery(sql); 
    if(rs_lar.next()){
	   if(rs_lar.getString("password").equals(password1)){
		   session.putValue("admin",rs_lar.getString("username"));
		  out.print("<script>");
			out.print("parent.menu.location='left.jsp';");
			out.print("window.location='main.jsp';");
			out.print("</script>");

	   }else{
			out.print("<script>alert('对不起,密码不正确');history.go(-1);</script>");
	   }
	}else{
		out.print("<script>alert('对不起,用户名不正确');history.go(-1);</script>");	
	}


%>