Javaweb 实现简单的用户注册登录（含数据库访问功能）
实现效果图：
登录界面：
登陆成功：
登陆失败：
注册界面：
注册成功：
1、登录界面login.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>登录</title>
</head>
<%
String error = request.getParameter("error");
if (error != null) {
out.print("<font color=red>" + error + "</font>");
}
%>
<body>
<form action="CheckLogin.jsp" method="post">
用户名：<input type="text" name="username" id=username> <br>
密码：<input type="password" name="password" id=password><br> <inputtype="submit" value="提交">
</form>
</body>
</html>
2、登录验证 Checklogin.jsp
<%@ page language="java" contentType="text/html" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<html>
<head>
<title>Checklogin</title>
</head>
<body>
<%
String username=new String(request.getParameter("username"));
String password=new String(request.getParameter("password"));
try {
// 加载数据库驱动，注册到驱动管理器
Class.forName("com.mysql.jdbc.Driver");
// 数据库连接字符串
String url = "jdbc:mysql://localhost:3308/database?user=root";
// 数据库用户名
String usename = "root";
// 数据库密码
String psw =null;
// 创建Connection连接
Connection conn = DriverManager.getConnection(url,usename,psw);
// 判断 数据库连接是否为空
if(conn != null){
String sql="select username from user where username='"+username+"' and password='"+ password + "'";
Statement stmt = conn.createStatement();
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
session.setAttribute("username",username);
response.sendRedirect("login_sucess.jsp");
}else{
out.print("用户名或密码错误，请重新输入！");
%>
<a href="javascript:history.back()">返回</a>
<%
}
// 关闭数据库连接
conn.close();
}else{
// 输出连接信息
out.println("数据库连接失败！");
}
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}%>
</body>
</html>
3、登录成功界面login_sucess.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<title>success</title>
</head>
<body>
welcome,<%=session.getAttribute("username") %>
</body>
</html>
4、注册界面register.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>register</title>
</head>
<body>
<form id="form2" name="form2" method="post" action="Checkregister.jsp">
用户名：
<label>
<input type="text" name="username1" />
</label>
<p>密码：
<label>
<input type="text" name="password1" />
</label>
</p>
<p>
<label>
<input type="submit" name="Submit" value="提交" />
</label>
</body>
</html>
5、注册验证 Checkregister.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Checkregister</title>
</head>
<body>
<%
String username=new String(request.getParameter("username1"));
String password=new String(request.getParameter("password1"));
// 数据库连接字符串
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3308/database?user=root";
// 数据库用户名
String usename = "root";
// 数据库密码
String psw =null;
Connection stmt=DriverManager.getConnection(url,usename,psw);
String sql="insert into user(username,password) values('"+username+"','"+password+"')";
Statement stmt1=stmt.createStatement();
stmt1.executeUpdate(sql);
request.getRequestDispatcher("register_success.jsp").forward(request, response);
%>
</body>
</html>
6、注册成功 register_success.jsp
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>register_success</title>
</head>
<body>
register,success!
<a href="login.jsp">前往登陆</a>
</body>
</html>
版权声明：本文为qq_50988206原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。