<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%> <%@ page language ="java" import="java.sql.*" %>

STUDENT LOGIN
USER_ID
PASSWORD

<% String user=request.getParameter("t1"); String pass=request.getParameter("t2"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:abc", "scott", "tiger"); Statement st=con.createStatement(); ResultSet rs=st.executeQuery("select stud_id,pwd from student"); while(rs.next()) { String username=rs.getString(1); String password=rs.getString(2); if(user.equals(username) && pass.equals(password)) { %> <% } } if(rs.isLast()==true) { out.println("Login Failed,Please try Again"); } }catch(Exception e1) {} %>