import pymysql

pyoracle

1、連接上mysql ip 端口號 密碼 賬號 數(shù)據(jù)庫

2、建立游標

3、執(zhí)行sql

4、獲取結(jié)果

5、關(guān)閉連接、關(guān)閉游標

打開倉庫大門

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) #執(zhí)行sql語句
res2=cur.execute("select * from bt_stu where real_name=%s and sex=%s",(name,sex))
print(res2)

res = cur.fetchall() #只獲取一條結(jié)果,它的結(jié)果是一個1維元組

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

print(res)

cur.close() #關(guān)閉游標
conn.close() #關(guān)閉連接