class Trademark:
def __init__(self, name, registration_number, category, validity_period):
self.name = name
self.registration_number = registration_number
self.category = category
self.validity_period = validity_period
def display_info(self):
return f"商标名称: {self.name}, 注册号: {self.registration_number}, 类别: {self.category}, 有效期: {self.validity_period}"
]]>
import sqlite3
# 创建数据库连接
conn = sqlite3.connect('university.db')
cursor = conn.cursor()
# 创建商标表
cursor.execute('''
CREATE TABLE IF NOT EXISTS trademarks (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
registration_number TEXT UNIQUE,
category TEXT,
validity_period TEXT
)
''')
# 插入商标信息
def insert_trademark(trademark):
cursor.execute('''
INSERT INTO trademarks (name, registration_number, category, validity_period)
VALUES (?, ?, ?, ?)''',
(trademark.name, trademark.registration_number, trademark.category, trademark.validity_period))
conn.commit()
# 示例数据
t = Trademark("健康之光", "123456", "医药", "2023-2033")
insert_trademark(t)
# 查询所有商标
cursor.execute("SELECT * FROM trademarks")
rows = cursor.fetchall()
for row in rows:
print(row)
]]>
# 校友查询商标
def search_trademarks_by_alumni(alumni_id):
cursor.execute('SELECT * FROM trademarks WHERE id = ?', (alumni_id,))
return cursor.fetchall()
# 假设校友ID为1
results = search_trademarks_by_alumni(1)
for result in results:
print(result)
]]>