自己在电脑上搭建了一个数据库,并用Python连接了一下,因为是刚搭建的,没有数据,就通过py生成了一些数据,写的比较粗糙。勿喷!废话不多说上代码!
import pymysql # 导入mysql库
import random # 随机数库导入
# 连接数据库
db = pymysql.connect(
host="localhost", # 要连接的主机地址
port=3306, # 端口,一般为 3306
user="root", # 用于登录的数据库用户
password="root", # 密码
database="mz", # 要连接的数据库
)
# 创建游标
result = db.cursor()
设置好数据库的连接地址后,后面就是随机要生成的表里面的数据了
#添加的数据是ID,姓名,性别,年龄
b = 10 #设置一个数方便while循环
while b <= 50: #b本身是10 这里会循环40次
b += 1
#设置两个列表分别是姓,和命
first_name = ["王", "李", "张", "刘", "赵", "蒋", "孟", "陈", "徐", "杨", "沈", "马", "高", "殷", "上官", "钟", "常"]
second_name = ["伟", "华", "建国", "洋", "刚", "万里", "爱民", "牧", "陆", "路", "昕", "鑫", "兵", "硕", "志宏", "峰", "磊", "雷", "文",
"明浩", "光", "超", "军", "达"]
# #这里随机姓和名列表里的汉字并相加到一起
nam = random.choice(first_name) + random.choice(second_name)
#print(nam)
Gender = "男女"
# #随机男女,并以字符串显示,每次只显示1个
suiji = "".join(random.sample(Gender, 1))
# #print(suiji)
# #随机年龄在17到33之间
acd = random.randint(17, 33)
# #print(acd)
# # 需执行的sql语句
# # execute执行sql
response = resul.execute(
"INSERT INTO `user`(id,`name`,gender,age) VALUES ('{}','{}','{}','{}')".format(b, nam, suiji, acd))#通过format把变量传给msql语句
data = resul.fetchall()
for i in data: #查询时返回数据好看一些
print(i)
# # 提交
db.commit()