目录1.工程文件2.DBBean.java3.login.jsp4.check.jsp5.zhuce.jsp6.zhuceck.jsp7.success.jsp8.zhucesu.j
基本的文件布局，没使用任何CSS文件，就是简单实现登录注册，页面没有做任何美化；
使用的是Mysql8.0.12，8一下的mysql链接代码有微小差别，网上教程基本都是8一下的，随便找找就能找到；
package Bean;
import java.sql.*;
public class DBBean {
private String driverStr = "com.mysql.cj.jdbc.Driver";
private String connStr = "jdbc:mysql://localhost:3306/users?serverTimezone=UTC";
private String dbusername = "root";
private String dbpassWord = "lufengyu";
public Connection conn = null;
public Statement stmt = null;
public DBBean()
{
try
{
Class.forName(driverStr);
conn = DriverManager.getConnection(connStr,dbusername,dbpassword);
stmt = conn.createStatement();
}
catch(Exception ex) {
System.out.println(ex.getMessage());
System.out.println("mysql链接失败");
}
}
}dbusername和dbpassword个人修改过，默认的都是root，这部分就是链接数据库的功能；
<%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>登录页面</title>
</head>
<body>
<div class="center" align="center">
<h1 style="color:black">欢迎登录</h1>
<fORM id="indexform" name="indexForm" action="check.jsp" method="post">
<table border="0">
<tr>
<th>账号：</th>
<td><input type="text" name="username"></td>
</tr>
<tr>
<th>密码：</th>
<td><input type="password" name="password"></td>
</tr>
</table>
<br><input type="submit" value="登 录">
</form>
<br><a href="zhuce.jsp">没有账号？注册</a>
</div>
</body>
</html><%@ page import="java.sql.*" language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="db" class="Bean.DBBean" scope="page"/>
<%
request.setCharacterEncoding("utf-8");
String username=(String)request.getParameter("username");
String password=(String)request.getParameter("password");
String sql="select * from sky where username="+"'"+username+"'";
ResultSet rs = db.stmt.executeQuery(sql);
if(rs.next()){
if(password.equals(rs.getObject("password"))){
response.sendRedirect("success.jsp");
}
else{
out.print("<script language='javascript'> alert('密码错误');</script>");
response.setHeader("refresh", "0;url=login.jsp");
}
}
else{
out.print("<script language='javaScript'> alert('账号错误');</script>");
response.setHeader("refresh", "0;url=login.jsp");
}
%>
</body>
</html><%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>注册</title>
</head>
<body>
<div class="center" align="center">
<h1>欢迎注册</h1>
<form action="zhuceck.jsp" method="post">
<table border="0">
<tr>
<th>账号:</th>
<td><input type="text" name="username"></td>
</tr>
<tr>
<th>密码:</th>
<td><input type="password" name="password"></td>
</tr>
</table>
<br><input type="submit" value="注 册">
</form>
</div>
</body>
</html><%@ page language="java" import="java.util.*,java.sql.*" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title>Insert title here</title>
</head>
<body>
<jsp:useBean id="db" class="Bean.DBBean" scope="page"/>
<%
request.setCharacterEncoding("utf-8");
String username=(String)request.getParameter("username");
String password=(String)request.getParameter("password");
String sqlf="select * from sky where username ="+"'"+username+"'";
String sqlc="insert into `sky`(`username`,`password`) values ('"+username+"','"+password+"')";
ResultSet rs = db.stmt.executeQuery(sqlf);
if(rs.next()){
out.print("<script language='javascript'> alert('账号已经存在');</script>");
response.setHeader("refresh", "0;url=zhuce.jsp");
}
else{
db.stmt.executeUpdate(sqlc);
response.sendRedirect("zhucesu.jsp");
}
%>
</body>
</html><%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>登录成功</title>
</head>
<body style="text-align:center">
<h1>登陆成功</h1>
</body>
</html><%@ page language="java" contentType="text/html; charset=utf-8"
pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body style="text-align:center">
<br><a href="login.jsp">注册成功，前往登录</a>
</body>
</html>
CREATE TABLE `sky`
(
`id` int(5) NOT NULL AUTO_INCREMENT,
`username` VARCHAR(45) DEFAULT NULL,
`password` VARCHAR(45) DEFAULT NULL,
UNIQUE KEY `username_UNIQUE` (`username`),
PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `sky`(`id`,`username`,`password`)values
('1','admin','admin'),
('2','lfy','lufengyu');结果（运行login.jsp)
菜鸡互啄！！
到此这篇关于java WEB实现简单登录注册功能的文章就介绍到这了,更多相关javaweb实现登录注册内容请搜索编程网以前的文章或继续浏览下面的相关文章希望大家以后多多支持编程网！
--结束END--
本文标题: java web实现简单登录注册功能全过程(eclipse，mysql)
本文链接: https://www.lsjlt.com/news/153918.html(转载时请注明来源链接)
有问题或投稿请发送至: 邮箱/279061341@qq.com QQ/279061341
下载Word文档到电脑，方便收藏和打印～
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-12
2024-05-11
2024-05-11
2024-05-11
回答
回答
回答
回答
回答
回答
回答
回答
回答
回答
官方手机版
微信公众号
商务合作
0