[b]THE ERROR:[/b]
[code]org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 21 in the jsp file: /registration.jsp
Duplicate local variable rs
18: Class.forName("com.mysql.jdbc.Driver");
19: Connection con =DriverManager.getConnection ("jdbc:mysql://localhost:8080/dbstudent", "root", "");
20: Statement stmt = con.createStatement();
21: ResultSet rs = stmt.executeQuery("Select * from tbladmin where user='" + user + "'");
22: while(rs.next())
23: {
24: if(pass.equals(rs.getString("pass")))
[/code]
[b]MY CODE:[/b]
[code]<%@ page import="java.sql.*,java.io.*" %>
Registration
<%
String user = request.getParameter("username");
String pass = request.getParameter("pass");
try {
Class.forName("com.mysql.jdbc.Driver");
Connection con =DriverManager.getConnection ("jdbc:mysql://localhost/dbstudent", "root", "");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("Select * from tbladmin where user='" + user + "'");
while(rs.next())
{
if(pass.equals(rs.getString("pass")))
{
%>
Registration
Student No:
Name:
Gender:
Male
Female
Course:
<%
}
else
out.println("Incorrect Password");
}
rs.close();
stmt.close();
con.close();
}
catch (SQLException e)
{
throw new ServletException("Servlet Could not display records.", e);
}
%>
[/code]