python连接mysql

浅浅的花香味﹌ 2022-02-14 12:50 178阅读 0赞

python连接mysql,实验思路：

1.  创建一个类，对应是mysql数据库里表，该类的实例就是一行数据
2.  利用遍历，生成一些数据列表
3.  遍历列表，插入到数据库
4.  查看数据库，是否操作成功
    
        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()  # 关闭连接
    
    结果：![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Nvbmd4aWFvbGluZ2Jhb2Jhbw_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3Nvbmd4aWFvbGluZ2Jhb2Jhbw_size_16_color_FFFFFF_t_70]: /images/20220214/8eae26a13b454b9b9ec5ca01c28e7ceb.png