今天开始和大家讲解操作数据库了,是不是很激动了?其实我个人也是比较激动的,因为我写这篇文章时,也是我刚好学会的,那么,就带大家一起来看看吧。 首先你需要准备mysql数据库,同时需要配置好python和pip的环境变量(这个在第三章有讲),接下来直接看代码:
import pymysql
class MySqlDaoUtils(object):
# 初始换数据库连接信息
def __init__(self,host,port,user,passwd,db):
self.host = host
self.port = port
self.user = user
self.password = passwd
self.db = db
# 连接
def connectMysql(self):
try:
self.conn = pymysql.connect(host=self.host,port=self.port,user=self.user,passwd=self.password,db=self.db,charset='utf8')
self.cursor = self.conn.cursor()
except Exception as e:
print('connect mysql error.',e)
# 查询
def queryMysql(self,sql):
try:
self.cursor.execute(sql)
return self.cursor.fetchall()
except Exception as e:
print('query failed.',e)
# 插入
def insertMysql(self,sql):
try:
self.cursor.execute(sql)
self.conn.commit()
except Exception as e:
print("insert failed.",e)
self.conn.rollback()
def updateMysql(self,sql):
try:
self.cursor.execute(sql)
self.conn.commit()
except Exception as e:
print("update failed.",e)
self.conn.rollback()
def deleteMysql(self,sql):
try:
self.cursor.execute(sql)
self.conn.commit()
except Exception as e:
print("update failed.",e)
self.conn.rollback()
def closeMysql(self):
self.cursor.close()
self.conn.close()
注释都加载代码里,大家可以看一下,有不懂的地方或者遇到问题可以在下面留言,我会及时回复。 我们来看一下具体调用:
from com.demo.mysql.Demo6Main import MySqlDaoUtils
# 初始换并连接数据库
demo6 = MySQLCommand('127.0.0.1',3306,'root','root','meigaobao')
demo6.connectMysql()
# 查询用户
results = demo6.queryMysql("select * from emp_user")
for row in results: #逐条输出
print(row)
# 插入用户
demo6.insertMysql("insert into emp_user(id,uid) values('11','00001')")
# 修改用户
demo6.updateMysql("update emp_user set uid='00002'' where id='11'")
# 删除用户
demo6.deleteMysql("delete from emp_user where id='11'")
大家有空也可以自己手动尝试一下,切记脱离自己强代码! 下一章节,将会和大家一起学习python抓取数据了!