python_数据库(增删查改)

使用python对数据库进行操作的总结：

import random
from pymysql import cursors,connect

conn=connect(host='127.0.0.1',
             user='root',
             password='admin',
             db='test',
             charset='utf8',
             cursorclass=cursors.DictCursor)

students_num=100

###函数区#####
def random_name():
    t_name_len = random.randint(3, 10)
    t_name=""
    for i in range(t_name_len):
        if i == 0:
            t_name=t_name+chr(random.randint(97, 122)).upper()
        else:
            t_name = t_name + chr(random.randint(97, 122))
    return t_name
###函数区#####

try:
    with conn.cursor() as cursor:
        ###创建表
        create_sql = 'create table students(num INT NULL AUTO_INCREMENT,' \
                                                'name VARCHAR(12) default NULL,' \