当前位置：首页 > article >正文

express+mysql实现注册功能

article 2024/12/21 20:04:10

这里写自定义目录标题

app.js
register.html
success.html
初始化项目
mysql

app.js

const express = require("express");
const bodyParser = require("body-parser");
const mysql = require("mysql");
const path = require("path");
const app = express();
// app.use(bodyParser.urlencoded({ extended: false }));
app.use(bodyParser.json());
// 创建与数据库的连接
const connection = mysql.createConnection({
  host: 'localhost',
  user: 'root',
  password: 'wzbWZB123',
  database: 'register'
});
 
// 连接到数据库
connection.connect((err) => {
  if (err) throw err;
  console.log('连接数据库成功');
});
 
/**
 *  注册页面
 */
app.get("/", (req, res) => {
    res.sendFile(path.join(__dirname, "views", "register.html")); 
});
app.get("/success", (req, res) => {
  res.sendFile(path.join(__dirname, "views", "success.html")); 
}); 
/**
 *  注册接口
 */
app.post("/register", (req, res) => {  
    // 用户名,密码，性别，年龄，邮箱地址，注册时间
    const username = req.body.username;
    const password = req.body.password;
    const gender = req.body.gender;
    const age = req.body.age;
    const emailaddress = req.body.email;
    const registertime = new Date();
    		// 创建一个新用户
    		const user = {username, password,gender,age,emailaddress,registertime};
    		// 将新用户插入到数据库中
		    connection.query('INSERT INTO users SET ?', user, (err, result) => {
          if(err){
            if(err.code=="ER_DUP_ENTRY")
              res.json({success:false,message:"用户名重复"})
            else
              res.json({success:false,message:"未知错误"})
          }
          else{
            res.json({success:true,message:"注册成功"})
          } 
		    });
});
app.listen(8081, ()=> {
	console.log("http://127.0.0.1:8081");
})

register.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>注册</title>
    <style>
        body {
            background-color: #f1f1f1;
            font-family: Arial, sans-serif;
            margin: 0;
            padding: 0;
            display: flex;
            justify-content: center;
            align-items: center;
            height: 100vh;
        }
        .container {
            max-width: 90%;
            width: 500px;
            padding: 20px;
            background-color: #fff;
            border-radius: 5px;
            box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);
            box-sizing: border-box;
        }
        h2 {
            text-align: center;
            margin-bottom: 20px;
        }

        .form-group {
            margin-bottom: 15px;
        }

        label {
            display: block;
            font-weight: bold;
            margin-bottom: 5px;
        }

        input[type="text"],
        input[type="password"],
        select {
            width: calc(100% - 16px); /* Adjusted to account for padding */
            padding: 8px;
            border-radius: 4px;
            border: 1px solid #ccc;
            box-sizing: border-box;
        }
        button {
            width: 100%;
            padding: 10px;
            background-color: #4CAF50;
            color: #fff;
            border: none;
            border-radius: 4px;
            cursor: pointer;
            font-size: 16px;
        }
        button:hover {
            background-color: #45a049;
        }

        @media (max-width: 768px) {
            .container {
                width: 90%;
            }
        }
    </style>
</head>
<body>
    <div class="container">
        <h2>用户注册</h2>
        <form id="loginForm">
            <div class="form-group">
                <label for="username">用户名:</label>
                <input type="text" id="username" name="username" placeholder="请输入用户名" required>
            </div>
            <div class="form-group">
                <label for="password">密码:</label>
                <input type="password" id="password" name="password" placeholder="请输入密码" required>
            </div>
            <div class="form-group">
                <label for="confirm-password">确认密码:</label>
                <input type="password" id="confirm-password" name="confirm_password" placeholder="请输入确认密码" required>
            </div>
            <div class="form-group">
                <label for="gender">性别:</label>
                <select name="gender" id="gender">
                    <option value="F">女</option>
                    <option value="M">男</option>
                </select>
            </div>
            <div class="form-group">
                <label for="age">年龄:</label>
                <input type="text" id="age" name="age" placeholder="请输入年龄" required>
            </div>
            <div class="form-group">
                <label for="email">邮箱:</label>
                <input type="text" id="email" name="email" placeholder="请输入邮箱" required>
            </div>
            <div class="form-group">
                <label for="code">验证码:</label>
                <input type="text" id="code" name="code" placeholder="请输入验证码" required>
                <input type="text" id="verification-code" readonly style="width: 50%;float:left;margin-top:15px;margin-bottom:15px">
                <button type="button" onclick="createCode()" style="width: 40%;float:right;margin-top:15px;margin-bottom:15px">刷新验证码</button>
            </div>
            <button type="submit">注册</button>
        </form>
    </div>
    <script>
        // 设置一个全局的变量，便于保存验证码
        var code;

        function createCode() {
            // 首先默认code为空字符串
            code = '';
            // 设置长度，这里看需求，我这里设置了6
            var length = 6;
            var textValue = document.getElementById('verification-code');
            // 设置随机字符
            var arr = ['0', '1', '2', '3', '4', '5', '6', '7', '8', '9', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'];
            // 循环length次
            for (var i = 0; i < length; i++) {
                // 设置随机数范围, 因为数组的长度是36 所以 Math.random()*36  
                code += arr[Math.floor(Math.random() * 36)];
            }
            // 将拼接好的字符串赋值给展示的Value
            textValue.value = code;
        }

    //设置此处的原因是每次进入界面展示一个随机的验证码，不设置则为空
    window.onload = function (){
        createCode();
    }
        document.getElementById('loginForm').addEventListener('submit', async (e) => {
            e.preventDefault();
            const username = document.getElementById('username').value.trim();
            const password = document.getElementById('password').value.trim();
            const confirm_password = document.getElementById('confirm-password').value.trim();
            const gender = document.getElementById("gender").value.trim();
            const age = document.getElementById("age").value.trim();
            const email = document.getElementById("email").value.trim();
            const verification_code = document.getElementById("code").value.trim();
            // 验证码校验
            if (verification_code != code) {
                alert("验证码错误！");
                return;
            }
            // 表单校验
            if (!username || !password || !gender || !age || !email) {
                alert('所有内容都不能为空！');
                return;
            }
            // 两次密码校验
            if (password != confirm_password) {
                alert("两次密码输入不一致！");
                return;
            }
            // 邮箱校验
            if (!/^[a-zA-Z0-9_-]+@[a-zA-Z0-9_-]+(\.[a-zA-Z0-9_-]+)+$/.test(email)) {
                alert('邮箱格式不正确！');
                return;
            }
            // 用户名、密码长度校验
            if (username.length > 20 || password.length > 20) {
                alert('用户名和密码长度不能超过 20 个字符！');
                return;
            }
            // 发送请求
            const response = await fetch('/register', {
                method: 'POST',
                headers: { 'Content-Type': 'application/json' },
                body: JSON.stringify({ username, password, gender, age, email })
            });
            const result = await response.json();
            if (result.success) {
                window.location.href = 'success';
            } else {
                alert(result.message);
            }
        });
    </script>
</body>
</html>

success.html

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>Document</title>
</head>
<body>
    注册成功
</body>
</html>

初始化项目

npm init -y
npm install express
npm install mysql

mysql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 80040
Source Host           : localhost:3306
Source Database       : register

Target Server Type    : MYSQL
Target Server Version : 80040
File Encoding         : 65001

Date: 2024-12-20 09:27:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `UserID` int NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) NOT NULL,
  `Password` varchar(100) NOT NULL,
  `Gender` char(1) DEFAULT NULL,
  `Age` int NOT NULL,
  `EmailAddress` varchar(255) NOT NULL,
  `RegisterTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`UserID`),
  UNIQUE KEY `UserName` (`UserName`),
  CONSTRAINT `users_chk_1` CHECK ((`Gender` in (_utf8mb3'F',_utf8mb3'M'))),
  CONSTRAINT `users_chk_2` CHECK (((`Age` > 0) and (`Age` <= 150))),
  CONSTRAINT `users_chk_3` CHECK (regexp_like(`EmailAddress`,_utf8mb3'^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+.[A-Z|a-z]{2,}$'))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of users
-- ----------------------------

查看全文

http://www.kler.cn/a/445510.html