jsp登录失败或者成功跳转页面
<%@pagelanguage="java"contentType="text/html;charset=gb2312"pageEncoding="gb2312"%><%...
<%@ page language="java" contentType="text/html;charset=gb2312" pageEncoding="gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<html>
<body>
<%
String num=request.getParameter("snum");
String pass=request.getParameter("pass");
Class.forName ( "org.gjt.mm.mysql.Driver" ).newInstance ( );
String url = "jdbc:mysql://localhost/myjava";
Connection connection = DriverManager.getConnection ( url, "root","19950506" );
String sql = "select * from suser where Snum='" + num
+ "' and Password = '" + pass + "'";
Statement stmt = connection.createStatement ( );
ResultSet rs = stmt.executeQuery ( sql );
if ( rs.next ( ) )
{
out.println ( "登录成功！" );
}
else
{
out.println ( "用户名不存在或密码错误！" );
}
rs.close ( );
stmt.close ( );
connection.close ( );
%>
</body>
</html>
在调用数据库登录成功想跳转到一个。html文件，失败回到登录页，怎么实现。 展开
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<html>
<body>
<%
String num=request.getParameter("snum");
String pass=request.getParameter("pass");
Class.forName ( "org.gjt.mm.mysql.Driver" ).newInstance ( );
String url = "jdbc:mysql://localhost/myjava";
Connection connection = DriverManager.getConnection ( url, "root","19950506" );
String sql = "select * from suser where Snum='" + num
+ "' and Password = '" + pass + "'";
Statement stmt = connection.createStatement ( );
ResultSet rs = stmt.executeQuery ( sql );
if ( rs.next ( ) )
{
out.println ( "登录成功！" );
}
else
{
out.println ( "用户名不存在或密码错误！" );
}
rs.close ( );
stmt.close ( );
connection.close ( );
%>
</body>
</html>
在调用数据库登录成功想跳转到一个。html文件，失败回到登录页，怎么实现。 展开
2个回答
展开全部
在你成功和失败 if else 里面加这句 response.setHeader("Refresh","5;URL="111.html");
111.html 替换成你你要到的 登录页面和登录成功页面。
111.html 替换成你你要到的 登录页面和登录成功页面。
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
