在线答题小程序制作

// 使用缓存机制
const cache = {};

function fetchData(url) {
  if (cache[url]) {
    return Promise.resolve(cache[url]);
  }
  return fetch(url)
    .then(response => response.json())
    .then(data => {
      cache[url] = data;
      return data;
    });
}

import sqlite3

conn = sqlite3.connect('quiz.db')
cursor = conn.cursor()

def save_answer(user_id, question_id, answer):
    try:
        cursor.execute('BEGIN TRANSACTION')
        cursor.execute('INSERT INTO answers (user_id, question_id, answer) VALUES (?, ?, ?)', (user_id, question_id, answer))
        conn.commit()
    except sqlite3.Error as e:
        conn.rollback()
        print(f"Error saving answer: {e}")