UC知道JSP菜鸟求助
来源：百度知道 编辑：UC知道 时间：2024/05/07 07:02:42
我的目的是想让它转到注册页面...
代码:
<%
String name =request.getParameter("User");
String pswd =request.getParameter("Pswd");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:login");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from Userinfo where Account='"+name+"' and Pswd='"+pswd+"'");
if(rs.next())
out.print("欢迎登录");
else
out.print("请注册后登录！");
response.sendredirect("regist.htm");
rs.close();
stmt.close();
conn.close();
%>
错误INFO:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperExc
代码:
<%
String name =request.getParameter("User");
String pswd =request.getParameter("Pswd");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn=DriverManager.getConnection("jdbc:odbc:login");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("select * from Userinfo where Account='"+name+"' and Pswd='"+pswd+"'");
if(rs.next())
out.print("欢迎登录");
else
out.print("请注册后登录！");
response.sendredirect("regist.htm");
rs.close();
stmt.close();
conn.close();
%>
错误INFO:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperExc
if(rs.next()) {
out.print(\"欢迎登录\");
rs.close();
stmt.close();
conn.close();
}else {
out.print(\"请注册后登录！\");
rs.close();
stmt.close();
conn.close();
response.sendRedirect(\"regist.htm\");
%>
上面的改了一下，主要是调用方法名称错误，应该为response.sendRedirect();
关闭数据库连接我想应该是转向新页面之前，不然就执行不了那后面的关闭数据库连接的代码了。
嘻嘻，我也是个菜鸟，不知道是否正确..
补充：如果是这样，
else{
out.println("请注册后登录！");
out.println("<meta http-equiv=\"refresh\" content=\"3;URL=regist.htm\">");
}