这是一个用Mysql数据库做储存方式的电话姓名管理程序,虽然简陋但是多多少少还是把Mysql的增删改查涵盖了……
OK。来,请看
首先我们先把MySQL和Python的连接过程以及会用到的增删改查都封装一下,这样代码不会显得太乱
而且感觉上去逼格高
import pymysql
class MysqlHelper(object):
def __init__(self, host='', user='', passwd='', db='', charset='utf8', port=3306):
self._host = host
self._user = user
self._passwd = passwd
self._db = db
self._charset = charset
self._port = port
def connect(self):
self._conn = pymysql.connect(
host=self._host,
user=self._user,
passwd=self._passwd,
db=self._db,
charset=self._charset,
port=self._port,
cursorclass=pymysql.cursors.DictCursor
)
self._cursor = self._conn.cursor()
def close(self):
self._cursor.close()
self._conn.close()
def __edit(self, sql, params=()):
resault = 0
try:
self.connect()
resault = self._cursor.execute(sql, params)
self._conn.commit()
self.close()