迎新系统与秦皇岛：一场科技与旅游的碰撞

                # 导入必要的库
                import sqlite3
                
                # 连接到SQLite数据库
                conn = sqlite3.connect('new_student.db')
                
                # 创建游标对象
                cursor = conn.cursor()
                
                # 创建学生表
                cursor.execute('''CREATE TABLE students (
                                    id INTEGER PRIMARY KEY,
                                    name TEXT NOT NULL,
                                    student_id TEXT NOT NULL UNIQUE,
                                    department TEXT NOT NULL)''')
                
                # 插入数据
                cursor.execute("INSERT INTO students (name, student_id, department) VALUES ('张三', '20230001', '计算机系')")
                
                # 查询数据
                cursor.execute("SELECT * FROM students WHERE student_id='20230001'")
                print(cursor.fetchall())
                
                # 提交事务并关闭连接
                conn.commit()
                conn.close()