医院科研管理系统

import sqlite3

# 连接数据库

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

cursor = conn.cursor()

# 查询论文数量

cursor.execute("SELECT COUNT(*) FROM papers")

paper_count = cursor.fetchone()[0]

print(f"论文总数: {paper_count}")

# 关闭连接

conn.close()

cursor.execute("SELECT project_name, status, COUNT(*) FROM projects GROUP BY project_name, status")

results = cursor.fetchall()

排课系统源码

for row in results:

print(f"项目: {row[0]}, 状态: {row[1]}, 数量: {row[2]}")