java?web實(shí)現(xiàn)簡(jiǎn)單登錄注冊(cè)功能全過程(eclipse，mysql)

更新時(shí)間：2022年07月08日 15:21:16 作者：LUf_y_

前期我們學(xué)習(xí)了javaweb項(xiàng)目用JDBC連接數(shù)據(jù)庫(kù),還有數(shù)據(jù)庫(kù)的建表功能,下面這篇文章主要給大家介紹了關(guān)于java?web實(shí)現(xiàn)簡(jiǎn)單登錄注冊(cè)功能的相關(guān)資料,需要的朋友可以參考下

1.工程文件

基本的文件布局，沒使用任何css文件，就是簡(jiǎn)單實(shí)現(xiàn)登錄注冊(cè)，頁(yè)面沒有做任何美化；

使用的是MySQL8.0.12，8一下的mysql鏈接代碼有微小差別，網(wǎng)上教程基本都是8一下的，隨便找找就能找到；

2.DBBean.java

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個(gè)人修改過，默認(rèn)的都是root，這部分就是鏈接數(shù)據(jù)庫(kù)的功能；

3.login.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>登錄頁(yè)面</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>賬號(hào)：</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="登&nbsp;&nbsp;&nbsp;錄">
		</form>
		<br><a  href="zhuce.jsp">沒有賬號(hào)？注冊(cè)</a>
	</div>
</body>
</html>

4.check.jsp

<%@ 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('密碼錯(cuò)誤');</script>");
			response.setHeader("refresh", "0;url=login.jsp");
		}
	}
	else{
		out.print("<script language='javaScript'> alert('賬號(hào)錯(cuò)誤');</script>");
		response.setHeader("refresh", "0;url=login.jsp");
	}
%>
</body>
</html>

5.zhuce.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>注冊(cè)</title>
</head>
<body>
	<div class="center" align="center">
		<h1>歡迎注冊(cè)</h1>
		<form action="zhuceck.jsp" method="post">
			<table border="0">
				<tr>
					<th>賬號(hào):</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="注&nbsp;&nbsp;&nbsp;冊(cè)">
		</form>
	</div>
</body>
</html>

6.zhuceck.jsp

<%@ 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('賬號(hào)已經(jīng)存在');</script>");
		response.setHeader("refresh", "0;url=zhuce.jsp");
	}
	else{
		db.stmt.executeUpdate(sqlc);
		response.sendRedirect("zhucesu.jsp");
	}
%>
</body>
</html>

7.success.jsp

<%@ 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>

8.zhucesu.jsp

<%@ 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">注冊(cè)成功，前往登錄</a>
</body>
</html>

9.數(shù)據(jù)庫(kù)創(chuàng)造

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');

結(jié)果（運(yùn)行l(wèi)ogin.jsp)

菜雞互啄??！

總結(jié)

到此這篇關(guān)于java web實(shí)現(xiàn)簡(jiǎn)單登錄注冊(cè)功能的文章就介紹到這了,更多相關(guān)javaweb實(shí)現(xiàn)登錄注冊(cè)內(nèi)容請(qǐng)搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家！

您可能感興趣的文章: