import pymysql

pyoracle

1、连接上mysql ip 端口号 密码 账号 数据库

2、建立游标

3、执行sql

4、获取结果

5、关闭连接、关闭游标

打开仓库大门

conn = pymysql.connect(host='211.149.218.16',
user='jxz',passwd='123456',#port这里一定要写int类型
port=3306,db='jxz',charset='utf8') #charset必须写utf8，不能写utf-8
cur = conn.cursor(cursor=pymysql.cursors.DictCursor) #建立游标，游标你就认为是仓库管理员

sql = "INSERT INTO bt_stu ( real_name, sex, phone, class, type) VALUES ('小黑', '1', '18612341241', '靠山屯', '1');"

name='zdq'
sex='0'

sql = "INSERT INTO new_seq (blue, red, date) VALUES ( '%s', '%s', '%s');" % (random_blue_str, random_red_str, time)

sql = "select * from bt_stu where real_name='%s';"%name
print(sql)
cur.execute(sql) #执行sql语句
res2=cur.execute("select * from bt_stu where real_name=%s and sex=%s",(name,sex))
print(res2)

res = cur.fetchall() #只获取一条结果,它的结果是一个1维元组

print(cur.execute('select * from bt_stu where real_name=%s and sex = %s',(name,sex))) #可以防止sql注入

print(res)

cur.close() #关闭游标
conn.close() #关闭连接