如何把验证页面的参数再传递给登录页面?
我想把a.jsp中输入的用户名和密码提交到b.jsp页面,在b.jsp中从数据库取出用户名和密码,然后在a.jsp中的table的单元格中显示出来.
问题1:
我在b.jsp中用session保存数据,但是在a.jsp不能成功显示
问题2:
该如何正确的在table的单元格中动态地输入数据?我这样写好像不行
代码如下:
a.jsp:
<%@ page contentType= "text/html; charset=gb2312 "%>
<html>
<body>
<center>
<form action= "b.jsp " method= "post " name= "form ">
<table width= "200 " border= "1 ">
<tr align= "center " >
<td> =session.getAttribute( "ok1 ")%> </td>
<td> <%=session.getAttribute( "ok2 ")%> </td>
</tr>
</table> <br>
<input type= "submit " name= "submit " value= "query "/>
<input type= "reset " value= "clear " /> <br>
<br>
username: <input type= "text " name= "name " /> <br>
userpassword: <input type= "password " name= "password " />
</form>
</center>
</body>
</html>
b.jsp:
<%@ page contentType= "text/html; charset=gb2312 "%>
<%@ page import= "java.sql.* "%>
<%
String name=request.getParameter( "name ");
String psw=request.getParameter( "password ");
try
{
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver ");
Connection con=DriverManager.getConnection( "jdbc:odbc:testdsn ", " ", " ");
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery( "select * from user where name= ' "+name+ " ' and password= ' "+psw+ " ' ");
if(rs.next())
{
String username=rs.getString( "name ");
String userpsw=rs.getString( "password ");
session.setAttribute( "ok1 ",username);
session.setAttribute( "ok2 ",userpsw);
}
}
catch(Exception e)
{
e.printStackTrace();
}
%>
------解决方案--------------------b里面登录完了你就没有回到a.jsp上去啊,难道你是点后退按钮回去的啊?
后面加一句response.sendRedirect( "a.jsp ")啊
------解决方案--------------------带参数的url应该可以。
------解决方案-------------------- <%@ page contentType= "text/html; charset=gb2312 "%>
<%@ page import= "java.sql.* "%>
<%
String name=request.getParameter( "name ");
String psw=request.getParameter( "password ");
session.setAttribute( "ok1 ", "1111111 ");
session.setAttribute( "ok2 ", "22222 ");
response.sendRedirect( "./a.jsp ");
%>
我把你的b.jsp改成这样,也就是说,去掉的数据库操作部分而直接设置了session值,结果是可以在a.jsp中显示的,所以说这个跟session无关,你在b.jsp中把String username=rs.getString( "name ");
String userpsw=rs.getString( "password ");
的值打印出来,看看有没有取到
----