之前都是将数据存到了文档中或者excel中(排版很不好,稍后研究一下),今天尝试一下对数据库的操作……
先上代码吧:
class Mysql_Exe():
def _getconn(self):
try:
self.conn=pymysql.connect(host='127.0.0.1',user='root',passwd='123456',port=3306,db='mysql',charset='utf8')
except pymysql.Error as e:
print(e,'数据库连接失败')
def _closeconn(self):
try:
if self.conn:
self.conn.close()
except pymysql.Error as e:
print(e,'关闭数据库连接失败')
def insertData(self,item):
sql='insert into userInfo value(%s,%s,%s)'
try:
self._getconn()
cursor=