随机成语

复制import sqlite3
import random

# 从成语数据库随机取一条
DB_PATH = "chengyu.db"

def random_chengyu():
    conn = sqlite3.connect(DB_PATH)
    cursor = conn.cursor()
    cursor.execute("SELECT idiom, pinyin, meaning FROM idioms ORDER BY RANDOM() LIMIT 1")
    row = cursor.fetchone()
    conn.close()
    return {"idiom": row[0], "pinyin": row[1], "meaning": row[2]}

result = random_chengyu()
print(result["idiom"])       # 如：画蛇添足
print(result["pinyin"])      # huà shé tiān zú
print(result["meaning"])     # 比喻做了多余的事，反而不好

复制package main

import (
	"database/sql"
	"fmt"
	"log"
	"math/rand"
	"time"

	_ "github.com/mattn/go-sqlite3"
)

func main() {
	rand.Seed(time.Now().UnixNano())

	db, err := sql.Open("sqlite3", "chengyu.db")
	if err != nil {
		log.Fatal(err)
	}
	defer db.Close()

	// 随机取一条成语
	var idiom, pinyin, meaning string
	err = db.QueryRow("SELECT idiom, pinyin, meaning FROM idioms ORDER BY RANDOM() LIMIT 1").Scan(&idiom, &pinyin, &meaning)
	if err != nil {
		log.Fatal(err)
	}

	fmt.Printf("成语：%s\n拼音：%s\n释义：%s\n", idiom, pinyin, meaning)
}

复制// 浏览器端：从预加载的成语数组随机取一条
const idioms = [
  { idiom: '画蛇添足', pinyin: 'huà shé tiān zú', meaning: '比喻做了多余的事，反而不好' },
  { idiom: '井底之蛙', pinyin: 'jǐng dǐ zhī wā', meaning: '比喻见识狭窄的人' },
  { idiom: '掩耳盗铃', pinyin: 'yǎn ěr dào líng', meaning: '比喻自己欺骗自己' }
];

function getRandomIdiom() {
  const index = Math.floor(Math.random() * idioms.length);
  return idioms[index];
}

const result = getRandomIdiom();
console.log(result.idiom);   // 如：画蛇添足
console.log(result.pinyin);  // huà shé tiān zú

// 复制到剪贴板
navigator.clipboard.writeText(result.idiom).then(() => {
  console.log('已复制到剪贴板');
}).catch(err => {
  console.error('复制失败:', err);
});