python连接mysql,实验思路:
- 创建一个类,对应是mysql数据库里表,该类的实例就是一行数据
- 利用遍历,生成一些数据列表
- 遍历列表,插入到数据库
- 查看数据库,是否操作成功
import MySQLdb # 定义类,一个实例对应数据库里的一行数据 class Item(object): def __init__(self, positionname, positionlink, positiontype, peoplenum, worklocation, publictime): self.positionname = positionname self.positionlink = positionlink self.positiontype = positiontype self.peoplenum = peoplenum self.worklocation = worklocation self.publictime = publictime # 创建数据,返回列表 def createDataset(num): list = [] for i in range(num): x = str(i) item = Item(x, x, x, x, x, x) list.append(item) return list list = createDataset(10) # 连接数据库,遍历列表插入数据 conn = MySQLdb.connect(host='localhost', port=3306, user='root', passwd='chunyan', db='chunyan') cur = conn.cursor() for item in list: sql = "insert into tencentinfo values(\'%s\',\'%s\',\'%s\',\'%s\',\'%s\',\'%s\')" % ( item.positionname, item.positionlink, item.positiontype, item.peoplenum, item.worklocation, item.publictime) try: cur.execute(sql) conn.commit() except: conn.rollback() cur.close() # 关闭游标 conn.commit() # 提交事务 conn.close() # 关闭连接
结果: