JSP登录页面，红色字体一部分报错，求解
日期：2014-05-17 浏览次数：20802 次
JSP登录页面，红色字体部分报错，求解。
<%@ page language="java" contentType="text/html; charset=GBK"%>
<%@ page import="csai.db.DBConn,java.sql.*;" %>
<%Connection conn=DBConn.createDBConn(); %>
<%
String adminusername=request.getParameter("adminusername");
String admineserpassword=request.getParameter("adminuserpassword");
String action=request.getParameter("action");
String errormsg=new String();
if("login".equals(action)){
String sql="select * from adminuser where adminusername=? and adminuserpassword=?";
PreparedStatement state=conn.prepareStatement(sql);
state.setString(1,adminusername);
state.setString(2,adminuserpassword);//错误信息：adminuserpassword cannot be resolved to a variable
ResultSet rs=state.executeQuery();
if(rs.next()){//如果用户名登陆正确
session.setAttribute("adminusername", adminusername);
session.setAttribute("adminuserrole",rs.getString("adminuserrole"));
response.sendRedirect("index.jsp");
}else{
errormsg="用户名或密码输入错误";
}
}
%>
<html>
<head>
<title>教师管理系统登录</title>
</head>
<body>
<br><br><br><br>
<div align="center">
<form method="post" action="login.jsp">
<table border="1" cellpandding="0" cellspacing="0"
style="border-collapse:collapse" bordercolor="#c0c0c0" width="300">
<tr>
<td width="100%" bgcolor="#c0c0c0" align="center">
<font color="#0000FF">用户登录</font></td>
</tr>
<%if(errormsg!=null&&errormsg.length()!=0){ %>
<tr>
<td align="center">
<%=errormsg%>
</tr>
<%}%>
<tr>
<td>
请输入用户名：<input type="text" name="adminusername"><br>
请输入密码：<input type="password" name="adminuserpassword"><br>
选择身份：<select name="role">
<option value="管理员">管理员</option>
<option value="培训机构">培训机构</option>
<option value="教师">教师</option>
<input type="submit" value="提交">
<input type="hidden" name="action" value="login">
</td>
</tr>
</table>
</form>
</div>
</body>
</html>
<%DBConn.closeConn(conn); %>
------解决方案--------------------
String admineserpassword=request.getParameter("adminuserpassword");
拼写
------解决方案--------------------
state.setString(2,adminuserpassword);//错误信息：adminuserpassword cannot be resolved to a variable
将“adminuserpassword”改为“admineserpassword”
------解决方案--------------------
<%@ page language="java" contentType="text/html; charset=GBK"%>
<%@ page import="csai.db.DBConn,java.sql.*;" %>
<%Connection conn=DBConn.createDBConn(); %>
<%
String adminusername=request.getParameter("adminusername");
String admineserpassword=request.getParameter("adminuserpassword");
String action=request.getParameter("action");
String errormsg=new String();
if("login".equals(action)){
String sql="select * from adminuser where adminusername=? and adminuserpassword=?";
PreparedStatement state=conn.prepareStatement(sql);
state.setString(1,adminusername);
state.setString(2,adminuserpassword);//错误信息：adminuserpassword cannot be resolved to a variable
ResultSet rs=state.executeQuery();
if(rs.next()){//如果用户名登陆正确
session.setAttribute("adminusername", adminusername);
session.setAttribute("adminuserrole",rs.getString("adminuserrole"));
response.sendRedirect("index.jsp");
}else{
errormsg="用户名或密码输入错误";
}
}
%>
<html>
<head>
<title>教师管理系统登录</title>
</head>
<body>
<br><br><br><br>
<div align="center">
<form method="post" action="login.jsp">
<table border="1" cellpandding="0" cellspacing="0"
style="border-collapse:collapse" bordercolor="#c0c0c0" width="300">
<tr>
<td width="100%" bgcolor="#c0c0c0" align="center">
<font color="#0000FF">用户登录</font></td>
</tr>
<%if(errormsg!=null&&errormsg.length()!=0){ %>
<tr>
<td align="center">
<%=errormsg%>
</tr>
<%}%>
<tr>
<td>
请输入用户名：<input type="text" name="adminusername"><br>
请输入密码：<input type="password" name="adminuserpassword"><br>
选择身份：<select name="role">
<option value="管理员">管理员</option>
<option value="培训机构">培训机构</option>
<option value="教师">教师</option>
<input type="submit" value="提交">
<input type="hidden" name="action" value="login">
</td>
</tr>
</table>
</form>
</div>
</body>
</html>
<%DBConn.closeConn(conn); %>
jsp
------解决方案--------------------
String admineserpassword=request.getParameter("adminuserpassword");
拼写
------解决方案--------------------
state.setString(2,adminuserpassword);//错误信息：adminuserpassword cannot be resolved to a variable
将“adminuserpassword”改为“admineserpassword”
------解决方案--------------------
state.s
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
