mysqldb简单封装
- def getConn(host, user, pwd, db):
- conn = MySQLdb.Connect(host=host, user=user, passwd=pwd, db=db, charset="utf8", use_unicode="True")
- return conn
- def insert(sql, conn):
- cursor = conn.cursor()
- cursor.execute(sql)
- conn.commit()
- def update(sql, conn):
- cursor = conn.cursor()
- cursor.execute(sql)
- conn.commit()
- def selectRows(sql, conn):
- cursor = conn.cursor()
- cursor.execute(sql)
- conn.commit()
- rows = cursor.fetchone()
- return rows
- def closeConn(conn):
- conn.close()
- Conn = getConn(HOST, USER, PWD, DB)
来源: https://www.oschina.net/code/snippet_105637_58746