login_m_deal.jsp

这是我老师布置一个学习任务：保险管理系统

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<jsp:useBean id="connDB" scope="page" class="beans.connDB"/>
<% 
      
       
       String name=request.getParameter("name");
       String pwd=request.getParameter("pwd");
      
       try{
          
          
          ResultSet rs=connDB.executeQuery("select * from admin where admin_name like"+" "+"'"+name+"'"+"and admin_password like"+" "+"'"+pwd+"'"); 
          if(!rs.next()){
		   response.sendRedirect("error.jsp");
		   rs.close();
          
           connDB.close();
          }else
           response.sendRedirect("index.jsp");
         
        
        }
        catch(SQLException e){
          e.printStackTrace();
        }
      
      
      
 %>