HELP.. LOGIN IN JSP USING MYSQLYOG

pixlucas

[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]