python 增删改查数据库封装_python之MySQL学习——简单的增删改查封装

importpymysql as ps2

3 classMysqlHelper:4 def __init__(self, host, user, password, database, charset):5 self.host =host6 self.user =user7 self.password =password8 self.database =database9 self.charset =charset10 self.db =None11 self.curs =None12 #数据库连接

13 defopen(self):14 self.db = ps.connect(host=self.host, user=self.user, password=self.password,database=self.database, charset=self.charset)15 self.curs =self.db.cursor()16 #数据库关闭

17 defclose(self):18 self.curs.close()19 self.db.close()20 #数据增删改

21 defcud(self, sql, params):22 self.open()23 try:24 self.curs.execute(sql, params)25 self.db.commit()26 print("ok")27 except:28 print(‘cud出现错误‘)29 self.db.rollback()30 self.close()31 #数据查询

32 deffind(self, sql, params):33 self.open()34 try:35 result =self.curs.execute(sql, params)36 self.close()37 print("ok")38 returnresult39 except:40 print(‘find出现错误‘)

2.数据查询(引入封装类)

1 from MysqlHelper importMysqlHelper2

3 mh = MysqlHelper(‘localhost‘, ‘root‘, ‘123456‘, ‘test‘, ‘utf8‘)4 sql = "select * from user where name=%s"

5 print(mh.find(sql, ‘小明‘))

3.数据修改(引入封装类)

1 from MysqlHelper importMysqlHelper2

3 mh = MysqlHelper(‘localhost‘, ‘root‘, ‘123456‘, ‘test‘, ‘utf8‘)4 sql = "insert into user(name,password) values(%s,%s)"

5 mh.cud(sql, (‘小光‘, ‘123456‘))

python之MySQL学习——简单的增删改查封装

标签：错误   database   ams   nbsp   close   insert   .exe   llb   ase

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：http://www.cnblogs.com/xiaomingzaixian/p/7126869.html