jsp登陆验证
<%@page import="java.util.*, java.sql.*" contentType="text/html;charset=GB2312" %>
<%
String username=new String(request.getParameter("username"));
String password=new String(request.getParameter("password"));
Class.forName("com.mysql.jdbc.Driver");
Connection con=DriverManager.getConnection("jdbc:mysql://192.168.1.100:3306/ecgdb","root","123456");
Statement stmt=con.createStatement();
String sql="select * from ecguser where account='"+usernam+"' and password='" + password + "'";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
String password=new String(rs.getString("password"));
if(password.equals(password))
{
session.setAttribute("root","root");
out.print("您已登录成功,本页面将于三秒钟后跳转至信息页面");
session.setAttribute("userinfo",username);
response.setHeader("Refresh","2;URL=viewpatient2.jsp");
}
else
{ response.sendRedirect("error.jsp");
}%>
出现错误
org.apache.jasper.JasperException: Unable to compile class for JSP
An error occurred at line: 2 in the jsp file: /login_useBean.jsp
Generated servlet error:
D:\Tomcat5.0\work\Catalina\localhost\mkhc1\org\apache\jsp\login_005fuseBean_jsp.java:54: cannot resolve symbol
symbol : variable usernam
location: class org.apache.jsp.login_005fuseBean_jsp
String sql="select * from ecguser where account='"+usernam+"' and password='" + password + "'";
^
An error occurred at line: 2 in the jsp file: /login_useBean.jsp
Generated servlet error:
D:\Tomcat5.0\work\Catalina\localhost\mkhc1\org\apache\jsp\login_005fuseBean_jsp.java:57: password is already defined in _jspService(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse)
String password=new String(rs.getString("password"));
^
2 errors
是怎么回事呢?请大家指教啊~~!!