程序运行截图:
mysql代码:
CREATE TABLE `article` (
`id` int(11) NOT NULL,
`article_time` varchar(50) DEFAULT NULL,
`article_volume` varchar(20) DEFAULT NULL,
`article_author` varchar(2000) DEFAULT NULL,
`article_name_english` varchar(2000) DEFAULT NULL,
`article_name_chinese` varchar(2000) DEFAULT NULL,
`article_content_english` varchar(5000) DEFAULT NULL,
`article_content_chinese` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
python代码:
import random
import re
import requests
import pymysql
# 打开数据库连接
db = pymysql.connect(host='localhost',
port=8080,
user='root',
passwd='123',
db='students',
charset='utf8')
# 使用 curs