admin_check.jsp

用Jsp实现的图书管理系统代码

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ include file="ch.jsp" %>
<jsp:useBean id="admincheck" class="dbconnBean.Conndb" scope="page" />
<%
String name=request.getParameter("username");
String pwd=request.getParameter("password");
String sql="select * from admin"; 
ResultSet rs=admincheck.query(sql);
  while(rs.next())
  {
   if(name.equals(rs.getString(2))&&pwd.equals(rs.getString(3))){

   session.setAttribute("a",new Boolean("true"));
   session.setAttribute("username",name);
   response.sendRedirect("admin_index.jsp");

    }else{
		
	     out.print("<script>");
         out.print("alert('用户名或密码错误！');");
         out.print("history.back();");
         out.print("</script>");
   }
  }
	
%>