高校科研管理系统与公司合作中的商标技术实现

class Trademark:

def __init__(self, name, registration_number, application_date, applicant):

self.name = name

self.registration_number = registration_number

self.application_date = application_date

self.applicant = applicant

def display(self):

print(f"商标名称：{self.name}")

print(f"注册号：{self.registration_number}")

print(f"申请日期：{self.application_date}")

print(f"申请人：{self.applicant}")

def update_applicant(self, new_applicant):

self.applicant = new_applicant

import sqlite3

def create_table():

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

cursor = conn.cursor()

cursor.execute('''

CREATE TABLE IF NOT EXISTS trademarks (

id INTEGER PRIMARY KEY AUTOINCREMENT,

name TEXT NOT NULL,

registration_number TEXT NOT NULL,

application_date TEXT NOT NULL,

applicant TEXT NOT NULL

)

''')

conn.commit()

conn.close()

def insert_trademark(name, registration_number, application_date, applicant):

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

cursor = conn.cursor()

cursor.execute('''

INSERT INTO trademarks (name, registration_number, application_date, applicant)

VALUES (?, ?, ?, ?)

''', (name, registration_number, application_date, applicant))

conn.commit()

conn.close()

# 示例调用

create_table()

insert_trademark("智能算法", "TM20241001", "2024-05-10", "某科技公司")

from flask import Flask, request, jsonify

import jwt

import datetime

app = Flask(__name__)

SECRET_KEY = 'your_secret_key'

def generate_token(user_id, role):

payload = {

'user_id': user_id,

'role': role,

'exp': datetime.datetime.utcnow() + datetime.timedelta(hours=1)

}

token = jwt.encode(payload, SECRET_KEY, algorithm='HS256')

return token

def verify_token(token):

try:

payload = jwt.decode(token, SECRET_KEY, algorithms=['HS256'])

return payload

except jwt.ExpiredSignatureError:

return None

except jwt.InvalidTokenError:

return None

@app.route('/login', methods=['POST'])

def login():

# 假设用户登录逻辑

username = request.json.get('username')

password = request.json.get('password')

if username == 'admin' and password == '123456':

token = generate_token(1, 'admin')

return jsonify({'token': token})

else:

return jsonify({'error': 'Invalid credentials'}), 401

@app.route('/trademarks', methods=['GET'])

def get_trademarks():

token = request.headers.get('Authorization')

if not token:

return jsonify({'error': 'Missing token'}), 401

payload = verify_token(token)

if not payload:

return jsonify({'error': 'Invalid token'}), 401

if payload['role'] != 'admin':

return jsonify({'error': 'Permission denied'}), 403

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

cursor = conn.cursor()

cursor.execute('SELECT * FROM trademarks')

results = cursor.fetchall()

conn.close()

return jsonify(results)

if __name__ == '__main__':

app.run(debug=True)

def update_trademark(trademark_id, new_applicant, version):

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

cursor = conn.cursor()

cursor.execute('''

UPDATE trademarks

SET applicant = ?, version = version + 1

WHERE id = ? AND version = ?

''', (new_applicant, trademark_id, version))

conn.commit()

conn.close()