完整java用户登陆代码
完整java用户登陆代码
login.网页特效p/网页特效p.html target=_blank >jsp教程登录,输入数据库教程中保存的用户名和密码 为何不能跳转到login_success.jsp页面?
person表里有三个字段:id,name,password.
login.jsp:
<%@ page contenttype="text/html;charset=gb2312"%>
<html>
<body>
<center>
<form action="login_conf.jsp" method="post">
<table width="50%" border="1">
<tr>
<td colspan="2">用户登录</td>
</tr>
<tr>
<td>用户名:</td>
<td><input type="text" name="id"></td>
</tr>
<tr>
<td>密 码:</td>
<td><input type="password" name="password"></td>
</tr>
<tr>
<td colspan="2">
<input type="submit" value="登录">
<input type="reset" value="重置">
</td>
</tr>
</table>
</form>
</body>
</html>
login_conf.jsp:
<%@ page contenttype="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<% out.print("oksssss");
string dbdriver ="oracle.jdbc.driver.oracledriver";
string dburl ="jdbc:oracle:thin:@localhost:1521:js";
string dbuser ="scott";
string dbpassword ="tiger";
connection conn =null;
preparedstatement ps教程tmt =null;
resultset rs =null;
%>
<%
boolean flag = false;
string id=request.getparameter("id");
string password = request.getparameter("password");
%>
<%
string sql = "select name from person values id = ?and password = ?";
// out.print(flag);
try
{
class.forname(dbdriver);
conn=drivermanager.getconnection(dburl,dbuser,dbpassword);
pstmt=conn.preparestatement(sql);
pstmt.setstring(1,id);
pstmt.setstring(2,password);
rs=pstmt.executequery();
if(rs.next())
{
flag=true;
session.setattribute("uname",rs.getstring(1));
}
else
{
request.setattribute("err","错误的用户名或密码!");
}
rs.close();
pstmt.close();
conn.close();
}
catch(exception e)
{
}
%>
<%
if(flag)
{
%>
<jsp:forward page="login_success.jsp"/>
<%
}
else
{
%>
<jsp:forward page="login.jsp"/>
<%
}
%>
</body>
</html>
login_success.jsp:
<%@ page contenttype="text/html;charset=gb2312"%>
<html>
<body>
<%
if(session.getattribute("uname")!=null);
{
%>
<h2>登录成功!</h2>
<h2>欢迎
<font color="#ff0000" size="12">
<%=session.getattribute("uname")%>
</font>
光临mldn留言!</h2>
<%
}
else
{
response.setheader("refresh","2;url=login.jsp");
%>
您还未登录,请先<a href="login.jsp">登录!</a>
<%
}
%>
</body>
</html>
补充:Jsp教程,Java基础