python資料庫操作

標籤：har   sts   cal   class   str   sel   插入資料   for   exists   

如果是jar來做，那麼第一件事就是要jar包嘍，用pip安裝pymysql（註：我用的是python 3.5）

import os, sys, stringimport pymysql # 串連資料庫　try:    #conn = pymysql.connect(host=‘localhost‘,user=‘root‘,passwd=‘root‘,db=‘test‘,charset=‘utf8‘)    conn = pymysql.connect(host=‘127.0.0.1‘,port=3306,user=‘root‘,passwd=‘root‘,db=‘test‘,charset=‘utf8‘)except Exception as e:    print(e)    sys.exit() # 擷取cursor對象來進行操作 cursor = conn.cursor()# 建立表sql = "create table if not exists test1(name varchar(128) primary key, age int(4))"cursor.execute(sql)# 插入資料sql = "insert into test1(name, age) values (‘%s‘, %d)" % ("zhaowei", 23)try:    cursor.execute(sql)except Exception as e:    print(e) sql = "insert into test1(name, age) values (‘%s‘, %d)" % ("張三", 21)try:    cursor.execute(sql)except Exception as e:    print(e)# 插入多條 sql = "insert into test1(name, age) values (%s, %s)"val = (("李四", 24), ("王五", 25), ("洪六", 26))try:    cursor.executemany(sql, val)except Exception as e:    print(e) #查詢出資料sql = "select * from test1"cursor.execute(sql)alldata = cursor.fetchall()# 如果有資料返回，就迴圈輸出, alldata是有個二維的列表if alldata:    for rec in alldata:        print(rec[0], rec[1]) conn.commit() cursor.close() conn.close()

據說python 3之後異常捕獲要這樣寫except Exception as e:，之前是except Exception， e:

 

python資料庫操作