import sqlite3

def create_connection(db_file):

""" 创建数据库连接 """

conn = None

try:

conn = sqlite3.connect(db_file)

print(f"成功连接到 SQLite 数据库版本 {sqlite3.version}")

except Exception as e:

print(e)

return conn

def create_table(conn):

""" 创建表 """

sql_create_projects_table = """

CREATE TABLE IF NOT EXISTS projects (

id INTEGER PRIMARY KEY,

name TEXT NOT NULL,

description TEXT

);

"""

try:

c = conn.cursor()

c.execute(sql_create_projects_table)

print("项目表已创建")

except Exception as e:

print(e)

def insert_project(conn, project):

""" 插入新项目 """

sql = ''' INSERT INTO projects(name,description)

VALUES(?,?) '''

cur = conn.cursor()

cur.execute(sql, project)

conn.commit()

return cur.lastrowid

def select_all_projects(conn):

招生管理平台

""" 查询所有项目 """

cur = conn.cursor()

cur.execute("SELECT * FROM projects;")

rows = cur.fetchall()

for row in rows:

print(row)

]]>