医院科研管理系统

import sqlite3

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

c = conn.cursor()

# 创建表格

c.execute('''CREATE TABLE IF NOT EXISTS results (

id INTEGER PRIMARY KEY AUTOINCREMENT,

title TEXT NOT NULL,

author TEXT NOT NULL,

type TEXT NOT NULL,

year INT)''')

conn.commit()

conn.close()

def add_result(title, author, rtype, year):

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

c = conn.cursor()

c.execute("INSERT INTO results (title, author, type, year) VALUES (?, ?, ?, ?)",

(title, author, rtype, year))

conn.commit()

conn.close()

add_result("机器学习新进展", "张三", "论文", 2023)

from pptx import Presentation

from pptx.util import Inches

prs = Presentation()

slide = prs.slides.add_slide(prs.slide_layouts[5])

title = slide.shapes.title

title.text = "科研成果展示"

bullet_slide_layout = prs.slide_layouts[1]

slide = prs.slides.add_slide(bullet_slide_layout)

shapes = slide.shapes

title_shape = shapes.title

body_shape = shapes.placeholders[1]

title_shape.text = "科研成果列表"

tf = body_shape.text_frame

tf.text = "论文: 机器学习新进展 - 张三"

prs.save('科研成果.pptx')