python之连接数据库
import pymysql import traceback
#获得链接 def get_conn(): conn = pymysql.connect( host="localhost", user="root", passwd="", db="news", charset="utf8" ) cursor = conn.cursor() return conn, cursor #关闭连接 def close_conn(conn, cursor): if cursor: cursor.close() if conn: conn.close() #查 def query(sql,*args): conn, cursor = get_conn() cursor.execute(sql, args) res = cursor.fetchall() close_conn(conn, cursor) return res
#增删改 def insql(sql, *args): conn, cursor = get_conn() cursor.execute(sql, args) close_conn(conn, cursor)
#更新 def update(sql, *args): conn, cursor = get_conn() cursor.execute(sql, args) conn.commit() close_conn(conn, cursor)