yuer1985的专栏

用户操作

[留言] [发消息] [加为好友]

订阅我的博客

[编辑]yuer1985的公告

[编辑]文章分类

[编辑]图片

存档

学习jsp笔记收藏

使用jsp处理用户注册和登录

登陆界面login:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>login.jsp</title>
</head>

<body>
<center>
<form method=post action="http://localhost:8080/jsp/test.jsp">
you's name:<input type=text name=username>
<br><br>
password:<input type=password name=pass>
<br><br>
<input type=submit value="注册">
</form>
<form method=get action="http://localhost:8080/jsp/test3.jsp">
username:<input type=text name=username>
<br><br>
password:<input type=password name=pass>
<br><br>
<input type=submit value="登陆">
</form>
<br>
</center>

</body>
</html>

注册信息插入数据库test.jsp:

<body>

<%@ page import="org.gjt.mm.mysql.*" %>
<%@ page import="java.util.*" %>
you's name is:<%=request.getParameter("username")%>
<br><br>
your password is:<%=request.getParameter("pass")%>
<br><br>
<%
String name=request.getParameter("username");
String pass=request.getParameter("pass");
try
{
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123");
PreparedStatement stat=conn.prepareStatement("insert into login values(?,?)");
stat.setString(1,name);
stat.setString(2,pass);
stat.executeUpdate();
out.println("<br><br><B>insert successful</B>");
}
catch(Exception e)
{
out.println(e);
}

%>
<b>Click here to view all people</b>
<form method=get action="http://localhost:8080/jsp/test2.jsp">
<input type=submit value="---＞">
</form>

</body>
</html>

处理注册成功并查询所有注册信息test2.jsp:

</body>
</html>

处理用户登录信息test3.jsp:

<body>
you's name is:<%=request.getParameter("username")%>
<br><br>
your password is:<%=request.getParameter("pass")%>
<br><br>
<%@ page language="java" import="java.sql.*"%>
<%
String name=request.getParameter("username");
String pass=request.getParameter("pass");
try
{
Class.forName("org.gjt.mm.mysql.Driver");
Connection dbcon=DriverManager.getConnection("jdbc:mysql://localhost/test?user=root&password=123");
PreparedStatement stat=dbcon.prepareStatement("select * from login where username=? and password=?");
stat.setString(1,name);
stat.setString(2,pass);
ResultSet result=stat.executeQuery();
if(result.next())
{
out.println("Login Successful");
}
else
{
out.println("Login Error");
}
}
catch(Exception e)
{
out.println(e);
}
%>
</body>
</html>