医院科研管理系统

import sqlite3

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

c = conn.cursor()

c.execute('''CREATE TABLE projects

(id INTEGER PRIMARY KEY, title TEXT, description TEXT, startDate DATE, endDate DATE)''')

c.execute('''CREATE TABLE documents

(id INTEGER PRIMARY KEY, title TEXT, type TEXT, date DATE, url TEXT, projectId INTEGER, FOREIGN KEY(projectId) REFERENCES projects(id))''')

conn.commit()

conn.close()

]]>

import tkinter as tk

from tkinter import messagebox

def add_project():

# 添加项目到数据库的函数

pass

root = tk.Tk()

root.title("科研信息管理系统")

frame = tk.Frame(root)

frame.pack(padx=10, pady=10)

tk.Label(frame, text="项目名称").grid(row=0, column=0)

project_name_entry = tk.Entry(frame)

project_name_entry.grid(row=0, column=1)

tk.Button(frame, text="添加项目", command=add_project).grid(row=1, columnspan=2)

root.mainloop()

]]>

def search_project():

query = project_name_entry.get()

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

c = conn.cursor()

c.execute("SELECT * FROM projects WHERE title LIKE ?", ('%' + query + '%',))

results = c.fetchall()

conn.close()

if results:

messagebox.showinfo("结果", str(results))

else:

messagebox.showinfo("结果", "未找到匹配的项目")

]]>