web测试常用python代码——mysql连接以及语句执行
- #coding=utf-8
- '''''
- Created on 2012-3-5
- @author: xxx
- '''
- import MySQLdb
- dbadd = '127.0.0.1'
- dbusr = 'root'
- dbpwd = '123'
- dbport = 3306
- dbname = 'test'
- //连接数据库
- self.conn = MySQLdb.connect(host = dbadd, user = dbusr, passwd = dbpwd, port = dbport, charset = 'utf8')
- self.conn.select_db(dbname)
- self.cursor = self.conn.cursor()
- //执行语句
- stri = sentence[:sentence.find(' ')]
- self.cursor.execute(sentence)
- if stri == 'select':
- result = self.cursor.fetchall()
- for i in result:
- print('%s\n' % i)
- return result
- elif stri == 'update' or stri == 'insert' or stri == 'delete':
- self.conn.commit()