import pymysql
pyoracle
1沸柔、連接上mysql ip 端口號(hào) 密碼 賬號(hào) 數(shù)據(jù)庫
2性誉、建立游標(biāo)
3孝鹊、執(zhí)行sql
4坠宴、獲取結(jié)果
5、關(guān)閉連接吮龄、關(guān)閉游標(biāo)
打開倉庫大門
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) #建立游標(biāo)摆霉，游標(biāo)你就認(rèn)為是倉庫管理員
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é)果是一個(gè)1維元組
print(cur.execute('select * from bt_stu where real_name=%s and sex = %s',(name,sex))) #可以防止sql注入
print(res)
cur.close() #關(guān)閉游標(biāo)
conn.close() #關(guān)閉連接
