消息推送系统

import sqlite3

# 创建数据库连接

conn = sqlite3.connect('tender_info.db')

c = conn.cursor()

# 创建表

c.execute('''CREATE TABLE TENDER_INFO

(ID INT PRIMARY KEY NOT NULL,

PROJECT_NAME TEXT NOT NULL,

TENDER_NO TEXT NOT NULL,

DEADLINE TEXT NOT NULL);''')

# 插入数据

c.execute("INSERT INTO TENDER_INFO (ID,PROJECT_NAME,TENDER_NO,DEADLINE) \

师生综合服务门户

VALUES (1, '桥梁建设项目', 'TEN-001', '2023-10-01')");

conn.commit()

conn.close()