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() #关闭连接
