关于登录验证连接数据库的问题！

Question

rs.next()
{
if(userName.equals(rs.getString(1)) && password.equals(rs.getString(2)))
...
....

Answer 1

看看咯。String sql="select * from test";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
if(userName.equals(rs.getString(1)) && password.equals(rs.getString(2))) { %>
<jsp:forward page="Hello.jsp"/>
<%} else {%>
<jsp:forward page="error.jsp"/>
<% } %>
<%rs.close();
stmt.close();
conn.close();
}
%>

Answer 2

这样我试过，就要抛出
Full compiler error(s):
C:\bea\user_projects\mydomain\myserver\.wlnotdelete\JBuilder_WebRun_JBuilder_DefaultWebApp_2325874\jsp_servlet\__test.java:101: password is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
            String password=""; //[ /test.jsp; Line: 11]
                   ^
1 error