## 封裝 * 觀察前面的文件發現，除了sql語句及參數不同，其它語句都是一樣的 * 創建MysqlHelper.py文件，定義類 ~~~ #encoding=utf8 import MySQLdb class MysqlHelper(): def __init__(self,host,port,db,user,passwd,charset='utf8'): self.host=host self.port=port self.db=db self.user=user self.passwd=passwd self.charset=charset def connect(self): self.conn=MySQLdb.connect(host=self.host,port=self.port,db=self.db,user=self.user,passwd=self.passwd,charset=self.charset) self.cursor=self.conn.cursor() def close(self): self.cursor.close() self.conn.close() def get_one(self,sql,params=()): result=None try: self.connect() self.cursor.execute(sql, params) result = self.cursor.fetchone() self.close() except Exception, e: print e.message return result def get_all(self,sql,params=()): list=() try: self.connect() self.cursor.execute(sql,params) list=self.cursor.fetchall() self.close() except Exception,e: print e.message return list def insert(self,sql,params=()): return self.__edit(sql,params) def update(self, sql, params=()): return self.__edit(sql, params) def delete(self, sql, params=()): return self.__edit(sql, params) def __edit(self,sql,params): count=0 try: self.connect() count=self.cursor.execute(sql,params) self.conn.commit() self.close() except Exception,e: print e.message return count ~~~ ## 添加 * 創建testInsertWrap.py文件，使用封裝好的幫助類完成插入操作 ~~~ #encoding=utf8 from MysqlHelper import * sql='insert into students(sname,gender) values(%s,%s)' sname=raw_input("請輸入用戶名：") gender=raw_input("請輸入性別，1為男，0為女") params=[sname,bool(gender)] mysqlHelper=MysqlHelper('localhost',3306,'test1','root','mysql') count=mysqlHelper.insert(sql,params) if count==1: print 'ok' else: print 'error' ~~~ ## 查詢一個 * 創建testGetOneWrap.py文件，使用封裝好的幫助類完成查詢最新一行數據操作 ~~~ #encoding=utf8 from MysqlHelper import * sql='select sname,gender from students order by id desc' helper=MysqlHelper('localhost',3306,'test1','root','mysql') one=helper.get_one(sql) print one ~~~ ## python3代碼： ~~~ #!/usr/bin/env python # -*- coding: utf-8 -*- ''' @Time : 5/15/18 12:16 AM @Author : haibo @File : MysqlHelper.py ''' from pymysql import * class MysqlHelper(object): def __init__(self, host, port, db, user, passwd, charset="utf8"): self.host = host self.port = port self.db = db self.user = user self.passwd = passwd self.charset = charset def open(self): self.conn = connect(host=self.host, port=self.port, db=self.db, user=self.user, passwd=self.passwd, charset=self.charset) self.cursor = self.conn.cursor() def close(self): self.cursor.close() self.conn.close() def cud(self, sql, params): try: self.open() self.cursor.execute(sql, params) self.conn.commit() self.close() except Exception as e: print(e.message) def all(self, sql, params=[]): try: self.open() self.cursor.execute(sql, params) result = self.cursor.fetchall() self.close() return result except Exception as e: print(e.message) def one(self, sql, params=[]): try: self.open() self.cursor.execute(sql, params) result = self.cursor.fetchone() self.close() return result except Exception as e: print(e.message) ~~~