登录界面为login.jsp,接收数据界面为getlogin.jsp,登录界面输入的信息完全正确,但是跳转不到相应的页面,大家帮忙解决一下:login.jsp代码:<form id="form1" name="form1" method="post" action="getlogin.jsp" onSubmit="return checks(this);">
用户名 : <input type="text" name="username" size="20">
密 码 :<input type="password" name="userpwd" size="20">
用户角色:
<input type="radio" name="userrole" value="教师"/> <span class="STYLE48">教师</span>
<input type="radio" name="userrole" value="学生" checked/> <span class="STYLE48">学生</span>
<input type="radio" name="userrole" value="管理员"/> <span class="STYLE48">管理员</span>
<input type="submit" value="登录">
<input type="reset" value="重置"></form>
接收数据getlogin.jsp代码:<%@ include file="db.jsp" %>
<%
String msg="";
String id=request.getParameter("username");
if(id==null)
{id="";}
byte b[]=id.getBytes("ISO-8859-1");
id=new String(b);
String idpwd=request.getParameter("userpwd");
String role=request.getParameter("userrole");
if(role==null)
{role="";}
byte c[]=role.getBytes("ISO-8859-1");
role=new String(c);
out.print(role);
String strSql=" select * from users where id='"+id+"' and idpwd='"+idpwd+"' and role='"+role+"'";
out.print(strSql);
ResultSet rs=stmt.executeQuery(strSql);
out.print(rs.next());
if(rs.next())
{
if(role.equals("管理员"))
{
session.setAttribute("result",id);
response.sendRedirect("administer.jsp");
}
if(role.equals("教师"))
{
session.setAttribute("result",id);
response.sendRedirect("teacher.jsp");
}
if(role.equals("学生"))
{
session.setAttribute("result",id);
response.sendRedirect("student.jsp");
}
}
else
{
String strMsg="您输入的用户名或密码不正确,请重新输入!";
%>
<script language="JavaScript" >
alert("<%=strMsg%>")
history.go(-1);
</script>
<%
}
%>当输入的信息完全正确是,为什么会跳出“您输入的用户名或密码不正确,请重新输入”的提示框;而且 out.print(rs.next());
会显示flase,为什么?
用户名 : <input type="text" name="username" size="20">
密 码 :<input type="password" name="userpwd" size="20">
用户角色:
<input type="radio" name="userrole" value="教师"/> <span class="STYLE48">教师</span>
<input type="radio" name="userrole" value="学生" checked/> <span class="STYLE48">学生</span>
<input type="radio" name="userrole" value="管理员"/> <span class="STYLE48">管理员</span>
<input type="submit" value="登录">
<input type="reset" value="重置"></form>
接收数据getlogin.jsp代码:<%@ include file="db.jsp" %>
<%
String msg="";
String id=request.getParameter("username");
if(id==null)
{id="";}
byte b[]=id.getBytes("ISO-8859-1");
id=new String(b);
String idpwd=request.getParameter("userpwd");
String role=request.getParameter("userrole");
if(role==null)
{role="";}
byte c[]=role.getBytes("ISO-8859-1");
role=new String(c);
out.print(role);
String strSql=" select * from users where id='"+id+"' and idpwd='"+idpwd+"' and role='"+role+"'";
out.print(strSql);
ResultSet rs=stmt.executeQuery(strSql);
out.print(rs.next());
if(rs.next())
{
if(role.equals("管理员"))
{
session.setAttribute("result",id);
response.sendRedirect("administer.jsp");
}
if(role.equals("教师"))
{
session.setAttribute("result",id);
response.sendRedirect("teacher.jsp");
}
if(role.equals("学生"))
{
session.setAttribute("result",id);
response.sendRedirect("student.jsp");
}
}
else
{
String strMsg="您输入的用户名或密码不正确,请重新输入!";
%>
<script language="JavaScript" >
alert("<%=strMsg%>")
history.go(-1);
</script>
<%
}
%>当输入的信息完全正确是,为什么会跳出“您输入的用户名或密码不正确,请重新输入”的提示框;而且 out.print(rs.next());
会显示flase,为什么?
这句sql 能查到数据不啊?