医院科研管理系统

import sqlite3

def insert_project(conn, project):

sql = ''' INSERT INTO projects(name,leader,start_date,end_date)

VALUES(?,?,?,?) '''

cur = conn.cursor()

cur.execute(sql, project)

return cur.lastrowid

def insert_task(conn, task):

sql = ''' INSERT INTO tasks(project_id,name,start_date,end_date,status)

VALUES(?,?,?,?,?) '''

cur = conn.cursor()

cur.execute(sql, task)

# 创建连接

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

c = conn.cursor()

# 插入项目

project = ('崇左项目', '张三', '2023-01-01', '2023-12-31')

project_id = insert_project(conn, project)

# 插入任务

tasks = [

(project_id, '任务一', '2023-01-01', '2023-02-01', '进行中'),

(project_id, '任务二', '2023-02-01', '2023-03-01', '未开始'),

]

for task in tasks:

insert_task(conn, task)

conn.commit()

conn.close()

]]>