-- 创建数据库

CREATE DATABASE IF NOT EXISTS student_management;

USE student_management;

-- 创建学生信息表

CREATE TABLE IF NOT EXISTS student_info (

id INT AUTO_INCREMENT PRIMARY KEY,

name VARCHAR(50),

gender ENUM('M', 'F'),

major VARCHAR(100),

class_name VARCHAR(50)

) ENGINE=InnoDB;

-- 根据班级名分表

DELIMITER $$

CREATE PROCEDURE create_class_table(IN class_name_param VARCHAR(50))

BEGIN

SET @table_name = CONCAT('class_', class_name_param);

SET @sql_text = CONCAT('CREATE TABLE IF NOT EXISTS ', @table_name, ' LIKE student_info;');

PREPARE stmt FROM @sql_text;

EXECUTE stmt;

DEALLOCATE PREPARE stmt;

END$$

DELIMITER ;

CALL create_class_table('CS_2023');

]]>

const redis = require("redis");

const client = redis.createClient();

// 设置缓存

client.setex("student:1", 3600, JSON.stringify({id: 1, name: "Alice", major: "Computer Science"}));

// 获取缓存

client.get("student:1", (err, reply) => {

if (err) throw err;

console.log(JSON.parse(reply));

});

]]>