python中使用数据库mysql
1,安装:pip install pymysql
2, 原理:
3,代码
1),sql语句中有参数的
def selectDataFromMysql(self,sql, parm):
conn = pymysql.connect(host='xxx', user='xxx', passwd='xxx', db='xxx', charset='utf8')
cur = conn.cursor()
cur.execute(sql, parm)
result = cur.fetchall()
cur.close()
conn.close()
return result
2),sql语句中无参数的
def selectDataFromMysqlNoValue(self, sql):
conn = pymysql.connect(host=self.host, user=self.user, passwd=self.passwd, db=self.db, charset='utf8')
cur = conn.cursor()
cur.execute(sql)
result = cur.fetchall()
cur.close()
conn.close()
return result
3), 需要更改数据表的(和上面的区别在与,需要commit进行提交数据)
def insertDataToMysql(self,sql,parm):
conn = pymysql.connect(host=self.host, user=self.user, passwd=self.passwd, db=self.db, charset='utf8')
cur = conn.cursor()
cur.execute(sql,parm)
conn.commit()
cur.close()
conn.close()
4,总结
每次只需要传入sql语句,和参数就可以,非常方便