医院科研管理系统

import sqlite3

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

c = conn.cursor()

c.execute('''CREATE TABLE projects

(id INTEGER PRIMARY KEY, title TEXT, status TEXT, author TEXT)''')

conn.commit()

conn.close()

def add_project(title, status, author):

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

c = conn.cursor()

c.execute("INSERT INTO projects (title, status, author) VALUES (?, ?, ?)", (title, status, author))

conn.commit()

conn.close()

# Example usage

add_project("新型材料的研究", "进行中", "张老师")

def calculate_score(author):

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

c = conn.cursor()

c.execute("SELECT COUNT(*) FROM projects WHERE author=? AND status='完成'", (author,))

completed_projects = c.fetchone()[0]

c.execute("SELECT COUNT(*) FROM projects WHERE author=? AND status='完成' AND title LIKE '%论文%'", (author,))

published_papers = c.fetchone()[0]

score = completed_projects * 10 + published_papers * 5

conn.close()

return score

print(f"张老师的考核分数为: {calculate_score('张老师')}")