数字化校园在职业学校的实现与应用

                import sqlite3

                # 连接数据库
                conn = sqlite3.connect('school.db')
                cursor = conn.cursor()

                # 查询学生信息
                cursor.execute("SELECT * FROM students")
                students = cursor.fetchall()

                # 数据清洗
                cleaned_students = []
                for student in students:
                    if student[2] != '':  # 假设学号为空则跳过
                        cleaned_students.append(student)

                # 输出清洗后的数据
                print(cleaned_students)
            

                const express = require('express');
                const app = express();

                // 定义路由
                app.get('/courses', (req, res) => {
                    res.send('Welcome to the Online Course Management System!');
                });

                // 启动服务器
                app.listen(3000, () => {
                    console.log('Server is running on port 3000');
                });