import sqlite3
# 创建商标数据库
def create_database():
conn = sqlite3.connect('trademark.db')
cursor = conn.cursor()
cursor.execute('''
CREATE TABLE IF NOT EXISTS trademark (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
application_date DATE,
status TEXT DEFAULT 'Pending'
)
''')
conn.commit()
conn.close()
create_database()
]]>
# 插入新商标记录
def add_trademark(name, date):
conn = sqlite3.connect('trademark.db')
cursor = conn.cursor()
cursor.execute('INSERT INTO trademark (name, application_date) VALUES (?, ?)', (name, date))
conn.commit()
conn.close()
# 示例调用
add_trademark('ExampleCorp', '2023-10-01')
]]>
# 查询商标状态
def get_trademark_status(name):
conn = sqlite3.connect('trademark.db')
cursor = conn.cursor()
cursor.execute('SELECT status FROM trademark WHERE name = ?', (name,))
result = cursor.fetchone()
conn.close()
return result[0] if result else None
# 示例调用
status = get_trademark_status('ExampleCorp')
print(f'Trademark status: {status}')
]]>
